Static Top Rows

  • Thread starter Thread starter Jack Black
  • Start date Start date
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
 
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
 
Back
Top