| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I stop cells / rows from moving, scrolling?
Is there a way I can select a group of cells for example 1, 2, 3, 4, 5,
6 A through H and to have that bank of cells not move when I scroll down in my spreadsheet, in other words for those cells to always be visible? thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I stop cells / rows from moving, scrolling?
Hi!
So, you want A1:H6 to always be visible when you scroll down? Select cell A7 Goto the menu Window and select Freeze Panes Biff "paul" wrote in message ups.com... Is there a way I can select a group of cells for example 1, 2, 3, 4, 5, 6 A through H and to have that bank of cells not move when I scroll down in my spreadsheet, in other words for those cells to always be visible? thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I stop cells / rows from moving, scrolling?
thanks, worked great!
Biff wrote: Hi! So, you want A1:H6 to always be visible when you scroll down? Select cell A7 Goto the menu Window and select Freeze Panes Biff |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I stop cells / rows from moving, scrolling?
You're welcome!
Biff "paul" wrote in message oups.com... thanks, worked great! Biff wrote: Hi! So, you want A1:H6 to always be visible when you scroll down? Select cell A7 Goto the menu Window and select Freeze Panes Biff |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to delete rows and column cells that have formulas in. | Excel Worksheet Functions | |||
| Stop scrolling | Excel Discussion (Misc queries) | |||
| How to determine which rows contain slected cells in a multiple c. | Excel Worksheet Functions | |||
| Rows turn grey while scrolling | Excel Discussion (Misc queries) | |||
| Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions | |||
Linear Mode
