ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Question (https://www.excelbanter.com/excel-discussion-misc-queries/74374-excel-question.html)

vladexodus

Excel Question
 
I am trying to make the header row stay put so when I scroll down the page
with the rest of the information the header does not move. Any help is
greatly apreciated.
Thanks

Gary''s Student

Excel Question
 
Click the row BELOW the header and then pull-down:

Window Freeze panes.
--
Gary's Student


"vladexodus" wrote:

I am trying to make the header row stay put so when I scroll down the page
with the rest of the information the header does not move. Any help is
greatly apreciated.
Thanks


Duke Carey

Excel Question
 
Look in the help file for "Freeze panes"

"vladexodus" wrote:

I am trying to make the header row stay put so when I scroll down the page
with the rest of the information the header does not move. Any help is
greatly apreciated.
Thanks


Niek Otten

Excel Question
 
Select cell A2

WindowsFreeze Panes

--
Kind regards,

Niek Otten

"vladexodus" wrote in message
...
I am trying to make the header row stay put so when I scroll down the page
with the rest of the information the header does not move. Any help is
greatly apreciated.
Thanks




Ron Coderre

Excel Question
 
Try this:

Select the cell that is immediately below the header row.
From the Excel Main menu: Window|Freeze Panes

Example:
if you select cell B2, then Window|Freeze Panes
Col_A and Row_1 will always be visible.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"vladexodus" wrote:

I am trying to make the header row stay put so when I scroll down the page
with the rest of the information the header does not move. Any help is
greatly apreciated.
Thanks



All times are GMT +1. The time now is 02:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com