This tutorial will demonstrate the steps to how to show the print area in Excel. When you are submitting the Excel file or data table in your report, it is essential that it is well presentable to the reader. Otherwise, the report will look messy. The main theme of this article is to set the desired print area in Excel. After going through this article, you will be able to show the print area in Excel on your own.
How to Show Print Area in Excel: 4 Easy Methods
Our goal is to show the print area in Excel. We can do this by using any of the 4 methods. If you follow the steps of these methods correctly then you should learn how to show the print area in Excel on your own. The methods are:
1. Using File Tab Option
We can show the selected print areas in Excel with the help of the File tab option. The steps are given below.
Steps:
- First, select the whole data table.
- Then, go to the File tab option.
- Next, select the Print option.
- Afterward, go to the Print Active Sheets option and choose the Print Selection option.
- Finally, you will get the below result.
2. Use of Page Layout Tab
Using the Page Layout Tab can be another method to show selected print areas in Excel. The steps of this method are described below.
Steps:
- Firstly, select the desired data table.
- Secondly, go to the Page Layout option.
- Thirdly, choose the Set Print Area option from the Print Area option.
- Fourthly, go to the Print Titles option on the side of the Print Area option.
- Then, the Page Setup dialog box will open on the window.
- Afterward, go to the Sheet option and select the Print Preview option and click OK.
- But if you want to open this Page Setup dialog box from the File tab then go to File > Print > Settings > Page setup.
- Furthermore, you can customize the page setup, page margins, and header/footer of your printed area according to your wish.
- After that, select the Print option.
- Finally, you will get the result below.
- If you want to clear the print area then go to the Page Layout option first.
- Then select the Clear Print Area option from the Print Area option.
3. Adding Cells to Existing Printed Area
If you have already printed some portion of the file but now you want to add some data to it the Add Cells option is the only way to do that. The steps are described below.
Steps:
- To begin with, select the data you want to add in the printed area.
- In addition, go to Page Layout>Print Area>Add to Print Area options.
- Furthermore, select the Page Break Preview feature from the View tab to show the data with desired page breaks.
- Finally, you will get the printed area similar to the below image.
Read More: How to Extend Print Area in Excel
4. Applying VBA Code
Applying VBA code can be also a useful method to show print areas in Excel. The steps of this method are:
Steps:
- Firstly, press Alt+F11 to open the VBA window.
- Secondly, select the Module option from the Insert tab.
- Thirdly, insert the VBA code in the window.
Sub Print_Multiple_Range_in_One_Page()
Dim yRng1 As Range
Dim yRng2 As Range
Dim yNewWs As Worksheet
Dim yWs As Worksheet
Dim yIndex As Long
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Set yWs = ActiveSheet
Set yNewWs = Worksheets.Add
yWs.Select
yIndex = 1
For Each yRng2 In Selection.Areas
yRng2.Copy
Set yRng1 = yNewWs.Cells(yIndex, 1)
yRng1.PasteSpecial xlPasteValues
yRng1.PasteSpecial xlPasteFormats
yIndex = yIndex + yRng2.Rows.Coun
Next
yNewWs.Columns.AutoFit
yNewWs.PrintOut
yNewWs.Delete
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub
- Fourthly, save the code and return the worksheet.
- Next, select the desired printed area.
- Furthermore, the Macro tab will open on the screen.
- Select Run to apply the code to the desired selected area.
- Lastly, you will get the result below.
Things to Remember
- The easiest method is the first method.
- In the case of method 3, remember that you have to print the area using the first two methods then if you want to add more cells or data to the printed area only then the Add to Print Area will appear on the screen.
- In the case of using VBA code, after inserting the code make sure to save it otherwise the code won’t work.
Download Practice Workbook
You can download the practice workbook from here.
Conclusion
Henceforth, follow the above-described methods. Thus, you will be able to show the print area in Excel. Let us know if you have more ways to do the task. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.
Related Articles
- How to Change Print Area in Excel
- How to Delete Extra Pages in Excel
- [Solved:] Print Area Is Grayed Out in Excel
- [Fixed!] Excel Set Print Area Not Working
<< Go Back to Print Area | Page Setup | Print in Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!