ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Make the heading follow when scrolling? (https://www.excelbanter.com/excel-worksheet-functions/207016-make-heading-follow-when-scrolling.html)

Mike

Make the heading follow when scrolling?
 
Is it possible to have a heading that always is at the top of the screen even
while scrolling down? If I have a long price list and several columns, and I
want to see far down the list but don't remember which column was what. Like
a row that always follow at the top of the screen?
--
thanks

Sajjad

Make the heading follow when scrolling?
 
Yes it is possible by using Freeze Panes option, for e.g if you have heading
in first row then by going cell A2 slecet freeze panes in window menu at the
top of excel sheet.

(Windows Freeze Pnes)

--
Sajjad


"Mike" wrote:

Is it possible to have a heading that always is at the top of the screen even
while scrolling down? If I have a long price list and several columns, and I
want to see far down the list but don't remember which column was what. Like
a row that always follow at the top of the screen?
--
thanks



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

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