View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bigdog Bigdog is offline
external usenet poster
 
Posts: 2
Default How to freeze 1 or more CELLS in spreadsheet?

Maybe I used the wrong term - by "freeze" I am trying to have three separate
cells float or remain in place as I scroll down the page much like the freeze
pane works.

"Max" wrote:

I am trying to freeze 3 different separate cells in a spreadsheet.
Is it possible and if so, how?


Some other thoughts.
Do you mean ...

Freeze = kill the formulas in the 3 cells
via "in-place" copy n paste special as values ?

or

Freeze = protect the cell(s)
via protecting the sheet (ToolsProtectionProtect Sheet) after setting only
the 3 cells with the "Locked" status checked in FormatCellsProtection tab
(and with the rest of the sheet unlocked). The sequence to set it would be to
select the entire sheet, uncheck the default "Locked" first, then CTRL+select
only the 3 cells, check "Locked". Then apply sheet protection.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---