Printing from Excel can be a confusing task, especially when you have a large spreadsheet that needs to be easily read when printed. How many times have you hit the ‘print’ button before remembering that you don’t need the whole thing, or need it to all fit on one page?

The first thing to remember is that Print Preview is your friend. It’s a good idea to get into the habit of always previewing before you print – this will save you a lot of paper and time!

We cover the issue of printing from Excel in our Excel training course. We also offer Advanced Excel training and VBA for Excel.

To get you started, here are some tips for things to consider before hitting that ‘print’ button!

How to specify how many pages you want your document to be

You can put a limit on how many pages you want your document to be when printed.

If you use this option then you lose any manual page breaks (but see the next tip for how to get around this). Read the rest of “How to Print From Excel”