Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
solution wants
what is the freeze panes
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
solution wants
It is the ability to freeze the worksheet above the cell that is referenced
when the "freeze panes" option is clicked. It is good for tasks that involve scrolling through worksheets while needing to reference data at a portion of the spreadsheet that is at the top. Go to Window -- Freeze Panes to try it. Just remember that the sheet will be frozen above the cell that is referenced when the option is clicked. "shoyeb2045" wrote: what is the freeze panes |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
solution wants
What did Excel help tell you when you asked it about "freeze panes"? Which
parts of that didn't you understand? -- David Biddulph "shoyeb2045" wrote in message ... what is the freeze panes |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
solution wants
It will also freeze columns to the left of the cell selected.
So if you choose A2 and then freeze panes, row 1 will always be visible as you scroll down the sheet. If you were to choose B2 and then freeze panes, row 1 and column A would remain visible as you scroll down/across the worksheet. "scott" wrote: It is the ability to freeze the worksheet above the cell that is referenced when the "freeze panes" option is clicked. It is good for tasks that involve scrolling through worksheets while needing to reference data at a portion of the spreadsheet that is at the top. Go to Window -- Freeze Panes to try it. Just remember that the sheet will be frozen above the cell that is referenced when the option is clicked. "shoyeb2045" wrote: what is the freeze panes |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
solution wants
See help on "freeze panes"
Gord Dibben MS Excel MVP On Thu, 14 Aug 2008 11:49:01 -0700, shoyeb2045 wrote: what is the freeze panes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Web Solution | Excel Discussion (Misc queries) | |||
looking for a solution | Excel Worksheet Functions | |||
Need a pop up solution! | Excel Discussion (Misc queries) | |||
My solution | Excel Discussion (Misc queries) | |||
Solution please | Excel Discussion (Misc queries) |