| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping certain columns/rows visible
I know there's a way to keep certain columns or rows visible when you scroll
around the excel sheet, but I don't know what that's called or how to do it. Can anyone help? Many thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Keeping certain columns/rows visible
hi
you might be thinking of freeze panes. this is were you can keep a number of rows at the top and/or column at the left "frozen" while you scroll. just place the cellpointer at the place below the rows you want to freeze or to the right of the columns and... in 2003, on the menu barwindowfreeze panes. Regards FSt1 "MichaelPhilips" wrote: I know there's a way to keep certain columns or rows visible when you scroll around the excel sheet, but I don't know what that's called or how to do it. Can anyone help? Many thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Keeping certain columns/rows visible
It is called "Freeze Panes", you can see a video demonstration over he
http://www.free-training-tutorial.com/rows-columns.html "MichaelPhilips" wrote: I know there's a way to keep certain columns or rows visible when you scroll around the excel sheet, but I don't know what that's called or how to do it. Can anyone help? Many thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| keeping an auto shape or text box visible in an excel chart | Charts and Charting in Excel | |||
| How do I sort rows keeping columns together? | Excel Worksheet Functions | |||
| Chart Area visible but cannot access rows and columns on worksheet | Charts and Charting in Excel | |||
| Keeping first line visible | Excel Discussion (Misc queries) | |||
| keeping worksheet title visible during scrolling | Excel Worksheet Functions | |||
Linear Mode
