word-excel-access-help.com
Excel Printing





Excel Printing
Additional Resources



Excel Printing



Excel Printing | Microsoft Excel XP

Microsoft Excel XP logo
Learn step-by-step how Excel printing is done. Learn how to adjust your worksheet so that you can print the things you want.

Excel Office Helper What's on this page...
Print Preview
Print dialog box

Excel Printing - Print Preview

Once you're done with you worksheet, you might have to print it. Microsoft Excel helps you with this easily, because this is definitely not a difficult task to do.

Before you print a worksheet, check it first in Print Preview, and make sure that it looks the way you want it to.
 Microsoft Word Help: Print Preview button Print Preview button


Excel Office Helper 
Q: "Where's my borders?"

Print Preview displays, and print, only the borders that you've drawn.

The grey lines in a normal worksheet are called gridlines and are non-printable. 

In print preview you can adjust your page settings to fit your data.

There are several steps to follow if your data doesn't fit on the page.

Check the Paper Size and Orientation

1. In Print Preview mode, click on the Setup... button at the top of the window. 
   
2.  From the Page Setup dialog box, choose the Page tab.
   
  Excel Printing: Page Setup dialog box
   
3. Change the Orientation from portrait to landscape, if you desire.
   
4. Make sure the Paper Size is the correct size. 
   
5.  From the Scaling area, choose Fit to 1 page(s) wide by 1 tall to make your content fit to the current page.
   
6. Click OK


Check the margins.

1.  In Print Preview mode, click the margins button at the top of the screen.
   
2. Notice that Excel has added 6 dotted lines to your page.
These represent the margins for top, bottom, left and right, as well as the margins for the header(top) and footer(bottom).
   
3. You can drag these dotted lines to make room for content that doesn't quite fit on the page.
   
4. Place your mouse pointer over the margin's dotted line whom you want to move.

The mouse arrow changes to a double-headed arrow.
   
  Excel Printing: Margin example 1  Drag the margin to resize the print area
   
5. Click and drag the margin outwards to increase the print area of the page. 

If you are sure all your Excel printing settings are correct, you can simply click the Print button at the top of the window.
 
Back to Top
 
Return to Excel XP from Excel Printing
 
Excel XP Topics
- Tips
- Excel Screen Layout
- Navigational Techniques
- Working with Workbooks
- Templates
- Working with Worksheets
- Moving Around
- Move Worksheets
- Copy Worksheets
- Insert & Delete Cells
- Insert & Delete Rows
- Insert & Delete Columns
- Resize Row
- Resize Column
- Editing Data
- Content Color
- Cell Color
- Number Formats
- Fonts
- Alignment
- Text Direction
- Indent Contents
- Merge Cells
- Copy
- Move
- Undo & Redo
- Using Zoom
- Freeze & Unfreeze Titles
- Split Worksheet
- Spreadsheet Data
- AutoFill
- AutoComplete
- Comment
- Find
- Replace
- Spellcheck
- Formulas
- Functions
- Print
- Password
- Sorting
- AutoFilter
- Advanced Filter
- Macros
- Charts
- Charting
- Charting Elements
- Gantt Chart
- PivotTable
- PivotTable Calculations
- PivotTable Layout
- PivotTable Format
- PDF to Excel
- PDF-to-Excel Converter
- Excel to PDF Converter