PDF files are easy to print and in some cases also to read. So most of the time while printing our Excel file it is convenient to convert it into PDF or save the file as PDF initially. This article shows some easy and quick methods to save one sheet in Excel as PDF in various ways. The methods shown are valid for Mac and Windows Operating Systems.
Save One Sheet at a Time in Excel as PDF: 3 Ways
Suppose, you have a workbook with multiple sheets. Now, you want to save one sheet as a PDF. Follow the following easy instructions below and you will get what you need in no time. For example, here you can see multiple sheets for different standards in a school with the credentials of students in it.
1. Use the Save As Option in Excel to Save One Sheet As PDF
Though the Save As option is used to save your workbook for the first time, you may also use the option to save one sheet as a PDF file. So, follow the below steps with the help of the Save As option to create PDF files for one sheet in Excel.
Steps:
- Firstly, go to the worksheet that you want to save as a PDF.
- After that, click on the File button in the top left corner.
- Next, move your cursor to the Save As option and press it.
- At this point, click on Browse to choose your file destination.
- Subsequently, choose your file name and type it in.
- Here, click on the arrow showing down as shown in the figure.
- Now, choose PDF from all the options.
- Next, click on the Options button and a box will open up.
- Here check the Active Sheet(s) box and press OK.
- Finally, if you followed all the instructions above, click the Save button and you will get your PDF.
That’s how we save the file as PDF.
Read More: How to Save Excel as PDF
2. Using the Export Option in Excel to Save One Sheet as PDF
You may follow the steps below with the help of the Export option to create PDF files for one sheet in Excel.
Steps:
- Make sure you stay on the worksheet you want to save as a PDF.
- Next, click on the File button in the top-left corner.
- Here, move your cursor to the Export button first, and select it.
- Secondly, click on the Create PDF/XPS Document.
- And thirdly, select the Create PDF/XPS.
- Now, browse your destination and select your file name.
- Click on the arrow showing down as 1 in the figure and select PDF.
- At this point, select the Options.
- Now, check the Active Sheet(s) box, if not already checked in.
- Finally, click on the Publish button to get your desired PDF.
Read More: How to Save Excel File as CSV
3. Using Print Option in Excel to Save One Sheet as PDF
If you are a Windows 10 User, you may follow the steps shown below with the help of the Print option to create PDF files for one sheet in Excel.
Steps:
- Start by checking you are on the same sheet you want to print.
- Now, click on the File tab.
- Then, click sequentially on Print > Down Arrow on Microsoft Print to PDF > Microsoft Print to PDF.
- At this point, click on the Print button at the top.
- Here, browse your destination and select your file name.
- Lastly, click on the Save option and you will get your PDF.
Read More: How to Save Multiple Sheets in Excel to CSV
Using VBA to Save Sheets as Separate PDF files
Consider a scenario, where you have multiple worksheets and you want to save each of those as separate PDF files with the Same File Names as the Worksheets in a single click. You can do this within seconds by following the instructions below:
- Start by pressing ALT+F11 to open the Visual Basic Editor.
- Now, go to Sheet1 and right-click on it.
- After that, move your cursor to Insert and choose Module from the options.
- Next, copy the VBA code below and paste it into the blank space.
VBA Code:
'This Code Can be Used to Save Multiple Sheets In a Workbook Separately As Pdf
Sub SaveOneSheetPDF()
'We are defining ActSheet
Dim ActSheet As Worksheet
'We call the For Each function to run a loop for all the Sheets in the Workbook
For Each ActSheet In Worksheets
'We call ActSheet.ExportAsFixedFormat to save each sheet as pdf
'The destination path of the pdf in this code will as same as the workbook path
'You can Change the destination path by changing 'Application.ActiveWorkbook.Path & "\"'
'For example if you want to save it in desktop change it to 'Environ("Userprofile") & "\Desktop\"'
'Actsheet.Name saves pdf in same names as its worksheet name
ActSheet.ExportAsFixedFormat xlTypePDF, Application.ActiveWorkbook.Path & "\" & ActSheet.Name
Next ActSheet
End Sub
- At this point, click on the Run Sub button or simply press F5.
- Now, select the Macro name SaveOneSheetPDF and hit the Run button.
- Eventually, you’ll see that you have separate PDF files named the same as your worksheets.
You can download the practice workbook through the link below.
Conclusion
Finally, I hope you got what you wished from this article. Feel free to drop a comment below if you have any queries.
