ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I keep rows a1-a2 always at top of screen when on row 50 (https://www.excelbanter.com/excel-discussion-misc-queries/264676-how-do-i-keep-rows-a1-a2-always-top-screen-when-row-50-a.html)

Geri[_2_]

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


Ms-Exl-Learner

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



All times are GMT +1. The time now is 02:40 PM.

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