frozen panes

  • Thread starter Thread starter Guest
  • Start date Start date
File>Page setup>Sheet>Rows to repeat at top

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| How do I make my frozen panes/rows print at the top of each page?
 
Hi,

Do the following:

1. On the File menu, click Page Setup.
The Page set up dialog appears.
2. In the Page Setup dialog box, click the Sheet tab.
3. Under print titles, click the Rows to repeat at top box and then click
the row numbet to the left of the worksheet.

Note: [Optional] You can press the Ctrl key and click more than one row to
repeat on the top.

4. Click OK.

Challa Prabhu
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 - How do I print my two row header on each page? 2
Unable to freeze panes 16
Print Frozen Panes? 2
Freeze Panes bug when grouping columns and sharing a workbook 1
Freeze panes error when grouping columns and sharing a workbook 1
Freeze 2 horizontal panes 2
Hyperlink to move the cursor to the top of the frozen panes 3
Freeze multiple rows/columns in Excel 2007 11

Back
Top