Static Top Rows

J

Jack Black

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
 
R

Rick Rothstein \(MVP - VB\)

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.
Click to expand...

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

Rick
 
Top