Fine Tune your Workbook with Print Options in Excel

2년 전

There is nothing worse than receiving an Excel workbook that looks the part, but then when you print it, tables and charts are split into different pages. Do people know there are print options available in excel?

This problem is a common spreadsheet problem. People fail to use the page layout options and page set up options in Excel to ensure that the report, they spent ages producing, actually prints out correctly.

There is a suite of print options available in Excel. In fact, there is a ribbon dedicated to Page Layout options. It is from this ribbon you can

  • Select orientation
  • Set page margins
  • Select page size
  • Scale the worksheet to fit page sizes
  • Set headers and footers and select areas to print
  • Repeat rows on pages
In this video, we will look in detail at the Page Layout Options. You will learn how to check a workbook on print preview, insert headers and footers, print areas, select page size and much much more.

Don't fall trap to this common problem, make sure your workbooks print as they should.

In return for this tip on Print Options in Excel, I ask that you share this post or the video with your friends and colleagues

Sign up for my newsletter – Don’t worry, I won't spam – Just useful Excel and Power BI tips and tricks to your inbox


If you liked this article then I know you will love Excel 101


Cross posted from my blog with SteemPress :
Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  trending

Congratulations @theexcelclub! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :

You distributed more than 21000 upvotes. Your next target is to reach 22000 upvotes.

You can view your badges on your Steem Board and compare to others on the Steem Ranking
If you no longer want to receive notifications, reply to this comment with the word STOP

Vote for @Steemitboard as a witness to get one more award and increased upvotes!