Buzz
Not every Excel spreadsheet looks visually appealing on paper, and these sheets aren't always designed to fit perfectly on a printed page - they are designed to be long or wide depending on the user's needs and purposes.
Users can view and edit spreadsheets on their computers, but it doesn't mean that these data are automatically formatted to fit a standard sheet of paper. Before printing in Excel 2003, 2007, 2010, 2013, 2016, refer to 5 Essential Excel Printing Hacks by Mytour to print out sheets in a standardized and beautiful manner.
5 Essential Excel Printing Tips Everyone Should Know
Before printing any Excel spreadsheet, users need to perform additional steps to set up the sheet to fit perfectly on the printed page, without excess or missing data.
Note: The tips below apply to both Excel 2007, 2010, and 2013.
Preview the spreadsheet before printing
You can precisely preview how the spreadsheet will appear on print using the Print Preview feature. This helps you save time and printer paper. Print Preview can be considered the most valuable and useful printing tool.
You can even make some changes within the spreadsheet, such as clicking and dragging Margins to expand or shrink the sheet. Preview the spreadsheet again if you modify print and layout options to ensure the sheet will display the way you want.
Excel Printing Tips Everyone Should Know
Selecting what to print
If you only need a specific data segment, you don't have to print the entire spreadsheet, just print the specific data. You can print the current view of the sheet by accessing the print table (press Ctrl + P) and selecting the Print Active Sheets option under Settings, or you can choose Print Entire Workbook to print the entire file.
Additionally, you can print a small data section by selecting that data, then choosing Print Selection in the print options under Settings.
Maximize your space
You are limited by the size of the printing paper, but there are many ways to maximize this space. The solution here is to try changing the page orientation.
The default page orientation is best for data with more rows than columns, but if your spreadsheet is wide rather than long, consider changing the page orientation to landscape. Need more space? You can adjust the width of the margins on the edges of the paper.
The narrower the margins on the edges of the paper, the more room you have for your data.
Finally, if your spreadsheet isn't too large, try using Custom Scaling Options to adjust all rows, columns, or the entire sheet to fit on one page.
Utilize Print Titles
If the sheet in your Excel spreadsheet is longer than one page, you can use headers on each sheet of the spreadsheet to understand what content you are viewing.
The Print Titles command allows you to do this, including a header row or column on each sheet of the spreadsheet. The columns or rows you select will appear on all printed pages, making it easier for you to read your data.
Use page breaks
If your spreadsheet exceeds one page, consider using page breaks to precisely choose which data will appear on each page.
When you insert a page break into a spreadsheet, the data below the break will be moved to the beginning of another page. This is quite useful as it allows you to segment data the way you want.
Additionally, when printing, users not only have the option to print on one side of the paper but also the option to print on both sides in Excel, Word, or PDF. The steps for double-sided printing are straightforward and not as difficult as many might think.
Here are 5 essential Excel printing tips for anyone to create a beautifully arranged and visually appealing sheet. Moreover, you can number pages in Excel for printing pages in the order you want, and the process is quite similar to numbering pages in Word.
