Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Christopher Zwolenski
 
Posts: n/a
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer
 
Posts: n/a
Default 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?

  #3   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default 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?



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
For Hector Miguel - Inserting page numbers in cell mato nanjin Excel Discussion (Misc queries) 0 December 30th 05 03:09 PM
Problem with Page Numbering Aurora Excel Discussion (Misc queries) 0 November 21st 05 02:10 PM
Page Numbers Aurora Excel Discussion (Misc queries) 0 November 17th 05 08:04 PM
Can't delete a page break Suhail Excel Discussion (Misc queries) 4 July 7th 05 06:49 PM
adding a new page break to an existing page break Edward Letendre Excel Discussion (Misc queries) 1 March 6th 05 09:29 AM


All times are GMT +1. The time now is 05:27 PM.

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"