



Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
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
1 / 7
This page cannot be seen from the preview
Don't miss anything!
10/17/06 Rev3 1
Microsoft Excel provides the following ways to view your spreadsheet and adjust how it will look printed:
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:
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:
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.
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 :
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
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
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
To Freeze Columns
To Freeze Both Columns and Rows
Unfreeze Panes