getting info at top of every page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I downloaded a template from office online the weekly class roster and it automatically puts the name and dates label of the cells at the top of every page and this never shows up on preview of page break view. I like the function because it saves time sorting because the labels dont interfere? with the sorting function. can someone please explain how this is done? thanks matt
 
Hi Matthew
probably 'freezed panes'. Try the following
- select cell A2
- now goto 'Window - Freeze Panes

This should freze row on of your spreadsheet
 
And if you select B2 and do it you freeze the left column as well. In general,
everything to the left and above the cell you are in when you activate that mode
will be frozen.
 
Back
Top