ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Locking rows in Excel 97 (https://www.excelbanter.com/excel-discussion-misc-queries/90374-locking-rows-excel-97-a.html)

KJo

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!!!

Don Guillett

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!!!




KJo

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!!!





Don Guillett

Locking rows in Excel 97
 
pretty basic but glad to help

--
Don Guillett
SalesAid Software

"KJo" wrote in message
...
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