-
Contributor
3 Answers
- Posted on Mar 15, 2011
Re: If I have a multi-row s/s that has multiple pages,...
Hi, I believe you're asking about 'freezing panes'...
In Microsoft Excel 2007:
- Select the place on the spreadsheet where you want the row titles to appear
- Click on the View tab
- Click on Freeze Panes button
- Select Freeze Panes
Or, you could be asking about defining print rows to appear at the top of each page:
- Select the Page Layout tab
- Click Print Titles
- Enter the Rows to Repeat at Top (e.g., 1:3 for the first 3 rows)
Hope that helps!
×