How to Only Print the Last Page of a Worksheet in Excel?

Both students and professionals frequently print worksheets in Microsoft Excel. The option to quickly print particular pages can help you save time and resources when creating financial reports, analyses, or presentations. When working with huge data sets or lengthy papers, one situation that sometimes occurs is the requirement to print only the last page of a worksheet.

In this tutorial, we'll walk you through how to print a worksheet's last page alone in Excel. Regardless of your level of Excel proficiency, this video will arm you with the skills necessary to simplify your printing activities and boost your overall productivity.

Only Print the Last Page of a Worksheet

Here, we will first create a VBA module and then run it to complete the task. So let us see a simple process to learn how you can only print the last page of a worksheet in Excel.

Step 1

Consider an Excel sheet where you have data on multiple pages.

First, right-click on the sheet name and select View Code to open the VBA application.

Right Click > View Code.

Step 2

Then click on Insert and select Module, then copy the below code into the text box.

Insert > Module > Copy.

Code

Sub PrintLastPage()
Dim xPages As Long
xPages = ActiveSheet.PageSetup.Pages.Count
If xPages > 0 Then ActiveSheet.PrintOut from:=xPages, to:=xPages, preview:=True
End Sub

Step 3

Then click F5 to run the module. Then you will see that print preview in the pop-up.

This is how you can only print the last page of a worksheet in Excel.

Conclusion

In this tutorial, we have used a simple example to demonstrate how you can only print the last page of a worksheet in Excel to highlight a particular set of data.

Pradeep Kumar

e

Updated on: 06-Sep-2023

98 Views

Kickstart Your Career

Get certified by completing the course

Get Started