Thread: Static Top Rows
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default 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