: Press Ctrl + P , and under the Printer dropdown, select "Microsoft Print to PDF" . This lets you "print" the file directly to your downloads folder as a PDF. 2. The One-Click Way (VBA Automation)
: For business tax compliance (like GST), you can often download standardized Excel-based invoice formats directly from government GST portals . Pro-Tips for Professionalism:
: You can find professional templates by going to File > New in Excel and searching for "Invoice". Download Invoice From xlsm
Sub SaveInvoiceAsPDF() Dim FileName As String Dim Path As String ' Define where to save (e.g., your Desktop or a specific folder) Path = "C:\Users\YourName\Downloads\" ' Create file name using cell values (e.g., Cell B1 is Invoice #, Cell B2 is Name) FileName = Range("B1").Value & "_" & Range("B2").Value & ".pdf" ' Export the active sheet ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:=Path & FileName MsgBox "Invoice Saved to: " & Path & FileName End Sub Use code with caution. Copied to clipboard
: Before exporting, highlight your invoice area and go to Page Layout > Print Area > Set Print Area . This prevents extra blank pages or random gridlines from appearing in your download. : Press Ctrl + P , and under
If you just need to turn your current .xlsm sheet into an invoice you can send:
If you are looking to download a new template that already has these macro features: The One-Click Way (VBA Automation) : For business
: Go to File > Export > Create PDF/XPS . This ensures your client gets a clean, non-editable document.