Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How do I keep rows a1-a2 always at top of screen when on row 50

How do I keep rows a1 and a2 always at top of screen even when I'm on row 50
or 75, etc.
I know it's a simple command but can't figure it out. I have older version
of Excel
thanks

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 506
Default How do I keep rows a1-a2 always at top of screen when on row 50

Place the cursor in A3 cell and press Alt+W+F (WindowFreeze Panes).

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Geri" wrote:

How do I keep rows a1 and a2 always at top of screen even when I'm on row 50
or 75, etc.
I know it's a simple command but can't figure it out. I have older version
of Excel
thanks

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
displaying specific rows on screen johnsail Excel Discussion (Misc queries) 1 October 6th 09 04:43 PM
Print has some blank rows but screen has data in rows marvelous p Excel Discussion (Misc queries) 1 February 9th 09 02:57 PM
Keeping Rows on the screen? trvlnmny New Users to Excel 1 May 25th 08 12:11 AM
Rows to repeat at top... ON SCREEN texansgal Excel Worksheet Functions 3 August 25th 06 03:21 PM
show rows on screen, but not print them Troy Piggins Excel Discussion (Misc queries) 2 August 18th 06 12:16 AM


All times are GMT +1. The time now is 01:18 AM.

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

About Us

"It's about Microsoft Excel"