![]() |
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!!! |
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!!! |
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!!! |
All times are GMT +1. The time now is 03:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com