• Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Home
  • Categories
  • Contact Us
    • Advertising
    • Requests
    • Privacy Statement
HelpSpa.com

HelpSpa.com

Computer Tutorials

Excel 2010: How to Print Sheet on One Page

September 24, 2010 by davidwank

I’m often asked how to condense an Excel 2010 spreadsheet for printing on one page — so in this post I will show you how to make that happen.

First consider that every spreadsheet is not meant to be condensed into one page — you can shrink any print area of an Excel spreadsheet into one page — but it may be unreadable at that size.

So to shrink the worksheet to fit (in Excel 2010 — it’s a little different from previous versions of Excel, but the concept is the same)

1. Select your print area.  (Here’s a quick review of how to set the Excel 2010 print area).

2.  Go to the File menu at the top left, of the screen:

excelFit0g

3. Select the Print option. You will see a choice at the bottom of the Settings area, Custom Scaling .

excelFit2g

In the custom scaling area you will see a list of scaling options. You can choose which one meets your needs — but “Fit Sheet on One Page” is the most basic choice and the one I’ll mention here.

Filed Under: Excel Tagged With: Excel

Primary Sidebar

More to See

Convert LD+JSON Schema to Javascript to use in Google Tag Manager

April 21, 2020 By davidwank

How to Add Google Analytics Data to a LeadPages.com LeadPage

April 21, 2020 By davidwank

Footer

Text Widget

This is an example of a text widget which can be used to describe a particular service. You can also use other widgets in this location.

Examples of widgets that can be placed here in the footer are a calendar, latest tweets, recent comments, recent posts, search form, tag cloud or more.

Sample Link.

Recent

  • BackupBuddy Timeouts on GoDaddy Hosting
  • Convert LD+JSON Schema to Javascript to use in Google Tag Manager
  • How to Add Google Analytics Data to a LeadPages.com LeadPage
  • Diagnosing WordPress Errors with Apache Logs and PHP Logs
  • Setup Mailgun with cPanel and Google Apps

Search

Tags

Adobe Acrobat Backup classical music and opera cPanel DAM Database Digital Photography email Excel Facebook Firefox hardware HP Security HTML iMovie Internet Explorer iTunes linksys Microsoft Office Microsoft Word MySQL networking Office 2010 OneNote OpenOffice OS X PDF PHP printers reseller hosting Reviews router SEO subversion Video Virtualization Virtual PC Web Design Web Development Web Hosting Windows Windows 7 Windows Vista Windows XP Wireless

Copyright © 2021 · Magazine Pro on Genesis Framework · WordPress · Log in