ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   EXCEL (https://www.excelbanter.com/excel-discussion-misc-queries/148234-excel.html)

architect_1

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?

David Biddulph[_2_]

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?




Dave Peterson

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


All times are GMT +1. The time now is 08:38 PM.

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