Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I fix the position of a row
I've seen in some spreadsheets that a fixed position row so that for
example, the position of the top row may be fixed so that the top row is visible while scrolling through the rest of the rows. Any idea how to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I fix the position of a row
It seems like you're referring to Feezing Panes
Select the row immediately BELOW the cells you want to stay visible From the Excel main menu: <window<freeze panes Does that help? *********** Regards, Ron XL2002, WinXP " wrote: I've seen in some spreadsheets that a fixed position row so that for example, the position of the top row may be fixed so that the top row is visible while scrolling through the rest of the rows. Any idea how to do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I fix the position of a row
wrote in message
oups.com... I've seen in some spreadsheets that a fixed position row so that for example, the position of the top row may be fixed so that the top row is visible while scrolling through the rest of the rows. Any idea how to do this? Click on the row below the ones you want fixed, then Window/ Freeze Panes. You can do the same with columns, so try clicking in the 3rd column, 4th row before you do Freeze Panes, and you'll have 2 columns & 3 rows fixed. -- David Biddulph |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I fix the position of a row
That's exactly what I was looking for.
Thanks to both of you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return position of 2nd, 3rd, ect occurrence of a character in a st | Excel Discussion (Misc queries) | |||
Comment Box Position & Pointer | Excel Discussion (Misc queries) | |||
XL97: Position text boxes (or data labels) w/out VBA | Charts and Charting in Excel | |||
find nth position of a string | Excel Discussion (Misc queries) | |||
how to change the default position of a comment box | Excel Discussion (Misc queries) |