Read this tip to make your life smarter, better, faster and wiser. LifeTips is the place to go when you need to know about Enjoying Your Work and other Businesses topics.

How do I title multiple pages?

Repeating Titles

If your spreadsheet contains multiple pages, you may want a title to print on the top of each page, or in the first column of each page.

1. Position the worksheet so that the rows or columns that contain the title are displayed.
2. Click on the File Menu.
3. Click on Page Setup.
4. Click on the Sheet Tab.
5. In the Print Titles box, type the rows or columns that you want printed as titles (i.e., A:C or 1:8). Or, use the mouse to select the row or column headings on the worksheet.
6. Click ok.

Comments

Nobody has commented on this tip yet. Be the first.

Ask a Question

Not finding the advice and tips you need on this Businesses Tip Site? Request a Tip Now!

Guru Spotlight

Jerry Mayo

Ever wonder how you could make your life better and more fun? So have tens of millions of fans who have turned to LifeTips for answers over the past decade. We keep the tips, advice, books, podcasts and writing services flowing, so you can keep your life and business growing in the right direction. Upward!