Subscribe to our Weekly Software Tips
Select Category:
Opening Office 2007 files in Office 2003
Cycling through all your windows
Cycling through your open Word documents
Spice up your Word documents with Page Borders
How to specify the formatting for new slides in PowerPoint
Unprotecting an Excel worksheet if you don't know the password
Getting Google to Define things for you
Set the default formatting for Shapes in PowerPoint
Restoring a missing column in an Outlook folder
Repeat column titles on every page when printing in Excel
Display a table's headings on each page in Word
Creating the same footer for several Excel worksheets
Selecting a large block of text in Word
Previewing your PowerPoint presentation
How to password-protect your screen saver
Printing only the last four pages of a Word document
Change the colour of a worksheet tab in Excel
Use the keyboard to move to the next placeholder on a PowerPoint slide
Getting the most out of Home and End
Shortcuts to insert the current Date or Time
Shortcuts for working with borders in Excel
Bypassing Outlook's Deleted Items folder
Which Taskbar button do I click on?
2010 Calendars from Office Online
Repeat column titles on every page when printing in Excel
As a follow on to last week's tip, subscriber Anita C. asked if the same feature is available in Excel. Yes it is! You can have your column titles printed on each page.
To repeat column titles in Excel 2007
- Page Layout tab, Page Setup group, Print Titles button
- Click in the Rows to repeat at top text box
- In your spreadsheet select the row(s) you want repeated on each page
- Click on OK
To repeat column titles in Excel 2003:
- File menu, Page Setup, Sheet tab
- Click in the Rows to repeat at top text box
- In your spreadsheet select the row(s) you want repeated on each page
- Click on OK
Any questions, please let me know.
Interested in Microsoft Excel Training in Vancouver?