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
Action Movies
Bible Basics
Houseplants
Romance Movies
Creativity
Family Travel
Southwest USA


dailyclick
All times in EST

Low Carb: 8:00 PM

Full Schedule
g
g Desktop Publishing / Ebooks Site

BellaOnline's Desktop Publishing / Ebooks Editor

g

Sheet Options - Excel

Guest Author - Chris Curtis

The sheet options tab of the Page SetUp dialog box provides various options for controlling your printed page. The Page SetUp dialog box can be activated from the main menu and from the SetUp button in the Print Preview mode. However, when accessed from the Print Preview mode many of the options the Sheet tab cannot be accessed. It is best to set your sheet options from the File | Page SetUp menu command.

Print Area: Using this option you can establish a specific print area. 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. 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.

Print Titles with this option you can designate row and column headers that you want to have repeated on all pages of your report. Designate the rows to be repeated by typing in the row numbers (i.e., 1:3) in the "Rows to repeat at top" field. Alternatively, you can use the collapse button found to the right of the "Rows to repeat at top" filed to select the desired rows.

Similarly, type in the columns to be repeated by typing in the desired columns letters in the "Columns to be repeated at left" field (i.e., A:B) to be repeated. Alternatively, you can use the collapse button found to the right of the "Columns to repeat at top" filed to select the desired rows.

Print: this sections provides options to control
Print or not print gridlines
Print in Black and White
Print in Draft Quality
Print the Row and Column Letters and Numbers
Print comments either as displayed on the worksheet or at the end of the worksheet
Print cell errors as displayed, blank or N/A

Print Order: Choose to order multiple pages of your report
Down then over thus it will print all pages down before printing pages to the right
Over then down thus it will print pages left to right before printing pages below

When all of your options have been selected, click on OK to close the Page SetUp dialog box.
Add Sheet+Options+%2D+Excel to Twitter Add Sheet+Options+%2D+Excel to Facebook Add Sheet+Options+%2D+Excel to MySpace Add Sheet+Options+%2D+Excel to Del.icio.us Digg Sheet+Options+%2D+Excel Add Sheet+Options+%2D+Excel to Yahoo My Web Add Sheet+Options+%2D+Excel to Google Bookmarks Add Sheet+Options+%2D+Excel to Stumbleupon Add Sheet+Options+%2D+Excel to Reddit




Page SetUp Dialog Box - Excel
Print Preview - Excel
Page Options - 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