Excel makes it easy to print your spreadsheets and charts. Here are the steps on how to print in Excel:
How to print in Excel?
Open the spreadsheet or chart you want to print.
Click the File tab.
In the Settings section, choose the options you want. For example, you can choose to print the entire workbook, a specific sheet, or a range of cells.
Note: If the document content’s width is too bred, or too high for the A4, then you could change the portrait orientation, which is marked in red. This would be effective if the rows are short, but the width is breeder.
How to print a full page chart?
In this example, you will learn how to shrink your chart so that it fits on the page. This is an excellent trick which lets you print clear charts.
Choose your chart.
Click File > Print.
In Setting choose Fit Sheet on One Page.
How to print all tabs?
This is how to print an entire workbook in Excel.
You can print all the sheets together. Excel has got an option which lets you print the entire workbook.
To print all the tabs, go to Ribbon. Click File > Print.
Printing entire workbook
Here you see the Settings. In the first list, you can choose what to print. Click Print Entire Workbook.
Excel will print the entire workbook.
Things to Remember
- If your printer can only print A4 pages, you may need to change the orientation of the printout to portrait.
- To print a full-page chart, you can choose the
Fit Sheet on One Pageoption in the Settings section.
- To print all the tabs in a workbook, select the
Print Entire Workbookoption in the Settings section.