Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i prevent a row from moving, like subheader that is visibl
In Excel, how do I prevent a row from moving, like a subheader that I want to
stay always visible at the top of my document? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i prevent a row from moving, like subheader that is visibl
If you want row 1 to stay fixed, select row 2 & use Windows/ Freeze Panes.
If you want to freeze both rows and columns, if you select cell C3, for example, before selecting Windows/ Freeze Panes, then it will freeze rows 1 and 2 and columns A and B. In other words it will freeze rows above and columns to the left of the selected cell. -- David Biddulph "Binmaru" wrote in message ... In Excel, how do I prevent a row from moving, like a subheader that I want to stay always visible at the top of my document? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i prevent a row from moving, like subheader that is visibl
Binmaru
Place you curser below the row you want to see all the time and gotoWindowfreeze panes. Mike Rogers "Binmaru" wrote: In Excel, how do I prevent a row from moving, like a subheader that I want to stay always visible at the top of my document? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i prevent a row from moving, like subheader that is visibl
Hi,
If you are asking how to lock titles at the top of the screen - put your cursor on the row below the titles and choose Window, Freeze Panes. If you are trying to freeze other rows on screen while being able to scroll above or below them - there really is not way to do that. -- Cheers, Shane Devenshire "Binmaru" wrote: In Excel, how do I prevent a row from moving, like a subheader that I want to stay always visible at the top of my document? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arrow Keys Moving Window Frame instead of Moving Between Cells | Excel Discussion (Misc queries) | |||
HOW CAN I PREVENT EXCEL FILES FROM BEING DELETED OR PREVENT TRASH | Excel Discussion (Misc queries) | |||
How can I insert a subheader in Excel? | Excel Worksheet Functions | |||
How do I prevent Crtl+End moving to a cleared cell? | Excel Worksheet Functions | |||
How to prevent cursor from moving behind filled cells | Excel Discussion (Misc queries) |