Someone asked me for help with an Excel printing question recently – how to make the columns all fit on one printed page. Most of us don’t print our Excel sheets too often, so it’s easy to forget those Excel printing tips! Videos and tips below show a few things you can do to make Excel printing easier.
Excel Printing Tips
This is a collection of some of my favourite Excel printing tips.
To see the written steps for these videos, and more Excel printing tips, go to my Contextures website.
Fit Columns on One Sheet
This video shows how to make all the columns fit on one printed page. You’ll also see how to show the column headings at the top of each printed page.
Print All the Sheets
Instead of printing sheets one at a time, watch this short video to see how to print all the sheets in an Excel file at once.
Be sure to watch to the very end, to see an important step! Without that step, you could accidentally overwrite the worksheet data
Print a Named Excel Table Only
When you’re working with a named Excel table, this video shows a quick way to print just the table, without all the other stuff that’s on the worksheet.
Show Excel Message Before Printing
And if you want to get really fancy with your Excel printing, use a bit of programming!
This video explains how to show a message before printing, if key information is missing from the worksheet. There are more details in this article: Collect Data from Users
More Excel Printing Tips
To see the written steps for these videos, and more Excel printing tips, go to my Contextures website.
There are instructions for printing the gridlines, and details on how to get rid of that “Page 1” text that you see sometimes, in the middle of a worksheet.
____________________
Excel Printing Tips Videos
____________________