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.
- 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.
- 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.
Read More: How to Set Print Area in Excel (5 Methods)
- How to Set Print Area to Selection Using VBA in Excel (3 Methods)
- Excel VBA: How to Set Print Area Dynamically (7 Ways)
- Change Print Area in Excel (5 Methods)
- How to Center the Print Area in Excel (4 Ways)
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.
- 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 option from the View tab to show the data with desired page breaks.
- Finally, you will get the printed area similar to the below image.
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:
- 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.
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.