ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   freezing a row (https://www.excelbanter.com/setting-up-configuration-excel/57969-freezing-row.html)

Seren

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."

Paul B

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."




Seren

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