Free Excel Skills Assessment

Very short questionnaire to establish your skill level with Microsoft Excel.

Excel Assessment

Free Microsoft Word Skills Assessment

Very short questionnaire to establish your skill level with Microsoft Word.

Word Assessment

Free PowerPoint Skills Assessment

Very short questionnaire to establish your skill level with Microsoft PowerPoint.

PowerPoint Assessment

Printing from Excel - 3 useful things to know

Tips for helping data fit on one page, or better manage how it looks across multiple pages.

  • 27 October 2021
  • Author: Liam Phelan
  • Number of views: 172
  • 0 Comments

Printing from Excel - 3 useful things to know

When printing from excel, there are common issues that arise. The most common is having data fit on one page, or better manage how it looks across multiple pages. Before printing anything from excel, check these 3 things to reduce multi-page issues.


1: Check your paper size

The US standard for excel is Letter size. If you are printing in Europe the standard paper size in your devices is the ‘A’ system. Often A4.
On the Layout Ribbon, check your paper size is changed from Letter to A4


2: Optimize the fit of your data

Over time the amount of space used up by different columns or rows in excel can drift.
To give your data it’s ‘best fit’.
Click the triangle between col A and row 1 to highlight whole sheet. On the home ribbon, choose the format dropdown and auto fit column widths and/or heights


3: Turn on ‘Print Titles’

This feature ensures that if data does need to be spread across a few sheets that the headings of the data are repeated as needed.

To create print titles.

  1. Select the Page Layout Ribbon
  2. Click on the Print Titles button
  3. Select the Rows to Repeat at Top field

  1. Point to the left of the row you want to use as a Print Title. The cursor changes to an arrow. Select the row. The reference is added to the Rows to repeat at top field. Select OK.

Excel print page set-up

Happy Exceling!


Print
Categories: Excel, Microsoft Office
Tags: Excel
Please login or register to post comments.

Theme picker

Loader

Categories

Subscribe to our Newsletter

cheat sheet resources

Subscribe to our Newsletter for all the latest cheat sheets and resources.

Subscribe