Cannot be done like you would "freeze panes"

See Pete_UK's solution.


Gord Dibben MS Excel MVP

On Thu, 8 Jan 2009 04:14:00 -0800, Bigdog
wrote:

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
---