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

Get FREE Advanced Excel Exercises with Solutions!

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.

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


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


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

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.


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


<< Go Back to Print Area | Page Setup | Print in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Zehad Rian Jim
Zehad Rian Jim

Zehad Rian Jim is a dedicated professional with a BSc. Degree in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. He's good with Microsoft Office and has written more than 80 helpful articles for ExcelDemy in the last year. Now, he makes fun and easy-to-follow Excel tutorials for YouTube as part of the ExcelDemy Video project. Zehad loves figuring out Excel problems, and his passion for learning new things in Excel shines through in... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo