Print selection and other choices in Excel


Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

Excel has some useful options for printing less than an entire workbook. Printing a selection, active sheets or a table.

As Office-Watch.com has discovered before, there’s a lot more available in Office than a quick look suggests.  See

Print options are at File | Print then choose the menu that starts with Print Active Sheets.

print selection and other choices in excel microsoft excel 24729 - Print selection and other choices in Excel

Print selection

Select a group of cells in a worksheet before going to File | Print | Print Selection.  It will print only those cells.

Non-continuous ranges of cells can be selected and printed (using Ctrl while selecting). However each part of the selection appears on a separate page.

This pair of selections:

print selection and other choices in excel microsoft excel 24730 - Print selection and other choices in Excel

Prints out with the first part of the selection on a single page.  The rest of the selection is atop page 2.

print selection and other choices in excel microsoft excel 24731 - Print selection and other choices in Excel

We could not find any way to directly print multiple selections on the same page.

The workarounds are to copy the selections to a blank worksheet and print from there.  Or Paste | Other Paste Options | As Picture will retain the formatting then print the image.

Print selected table

A really useful option to print only the ‘selected’ table.  We’ve switched to Landscape orientation so the table fits across a single page.

print selection and other choices in excel microsoft excel 24734 - Print selection and other choices in Excel

The table does not have to be fully selected to use Print selected table.  All it needs is the current selection to include some of a table or even just have the active cell in the table.

Print Active Sheets

The default is ‘Print Active Sheets’.  Normally that means the currently selected/visible worksheet but that’s not the whole story.

What are ‘active’ sheets?  They are the currently selected worksheets or tabs.

print selection and other choices in excel microsoft excel 24736 - Print selection and other choices in Excel

To select multiple worksheets/tabs, hold down the Ctrl key then click on the tabs you want to print.

Print Entire Workbook

Print everything, one with the lot, the whole enchilada ….

This will print all tabs in the current workbook.

 

subs profile e1563205311409 - Print selection and other choices in Excel
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address