Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you freeze in two directions in excel
Can you freeze in two direction in excel, along rows and colums?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you freeze in two directions in excel
EXCEL 2007
Yes, try this. Click in cell B2 then View / Window group / Freeze Panes / Freeze Panes Now scroll around and you should find that column A is always present as is row 1. If my comments have helped please hit Yes. "Amber" wrote: Can you freeze in two direction in excel, along rows and colums? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you freeze in two directions in excel
sure. select the cell to the right and below of where you want to freeze,
then pick "freeze pane" -- Best Regards, Luke M "Amber" wrote in message ... Can you freeze in two direction in excel, along rows and colums? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you freeze in two directions in excel
Yes. It will freeze everything above or to the left of the selected cell.
If you click in B3, for example, it will freeze rows 1 & 2, and column A. -- David Biddulph "Amber" wrote in message ... Can you freeze in two direction in excel, along rows and colums? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 freeze panes won't freeze top row only | Excel Discussion (Misc queries) | |||
Why does mouse scroll wheel change directions in Excel? | Excel Discussion (Misc queries) | |||
I m following directions and can't delete dup rows in excel | Excel Discussion (Misc queries) | |||
Lookup 2 directions | Excel Worksheet Functions | |||
How do I average wind directions using excel? | Excel Discussion (Misc queries) |