ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Column headers (https://www.excelbanter.com/excel-discussion-misc-queries/78895-column-headers.html)

Tommy

Column headers
 
I have 7 columns with different titles, when I scroll down the page how do I
keep the titles on top of each column so you can see what you are looking at.



Column headers
 
Hi

Select the first cell under your headings, in column A. Go to Window/Freeze
Panes.

Andy.

"Tommy" wrote in message
...
I have 7 columns with different titles, when I scroll down the page how do
I
keep the titles on top of each column so you can see what you are looking
at.




David Biddulph

Column headers
 
"Tommy" wrote in message
...
I have 7 columns with different titles, when I scroll down the page how do
I
keep the titles on top of each column so you can see what you are looking
at.


Select the row below your titles, Window menu, Freeze panes.
You can do the same with rows, columns, or both, just select the top
left-hand cell of the scrolling region before you freeze panes.
--
David Biddulph



[email protected]

Column headers
 
I know how to freeze but I need to scroll both the top and bottom
window. Is there a way to change the name on the column tabs A, B, C
to Jan. Feb,Mar etc.? ed



All times are GMT +1. The time now is 05:59 AM.

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