Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to freeze 1 or more CELLS in spreadsheet?
I am trying to freeze 3 different separate cells in a spreadsheet. Is it
possible and if so, how? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to freeze 1 or more CELLS in spreadsheet?
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 WindowsFreeze panes area. -- Regards Roger Govier "Bigdog" wrote in message ... I am trying to freeze 3 different separate cells in a spreadsheet. Is it possible and if so, how? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to freeze 1 or more CELLS in spreadsheet?
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 --- |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to freeze 1 or more CELLS in spreadsheet?
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 On Jan 8, 12:14*pm, 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. * |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to freeze 1 or more CELLS in spreadsheet?
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 --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Freeze in the middle of a spreadsheet. | Excel Discussion (Misc queries) | |||
Fix/Freeze a spreadsheet | Excel Discussion (Misc queries) | |||
Can I freeze BOTH a column and a row in the same spreadsheet? | Excel Discussion (Misc queries) | |||
How do I freeze the top and side of a spreadsheet? | Excel Discussion (Misc queries) | |||
Large Spreadsheet - Freeze On Recalculate | Excel Worksheet Functions |