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

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

new
Journals
Folklore and Mythology
Business Coach
Marriage
Senior Living
Ethnic Beauty
Adolescence


dailyclick
All times in EST

Autism Spectrum Disorders: 4:00 PM

Full Schedule
g
g Desk Top Publishing Site
Editor Wanted
BellaOnline's Desk Top Publishing Editor

g

Print Area – Excel
Guest Author - Chris Curtis

By default, Excel will select a print area that will incorporate the entire area of the worksheet that contains data. You may want to segment different areas for printing.

There are two methods for setting the print area:
• Using the Sheet Options tab of the Page SetUp dialog box
• Using File | Set Print Area

Both methods will be described here.

Sheet Options Tab
To activate:
• File | Page SetUp
• Select the Sheet Options Tab

At the top of the Sheet Options Tab you will see the Print Area field. Using this option you can establish a specific print area. To define a print area, click inside the print area field and type the print range desired or use the collapse button found to the right of the print area field to collapse the dialog box, then select the range directly in your worksheet. Once the range has been selected, click on the collapse button again to restore the dialog box. Click on OK when finished.

File | Set Print Area
To use this option, you must first pre-select the range you want to include in your print area.
• Pre-select desired print range
• Click on File | Set Print Area

Clearing the Print Area
• Click on File | Clear Print Area

TIP
When you have multiple ranges that you need to print on a regular basis, use the named range feature to predefine each of the print areas: i.e., PrintRange1, PrintRange2 etc. Then you can use the Name Box to select the needed print area then use the Set Print Area command to set your print range. Using named ranges can speed up your process.


This site needs an editor - click to learn more!

Using Named Ranges (Excel)
Excel - Working with Worksheet Tabs
Sheet Options - Excel
RSS
Related Articles
Previous Features
Site Map

Add Print+Area+%96+Excel to Twitter Add Print+Area+%96+Excel to Facebook Add Print+Area+%96+Excel to MySpace Add Print+Area+%96+Excel to Del.icio.us Digg Print+Area+%96+Excel Add Print+Area+%96+Excel to Yahoo My Web Add Print+Area+%96+Excel to Google Bookmarks Add Print+Area+%96+Excel to Stumbleupon Add Print+Area+%96+Excel to Reddit


Content copyright © 2009 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 BellaOnline Administration for details.

g


For FREE email updates, subscribe to the Desk Top Publishing Newsletter


Past Issues


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

g features
What is a Pivot Table

Procedure for Setting File Protection in MS Word

MS Word Document View

Archives | Site Map

forum
Forum
email
Contact

Past Issues
memberscenter

jobs
what
job title, keywords
where
city, state or zip
jobs by job search


vote
Growing a Garden
Veggies and Flowers
Veggies Only
Flowers Only
No Garden

g


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


BellaOnline Editor