Microsoft Excel 2016 – Print just what you need

You can print Microsoft Excel worksheets and workbooks one at a time, or several at one time. You can also print a partial worksheet, such as an Excel table, with just the information you need.

It's all about how you prepare your file. By setting things up before you're ready to print, you can control what is printed.

Here’s what you do:

All printing settings and functions are found in the Microsoft Office Backstage view.

Click the File tab on the Ribbon to open the Backstage view.

When you click Print from the Backstage view (File tab), the Preview Pane appears automatically to help you choose the settings and options that you want.

Tips:

Things to know before you print:

o Before you print a worksheet that contains large quantities of data, you can quickly fine-tune the worksheet in the Page Layout view. You can see and edit elements such as margins, page orientation and headers and footers

o Make sure the data is visible on the screen. For example, if text or numbers are too wide to fit in a column, they will appear as number signs (##). You can widen the column to prevent this

·       Use the Tell Me box on the Ribbon to find help on specific topics, including:

·       setting and clearing print area on a worksheet,

·       setting page margins,

·       printing gridlines,

·       printing in landscape or portrait,

·       printing rows and column headers on every page,

·       Headers and Footers,

·       print preview