ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   top row stationary (https://www.excelbanter.com/excel-discussion-misc-queries/218324-top-row-stationary.html)

Joytrink

top row stationary
 
How do I keep a row stationary so it appears at the top of the page while I
scroll through my entire document

John[_22_]

top row stationary
 
Hi
To freeze the first row, click on the second row completly at the left side
so to highlight the complet row. Goto Window Freeze Panes.
HTH
John
"Joytrink" wrote in message
...
How do I keep a row stationary so it appears at the top of the page while
I
scroll through my entire document



Per Jessen

top row stationary
 
Hi

To freeze row 1, select A2 and goto Window Freeze panes.

If you want to freeze row 1 and column A then select B2 and follow
instructions above.

Hopes this helps.

---
Per

"Joytrink" skrev i meddelelsen
...
How do I keep a row stationary so it appears at the top of the page while
I
scroll through my entire document



Mike H

top row stationary
 
Hi,

Select A2 and then

Window|Freeze panes

Mike

"Joytrink" wrote:

How do I keep a row stationary so it appears at the top of the page while I
scroll through my entire document


David Biddulph[_2_]

top row stationary
 
Select the row below it, then Window/ Freeze Panes.
--
David Biddulph

"Joytrink" wrote in message
...
How do I keep a row stationary so it appears at the top of the page while
I
scroll through my entire document




Joytrink

top row stationary
 


"John" wrote:

Hi
To freeze the first row, click on the second row completly at the left side
so to highlight the complet row. Goto Window Freeze Panes.
HTH
John
"Joytrink" wrote in message
...
How do I keep a row stationary so it appears at the top of the page while
I
scroll through my entire document


Thanks so much John, that worked.


Joytrink

top row stationary
 


"Mike H" wrote:

Hi,

Select A2 and then

Window|Freeze panes

Mike

"Joytrink" wrote: Thank you Mike. I will make note of it for future use too.

How do I keep a row stationary so it appears at the top of the page while I
scroll through my entire document


Joytrink

top row stationary
 


"Per Jessen" wrote:

Hi

To freeze row 1, select A2 and goto Window Freeze panes.

If you want to freeze row 1 and column A then select B2 and follow
instructions above.

Hopes this helps.

---
Per

"Joytrink" skrev i meddelelsen
...
How do I keep a row stationary so it appears at the top of the page while
I
scroll through my entire document


Thank you Per, I appreciate your help


Joytrink

top row stationary
 


"David Biddulph" wrote:

Select the row below it, then Window/ Freeze Panes.
--
David Biddulph

"Joytrink" wrote in message
...
How do I keep a row stationary so it appears at the top of the page while
I
scroll through my entire document



Thank you David, I appreciate your help


David Biddulph[_2_]

top row stationary
 
Just a tiny point from future reference if you are new to thesenewsgroups.
Your reply has included your new text as if it were part of the quoted
material from my previous message, with the " " quoting indication. I see
that the same applies to your replies to other messages in this thread. To
avoid confusion in future it might be wise to ensure that your reply
distinguished between the new material and the quoted material.

It may also be worth noting that in these excel newsgroups at least, the
majority preference is for top-posting, in contrast to the usual usenet
preference for bottom-posting. It's not a big problem (and opinions vary
within the group), but it gets rather confusing if replies bounce to and fro
between top and bottom, as this message shows.
--
David Biddulph

"Joytrink" wrote in message
...


"David Biddulph" wrote:

Select the row below it, then Window/ Freeze Panes.
--
David Biddulph

"Joytrink" wrote in message
...
How do I keep a row stationary so it appears at the top of the page
while
I
scroll through my entire document



Thank you David, I appreciate your help





All times are GMT +1. The time now is 10:22 AM.

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