Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Printing Tips for Excel Spreadsheets: Shrinking, Expanding, and Fitting to One Page, Summaries of Printing

Instructions on how to adjust the printing specifications of an Excel spreadsheet, including shrinking or expanding the image, fitting it onto one page, and changing the orientation and centering. It also covers repeating row and column labels, hiding columns and rows, and freezing panes.

Typology: Summaries

2021/2022

Uploaded on 09/27/2022

laskhminaran
laskhminaran 🇺🇸

4.7

(6)

224 documents

1 / 7

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
10/17/06 Rev3 1
Tips and Tricks
for Printing
an Excel Spreadsheet
Microsoft Excel provides the following ways to view your spreadsheet and adjust how it will
look printed:
Normal view – This is the default view and is best for on-screen viewing and
working
Print preview – This shows you a page by page view of exactly how your data will
print out
Page break preview – This shows you what data will go on each page so you can
adjust the print area and page breaks if needed
Shrinking/Expanding a Spreadsheet Image
The Page Setup option under File is used to change the printing specifications. It allows
you to change the orientation and scaling, adjust the margins, include headers/footers and
set the print area. These changes affect only the worksheet's printed appearance, not how
it looks on the screen in Normal View.
Prior to printing your spreadsheet, it is a good idea to first look at it in Print Preview to see
how it will look on the page; then proceed to Page Setup if you wish to change the printing
specifications.
pf3
pf4
pf5

Partial preview of the text

Download Printing Tips for Excel Spreadsheets: Shrinking, Expanding, and Fitting to One Page and more Summaries Printing in PDF only on Docsity!

10/17/06 Rev3 1

Tips and Tricks

for Printing

an Excel Spreadsheet

Microsoft Excel provides the following ways to view your spreadsheet and adjust how it will look printed:

  • Normal view – This is the default view and is best for on-screen viewing and working
  • Print preview – This shows you a page by page view of exactly how your data will print out
  • Page break preview – This shows you what data will go on each page so you can adjust the print area and page breaks if needed

Shrinking/Expanding a Spreadsheet Image

The Page Setup option under File is used to change the printing specifications. It allows you to change the orientation and scaling, adjust the margins, include headers/footers and set the print area. These changes affect only the worksheet's printed appearance, not how it looks on the screen in Normal View.

Prior to printing your spreadsheet, it is a good idea to first look at it in Print Preview to see how it will look on the page; then proceed to Page Setup if you wish to change the printing specifications.

To Shrink or Expand a Spreadsheet Image:

  1. Click on File and select Print Preview or click on the Print Preview icon
  2. Click on SetUp

This is an example of how a smaller sized spreadsheet will print on a page before changing any of the printing specifications.

To Fit a Spreadsheet on One Page:

  1. Click on the Page tab
  2. Click on the Fit to option under Scaling
  3. Click OK to view the changes in Print Preview

When you click on Fit to , Excel shrinks the printed image to the appropriate size in order to fit it on the number of pages you specify.

Note: Excel ignores manual page breaks when you use the Fit to option.

Changing the Orientation

As a default your spreadsheet will print in portrait layout. The User is able to change the page orientation to horizontal rather that vertical.

To Change to Landscape :

  1. Click on the Page tab
  2. Click on Landscape
  3. Click OK to view changes in Print Preview

Centering the Image on the Page

You can center the spreadsheet image horizontally on the page between the left and right margins, and/or center it vertically on the page between the top and bottom margins.

To Center an Image on a Page

  1. Click on the Margins tab
  2. Click on both Horizontally and Vertically under Center on Page
  3. Click on OK to view changes in Print Preview

This is an example of a smaller sized spreadsheet after the printer specifications were modified by using Page Setup:

To Unhide a Column or Row

  1. Highlight the outside columns or rows of the ones that are hidden. (for example: if column C is hidden, you want to select columns B and D)
  2. Click on Format
  3. Click on either Column or Row
  4. Click on Unhide

Freezing Panes

When working on large size spreadsheets it is sometimes necessary to keep the row and column labels visible when scrolling through the spreadsheet.

To Freeze Rows

  1. Select the row below the row you want to freeze
  2. Click on Window
  3. Click on Freeze Panes

To Freeze Columns

  1. Select the column to the right of the column you want to freeze
  2. Click on Window
  3. Click on Freeze Panes

To Freeze Both Columns and Rows

  1. Click the cell below and to the right of where you want the freeze to appear
  2. Click on Window
  3. Click on Freeze Panes

Unfreeze Panes

  1. Click on Window
  2. Click on Unfreeze Panes