ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   On an Excel Worksheet I want to view column headings as I scroll . (https://www.excelbanter.com/excel-discussion-misc-queries/17596-excel-worksheet-i-want-view-column-headings-i-scroll.html)

sharon

On an Excel Worksheet I want to view column headings as I scroll .
 
I am setting up a worksheet in Excel. I have column headings that I want to
be able to view as I scroll down the page(s). How do I do this?

Trevor Shuttleworth

Sharon

activate a cell in column A in the row below the heading rows and
select Window | Freeze panes

If you select a cell in a column other than column A you can freeze the row
"headings" too so when you scroll to the right it leaves the left most
columns in view.

Regards

Trevor
"sharon" wrote in message
...
I am setting up a worksheet in Excel. I have column headings that I want
to
be able to view as I scroll down the page(s). How do I do this?





All times are GMT +1. The time now is 03:56 PM.

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