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
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 : https://theexcelclub.com/print-options-excel/