How to freeze 1 or more CELLS in spreadsheet?

  • Thread starter Thread starter Bigdog
  • Start date Start date
B

Bigdog

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

Try using the Camera Tool to show the contents of the cells at a fixed
location at the to of your sheet, above a Windows>Freeze panes area.
 
I am trying to freeze 3 different separate cells in a spreadsheet.
Is it possible and if so, how?
Click to expand...

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 (Tools>Protection>Protect Sheet) after setting only
the 3 cells with the "Locked" status checked in Format>Cells>Protection 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
---
 
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.
 
Can't you just have simple links to those cells positioned in the top
row, and then use the Freeze Panes facility to have the top row always
visible?

Hope this helps.

Pete
 
Cannot be done like you would "freeze panes"

See Pete_UK's solution.


Gord Dibben MS Excel MVP
 
Back
Top