|
When you print a worksheet in Excel, do you find yourself adding the same header and footer and resetting the same print options every time? For example, suppose you require that all worksheets are printed with the company's custom header and set to print in landscape mode. Each time you create a workbook, you will need to change the default print settings, unless you create a custom template that will automatically give you the appropriate settings. Here's how to create a custom template: - Launch MS Excel.
- Open a blank document; select all sheets.
- Go to File | Page Setup.
- In the Orientation section, select Landscape, and then click OK.
- In the Header and Footer section, you can either select a header from the Header drop-down menu, or you can press the Custom Header button to create your header.
- Click OK.
- Go to File | Save As.
- Under File Name, enter a name for your template.
- Under Save As Type, select Template and click Save.
Now when you create a workbook based on your custom template, the header and print settings will automatically be set to your specifications. Visit Carol's web site to learn more tips like this one!
-- Related newsletter articles:
2005/07/13 InAlbum 2.0 Deluxe Edition: Photo Organizer (custom)
2006/03/28 Edit Your Own Custom Dictionary: MS Word (custom)
2006/04/19 Design Your Own Template: MS PowerPoint (template)
2005/10/13 Email (header)
2005/12/10 Web Page Server Codes (header)
2005/04/07 Phase 1 Web Site Reconstruction: Complete (header)
2006/05/19 Add a Table of Contents to Your Document: MS Word 2003 (header)
2002/10/01 Printing a page using Portrait or Landscape mode (print)
2004/10/14 Print web pages in black and white (not color)? (print)
2005/07/29 Print MP3 Playlist? (print)
2004/07/06 Web page doesn't fit properly when printed? (print)
2004/07/08 Web page doesn't fit properly when printed?, Part 2 (print)
2006/05/24 Set Margins: MS Word (print)
-- Recent articles (from all channels): 2008/05/12 Today in History: for Monday, May 12, 2008
2008/05/12 [ShellX 20080512]: 'Remote Manager', and 'Cyber Bandwidth ...
2008/05/12 Video Gaming Trade Group Struggling
2008/05/12 T-Mobile Finally Joins 3G Phone Race
2008/05/12 Apple Slammed by Environment Watchdog
2008/05/09 [ShellX 20080509]: 'Advanced Run', and 'Diver Windows Manager'
2008/05/09 Texas Refuses Facebook Friend Request
2008/05/09 Photo-Enforcement Technology Replaces Officers On Patrol
2008/05/09 Cuban Government Says 'Ok Computer'
2008/05/09 Excel Can E-Mail Your Weekly Reports For You!
2008/05/08 [ShellX 20080508]: 'Shell Enhancer', and 'Lansweeper'
2008/05/08 Xobni: MS Outlook Social Networking Technology for your Inbox
2008/05/08 Music Companies Jump on GTA IV Bandwagon
2008/05/08 Fascinating: Memristor to replace Binary
2008/05/08 Adobe Hopes To Make Flash Master Of The (Mobile) Universe
2008/05/08 Spiffy Envelopes and Labels in MS Word
2008/05/07 [ShellX 20080507]: 'Winbin2iso', and 'Loop Typer'
2008/05/07 Yahoo Adds Security Warnings To Search Results
2008/05/07 Apple to Lose Money on iTunes Movie Releases
2008/05/07 Amazon.com takes New York Tax to Court
2008/05/07 Need Glasses for the Slide Sorter View in MS PowerPoint?
2008/05/07 After Winning The DVD Format War, Blu-Ray Sales Tank
2008/05/06 [ShellX 20080506]: 'Visual Basic 6.0 Portable', and 'Double-...
2008/05/06 Yahoo Outsources to Jajah
2008/05/06 New HP Circuit Could Change Technology Forever
2008/05/06 Movie Downloads To Match DVD Release Dates
2008/05/06 Microsoft Ends Yahoo Bid
2008/05/05 [ShellX 20080505]: 'Ie7 Pro', and 'Desktop Ok'
2008/05/05 The WB Network Hops Online
2008/05/05 Microsoft Slashes Price of Xbox 360 Overseas
2008/05/05 Google CEO Wants YouTube to Take More of Your Money
|
