ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   See the headings as I work down the page (https://www.excelbanter.com/excel-discussion-misc-queries/234712-see-headings-i-work-down-page.html)

Bold Grandmother

See the headings as I work down the page
 
I want to see the column headings as I work down the page. How do I set this
up?

Jacob Skaria

See the headings as I work down the page
 
If your header is in Row1

In 2003
Select cell A2
WindowFreeze Panes

In 2007
ViewFreeze PanesFreeze Top Row

--
If this post helps click Yes
---------------
Jacob Skaria


"Bold Grandmother" wrote:

I want to see the column headings as I work down the page. How do I set this
up?


Bold Grandmother[_2_]

See the headings as I work down the page
 
Thank you Jacob. That is what I wanted to accomplish.

"Jacob Skaria" wrote:

If your header is in Row1

In 2003
Select cell A2
WindowFreeze Panes

In 2007
ViewFreeze PanesFreeze Top Row

--
If this post helps click Yes
---------------
Jacob Skaria


"Bold Grandmother" wrote:

I want to see the column headings as I work down the page. How do I set this
up?


Ron de Bruin

See the headings as I work down the page
 
And If you use a Table in 2007 your column headers will automatic change to the
table headers when you work down the page. Very nice I think

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Jacob Skaria" wrote in message ...
If your header is in Row1

In 2003
Select cell A2
WindowFreeze Panes

In 2007
ViewFreeze PanesFreeze Top Row

--
If this post helps click Yes
---------------
Jacob Skaria


"Bold Grandmother" wrote:

I want to see the column headings as I work down the page. How do I set this
up?



All times are GMT +1. The time now is 04:47 AM.

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