#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 694
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,533
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default 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

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default 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





  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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.

  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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

  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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

  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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

  #10   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stationary chart when scrolling bflorox Charts and Charting in Excel 2 October 22nd 08 08:51 AM
Stationary Row [email protected] Excel Discussion (Misc queries) 1 August 31st 08 10:29 PM
Stationary Header [email protected] Excel Discussion (Misc queries) 2 June 20th 08 09:29 PM
Making a column stationary Dennis Montgmery[_2_] Setting up and Configuration of Excel 1 June 2nd 08 05:34 PM
Stationary Column Kuch Excel Discussion (Misc queries) 2 May 22nd 05 08:43 PM


All times are GMT +1. The time now is 09:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"