Excel Printing Tips Videos

Written by Debra Dalgleish from Contextures Blog

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

excelprintingtips01a

excelprintingtips01b

____________________

Excel Printing Tips Videos is a post from Contextures Blog and is not allowed to be copied to other sites

Original source: https://contexturesblog.com/archives/2019/11/14/excel-printing-tips-videos/

Leave a Reply

Close Menu