![]() |
freezing a row
I am working on what will end up being a very long excel sheet. I have all
of my headings in the first row. I know that there is a way to keep this first row visible as the user scrolls down through the other rows, but I'm not sure how to do that. Can anyone help me out with this? Thanks a bunch! Seren -- "Behave like a duck- keep calm and unruffled on the surface but paddle like hell underneath." |
freezing a row
Seren, select A2 then window, freeze panes
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Seren" wrote in message ... I am working on what will end up being a very long excel sheet. I have all of my headings in the first row. I know that there is a way to keep this first row visible as the user scrolls down through the other rows, but I'm not sure how to do that. Can anyone help me out with this? Thanks a bunch! Seren -- "Behave like a duck- keep calm and unruffled on the surface but paddle like hell underneath." |
freezing a row
Thanks a bunch :)
Seren -- "Behave like a duck- keep calm and unruffled on the surface but paddle like hell underneath." "Paul B" wrote: Seren, select A2 then window, freeze panes -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Seren" wrote in message ... I am working on what will end up being a very long excel sheet. I have all of my headings in the first row. I know that there is a way to keep this first row visible as the user scrolls down through the other rows, but I'm not sure how to do that. Can anyone help me out with this? Thanks a bunch! Seren -- "Behave like a duck- keep calm and unruffled on the surface but paddle like hell underneath." |
All times are GMT +1. The time now is 12:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com