General discussion


Office XP Excel

By hbqns ·
How do you create a title in Excel
What are the steps?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by DKlippert In reply to Office XP Excel

If you want a Header, go to View>Header Footer.
If you want to repeat the same row on each page, go to File>Page set up.
On the sheet tab enter the row(s) to repeat at top IE
1:1 or 1

Collapse -

by amykong30 In reply to Office XP Excel

The disadvantage of doing it as a header is that you don't have all the formatting features. I would suggest using the Merge and Center button on the Formatting Toolbar.

If you have data in columns A to G, highlights cells A1:G1, and click on Merge and Center. This will allow you to insert, delete or resize columns - and continue to have the text centered on your page.

Related Discussions

Related Forums