ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Scrolling Cells (https://www.excelbanter.com/excel-worksheet-functions/49698-scrolling-cells.html)

William Kim

Scrolling Cells
 
When creating a worksheet with main categories on the top line (i.e. Date,
amount, notes, etc.) how do I adjust preferences so that when I scroll down
the page and the top line is out of view, that I get that top line to scroll
down with me? Makes sense? Help please.

- WK


Alok

Select Row #2 and then Click on Menu Item Windows/Freeze Pane.

Alok

"William Kim" wrote:

When creating a worksheet with main categories on the top line (i.e. Date,
amount, notes, etc.) how do I adjust preferences so that when I scroll down
the page and the top line is out of view, that I get that top line to scroll
down with me? Makes sense? Help please.

- WK




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

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