How to Show Print Area in Excel (4 Easy Methods)

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.


Download Practice Workbook

You can download the practice workbook from here.


4 Easy Methods to Show Print Area in Excel

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.

Methods to Show Print Area in Excel

  • Next, select the Print option.
  • Afterward, go to the Print Active Sheets option and choose the Print Selection option.

Methods to Show Print Area in Excel

  • Finally, you will get the below result.

Methods to Show Print Area in Excel

Read More: How to Print Selected Area in Excel (2 Examples)


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.

Methods to Show Print Area in Excel

  • Fourthly, go to the Print Titles option on the side of the Print Area option.

Methods to Show Print Area in Excel

  • 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.

Methods to Show Print Area in Excel

  • After that, select the Print option.

Methods to Show Print Area in Excel

  • 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.

Methods to Show Print Area in Excel

Read More: How to Set Print Area in Excel (5 Methods)


Similar Readings


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.

Methods to Show Print Area in Excel

  • In addition, go to Page Layout>Print Area>Add to Print Area options.

  • Furthermore, select the Page Break Preview option from the View tab to show the data with desired page breaks.

Methods to Show Print Area in Excel

  • Finally, you will get the printed area similar to the below image.

Read More: How to Print Selected Area in Excel on One Page (3 Methods)


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.

Methods to Show Print Area in Excel

  • 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.

Read More: Excel VBA: Set Print Area for Multiple Ranges (5 Examples)


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.

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. Follow the ExcelDemy website for more articles like this. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Zehad Rian Jim
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo