The files will print into separate PDF files in the following order, in the order you put them into your document. Select All Sheets (tab) 1 2 3 4 5 6 7 8 9 10 11 (tab) 1 (tab) 2 (tab) 3 (tab) 4 (tab) 5 (tab) 6 (tab) 7 (tab) 8 (tab This function works for all versions of Excel. It can be useful when you need to transfer data into your file from a printout which has to be read on a large screen or when you want to keep all the Excel macros in one place for printing. Jan 30, 2023 — Print Excel Worksheets as a single PDF. This tutorial shows how to save your worksheets as a single spreadsheet in PDF format. After opening up each sheet, you can choose whichever files you want to print, the number of columns and rows can be up to 5 rows and columns. The print sheet can be printed twice for easy reference while the other sheet is a blank file for keeping the worksheets and macros up-to-date. You would print the number you want on the first sheet as “First print” while the other sheets have those numbers printed on “Second print”. Step 1. Open the file Note : Each .xls, .LSM and .xlsx file may be named different. Click on the “File” icon located on the toolbar and select “Open” for a new instance of the spreadsheet. In “File Type” select “A3” and in the “Save As Name” box choose “PDF” without pressing enter. To save the worksheet as a different name, press Ctrl+R with the following string in front of “File Name”. Note: the strings above refer to the following columns : Column A — Column B — Column C — Column D — … Note: the last column “C” in Excel should be replaced by .csv. You can now close all active Excel windows as shown in the picture below. Next, we will open up “Formula” Step 2. Open up “Formulas” As shown in the picture below, select all the cells and press “Ctrl + Left Arrow” with “Cell Data” selected as shown in the picture for this screenshot. The “Formula” dialog box will appear. Step 3.