ExcelBanter - Static Top Rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Static Top Rows (https://www.excelbanter.com/excel-discussion-misc-queries/150806-static-top-rows.html)

Jack Black

Static Top Rows

I need to keep the top 5 rows of a spreadsheet to remain visible as I
add data to the rows below. Now as I add new information on a daily
basis the top 5 rows go out of view.

Help please

Thanks

Rick Rothstein \(MVP - VB\)

Static Top Rows

I need to keep the top 5 rows of a spreadsheet to remain visible as I
add data to the rows below. Now as I add new information on a daily
basis the top 5 rows go out of view.

Select cell A6, click Window/Freeze Panes in Excel's menu. That's it, the
top five rows are frozen.

Rick

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