ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do you keep one row on top as you page down? (https://www.excelbanter.com/excel-discussion-misc-queries/96407-how-do-you-keep-one-row-top-you-page-down.html)

Christopher Zwolenski

how do you keep one row on top as you page down?
 
I came across an excel sheet that kept the first row on top as you paged down
to assist in defing what each column was as you scrolled down. How do you do
that?

bpeltzer

how do you keep one row on top as you page down?
 
Highlight row 2, then from the menu bar: Window Freeze Panes. The row(s)
above your selection will be locked in place as you scroll.

"Christopher Zwolenski" wrote:

I came across an excel sheet that kept the first row on top as you paged down
to assist in defing what each column was as you scrolled down. How do you do
that?


Biff

how do you keep one row on top as you page down?
 
Hi!

To keep row 1 always visible as you scroll down:

Select cell A2
Goto WindowFreeze Panes

Biff

"Christopher Zwolenski" <Christopher
wrote in message ...
I came across an excel sheet that kept the first row on top as you paged
down
to assist in defing what each column was as you scrolled down. How do you
do
that?





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

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