logo
g Text Version
Beauty & Self
Books & Music
Career
Computers
Education
Family
Food & Wine
Health & Fitness
Hobbies & Crafts
Home & Garden
Money
News & Politics
Relationships
Religion & Spirituality
Sports
Travel & Culture
TV & Movies

dailyclick
Bored? Games!
Nutrition
Postcards
Take a Quiz
Rate My Photo

new
European Travel
Action Movies
Bible Basics
Houseplants
Romance Movies
Creativity
Family Travel


dailyclick
All times in EST

Full Schedule
g
g Desktop Publishing / Ebooks Site

BellaOnline's Desktop Publishing / Ebooks Editor

g

Headers and Footers - Excel

Guest Author - Chris Curtis

The Header/Footer tab on the Page SetUp dialog box provides options for establishing custom headers and footers for your printed worksheet. Headers and footers give you the flexibility to insert information that you want to have repeated on every page of the worksheet printout. For example, you might want to have the Company name and logo in the top left hand corner of the report and the date of the printout in the top right hand corner. In the footer you might want the name of the individual producing the report in the lower left section, the page number in the bottom center, and the file name and directory path in the lower right corner.

Excel provides a drop down selections of common header and footer types. To use them, simply click on the drop down arrow and make your selection and then close the dialog box. If these options do not suit your needs, you can use the Custom Header and Custom Footer buttons to custom design your header and footer.

You can access the Header and Footer dialog box in three ways:
While in Print Preview click on the Header/Footer tab of the Page SetUp dialog box
While in your active worksheet select File|Page SetUp; then click on the Header/Footer Tab
While in your active worksheet select View|Header/Footer

Whether you choose custom header or custom footer the methodology for building your header or footer is the same. The dialog box will display three sections for your customized information: Left, Center, Right. Your custom information will be displayed on ever page of your document based on the position you choose. The dialog box displays a toolbar to assist you. The 10 tools available are described as follows:
1. Font you can apply normal formatting choices to your header or footer by using this tool. Select the text in section you want to affect, press the Font tool and make your format choices for Font type, size, and effects.
2. Page # - this tool automatically numbers the pages of your printed documents
3. Number of Pages use this in conjunction with the Page # tool. For example Click on Page #, type a space and the word of, then click on the Number of Pages tool.
4. Date inserts the current date in your document
5. Time inserts the current time in your document
6. Path and File inserts the windows file path and the document name. This is a great tool for being able to locate your document at a later date from the hard copy print out.
7. File inserts the document name only
8. Tab inserts the worksheet tab name
9. Insert Picture Allows you to insert a logo or graphic into your header or footer
10. Fill allows you to select a fill color

Select any combination of tools and typed text to design your custom header or footer. Once you have designed your custom header and footer, click on OK to close the Header/Footer dialog box then click on OK to close the Page SetUp dialog box.






Add Headers+and+Footers+%2D+Excel to Twitter Add Headers+and+Footers+%2D+Excel to Facebook Add Headers+and+Footers+%2D+Excel to MySpace Add Headers+and+Footers+%2D+Excel to Del.icio.us Digg Headers+and+Footers+%2D+Excel Add Headers+and+Footers+%2D+Excel to Yahoo My Web Add Headers+and+Footers+%2D+Excel to Google Bookmarks Add Headers+and+Footers+%2D+Excel to Stumbleupon Add Headers+and+Footers+%2D+Excel to Reddit




Print Preview - Excel
Page Options - Excel
Page SetUp Dialog Box - Excel
RSS
Editor's Picks Articles
Top Ten Articles
Previous Features
Site Map


For FREE email updates, subscribe to the Desktop Publishing / Ebooks Newsletter


Past Issues


print
Printer Friendly
bookmark
Bookmark
tell friend
Tell a Friend
forum
Forum
email
Email Editor


Content copyright © 2014 by Chris Curtis. All rights reserved.
This content was written by Chris Curtis. If you wish to use this content in any manner, you need written permission. Contact Laura Nunn for details.

g


g features
Becoming a Fiction Editor

Making a Background Transparent Using Photoshop

Merging Letters in Word 2007

Archives | Site Map

forum
Forum
email
Contact

Past Issues
memberscenter


vote
Poetry
Daily
Weekly
Monthly
Less than Monthly



BellaOnline on Facebook
g


| About BellaOnline | Privacy Policy | Advertising | Become an Editor |
Website copyright © 2014 Minerva WebWorks LLC. All rights reserved.


BellaOnline Editor