#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default EXCEL

In excel, how do I creat a static row at the top of my document, meaning when
I scrowl down, the headings of the colums remain at the top?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default EXCEL

Select row 2, Window/ Freeze Panes
--
David Biddulph

"architect_1" wrote in message
...
In excel, how do I creat a static row at the top of my document, meaning
when
I scrowl down, the headings of the colums remain at the top?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default EXCEL

You use Window|freeze panes.

All the rows above the activecell will be frozen.
All the columns to the left of the activecell will be frozen.

So if you want to always see rows 1:2 and columns A:C,
You'd select A1 (just to make sure it's visible)
then select D3
then window|freeze panes.



architect_1 wrote:

In excel, how do I creat a static row at the top of my document, meaning when
I scrowl down, the headings of the colums remain at the top?


--

Dave Peterson
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



All times are GMT +1. The time now is 03:12 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"