|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 13th, 2010, 06:41 PM
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
May 13th, 2010, 06:49 PM
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
May 13th, 2010, 06:51 PM
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
May 13th, 2010, 06:54 PM
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
