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
Houseplants
Romance Movies
Creativity
Family Travel
Southwest USA
Irish Culture
Home Finance


dailyclick
All times in EST

Clairvoyance: 08:00 PM

Full Schedule
g
g Desktop Publishing / Ebooks Site

BellaOnline's Desktop Publishing / Ebooks Editor

g

Margin Options - Excel

Guest Author - Chris Curtis

The Margins tab allows you to manipulate the size of the top, bottom, left and right margins and the size of the margins for the header and footer. You can also choose to center the print both horizontally and vertically from this page.

The default margins for Excel are:
.75 inch for the Left and Right Margins
1.0 inch for the Top and Bottom Margins
.5 inch for the Header and Footer areas.

These margins are fairly generous for an Excel report. Reducing the left and right margins to .25 and the top and bottom margins to .50 provide you with more space to display your worksheet on a single page. Rarely would you want to adjust the margin settings for the header and footers.

On the Margins Page of the Page Setup dialog box, click on the up and down arrows of the incremental spin buttons to increase or decrease the margin size. You can also type in a value for your margin in the spin box. For example, if you decide you want to reduce the top margin to .50, then click inside the spin box and type .50 to replace the value that is contained in the box.

The margins tab has two options for centering your report on the page. You can center vertically or horizontally or you can select both for a perfectly centered report. Click on the check box(s) to make your centering choice.

If you are a visual person there is a 2nd methodology that you can use to adjust your page margins. This methodology is available through the Print Preview feature as follows:

Click on the Margins button on the button bar of the Print Preview feature
Drag the margin lines to the position you want for your report.

When you are in the Margin feature of Print Preview, you will see two margin lines at the top and bottom. The outer margin lines adjust the width of the header and footer areas. The inner margin line adjusts the page margin. When you use this method, you can numerically see the effects of the changes you made on the Margins page of the Page Setup dialog box.

Since space is at a premium when working with spreadsheet reports, adjusting your margins give you additional control over the layout of your document.

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




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