Scale your spreadsheet to fit when printing from Excel
Printing from Excel can be very frustrating, especially if your spreadsheet is too wide or too tall to fit on a single page.
You can use the Scaling option in Page Setup to set limits on how many pages wide and tall your document should be when you print it. The problem with that is that you can find your page fits onto one page, but becomes too small to read. Not only that, but Excel ignores any manual page breaks you've entered.
You can use this little-known tip when printing from Excel (all versions) to get more control of your printing.
Suppose you want your printout to fit onto one page across, but you aren't bothered about how many pages down it prints. Open Page Setup, then click the Page tab. Click the Fit To option. Then, enter 1 for the number of pages wide, and delete the value for the number of pages tall.
This will do exactly what you want - one page across and as many pages down as you need. Not only that, but if you have manually created page breaks, Excel will respect them for the dimension (wide or tall) that you left blank.
About Us
Fiveminutelessons.com is a website dedicated to providing free training on a range of subjects. We're starting with lessons on Microsoft Word, Excel and PowerPoint but have plans to add other subjects over time such as Adobe Photoshop and Microsoft Project as well as non-software subjects.
We're based in Tauranga, New Zealand but have years of experience in the UK, USA and Ireland working in the training industry with a range of clients from small businesses to blue chip corporates.
Commercial Services
As well as the free training you get at www.fiveminutelessons.com, we also offer a range of commercial services to help you with your training and online learning requirements including:
- Private labelling
- Courseware development
- e-learning development
- Corporate subscriptions
- Learning consultancy services
- Documentation and user guide development
- Development of innovative corporate learning environments
We offer these services for Microsoft Word, Excel and PowerPoint, as well as a range of other popular software applications. We can also assist with documentation and courseware development for custom or in-house software packages.
Contact us now to find out more about our learning consultancy and courseware development services