Follow

How do I Convert a Report from Excel to PDF Without Losing Data or Shrinking the Table?

Converting Excel reports to PDF files can sometimes cause issues with the size of the report tables and/or loss of data. The following can be a way of preventing this.

 

To convert an excel report to pdf:

 

  • Log into HammerTech (if you are not already logged in), then navigate using the left-hand menu and select > Reports > then select whichever report you would like to download. (In this instance we will select Hours Worked.

ReportSelect.jpg

  • Select a start date and end date for the data you wish to obtain. Then select if you want a Daily, Weekly, Monthly or Total only report of the hours worked.
  • Then select "Download Report".

Download_Report.jpg

  • The report will now download and will appear down the bottom left hand of your desktop (if you are using chrome.

Open_Report.jpg

  • Select the report. Once done this will open the report in Excel. Note: You may have to enable "Editing" if opened in "Protective View".
  • Now highlight the information from the table you want to save to a PDF.

Highlight_Information.jpg

  • Then in the top left, select > File > Print. 

File.jpg

Print.jpg

  • Change the printer to "Microsoft Print to PDF".

Print_to_PDF.jpg

  • Next, under settings, change from "Print Active Sheets" to "Print Selection".

Print_Selection.jpg

  • Now click print. It will ask you to save the PDF file in your desired location. 

 

Note: If "Microsoft Print to PDF" is not an option. Please follow the below link to enable this.

https://www.isumsoft.com/windows-10/enable-microsoft-print-to-pdf-option-in-windows-10.html

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk