Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking rows in Excel 97
I have seen excel sheets that do this but have yet to figure out how it's done.
I would like to have the first few rows (title rows) in a spreadsheet stay viewable (locked?) while scrolling rows under them, rather than having mulitple titles throughout the spreedsheet to see what the titles are. Anyone know how to do this? Thank you!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking rows in Excel 97
place your cursor below and to the right of the cells you want to maintain.
windowfreeze panes -- Don Guillett SalesAid Software "KJo" wrote in message ... I have seen excel sheets that do this but have yet to figure out how it's done. I would like to have the first few rows (title rows) in a spreadsheet stay viewable (locked?) while scrolling rows under them, rather than having mulitple titles throughout the spreedsheet to see what the titles are. Anyone know how to do this? Thank you!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking rows in Excel 97
Thank you! Why is everything so simple once you know how to do it? lol
"Don Guillett" wrote: place your cursor below and to the right of the cells you want to maintain. windowfreeze panes -- Don Guillett SalesAid Software "KJo" wrote in message ... I have seen excel sheets that do this but have yet to figure out how it's done. I would like to have the first few rows (title rows) in a spreadsheet stay viewable (locked?) while scrolling rows under them, rather than having mulitple titles throughout the spreedsheet to see what the titles are. Anyone know how to do this? Thank you!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting rows in a macro in Excel | Excel Discussion (Misc queries) | |||
How do I reduce number of Rows displayed in Excel worksheet? | Setting up and Configuration of Excel | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Updating rows - Excel Formula or Something Else? | Excel Worksheet Functions | |||
How do I import data into Excel that exceeds 70000 rows? | Excel Discussion (Misc queries) |