The Daily Pulse.

Timely news and clear insights on what matters—every day.

education insights

How do I print multiple Excel sheets at once?

By Jessica Young |

How do I print multiple Excel sheets at once?

If you want to print multiple sheets in a workbook together, please do as follows:
  1. Open the specified workbook, and then select multiple sheet tabs you will print.
  2. Click File > Print.
  3. Go ahead to select Print Active Sheets in the drop down list below Settings, specify a printer, and click the Print button.

Also know, how do you print multiple worksheets on one page in Excel?

Printing Multiple Worksheets on a Single Page

  1. Choose Print from the File menu.
  2. In the Print What area of the dialog box, choose the Entire Workbook option.
  3. Click the Properties button.
  4. Set the Pages Per Sheet control to 4.
  5. Click OK to close the Properties dialog box.
  6. Click OK to actually print the worksheets.

Beside above, can you batch print Excel files? To batch print Excel files with a defined print area:

Open your worksheets/workbooks in Excel; Select the needed cells of a worksheet; Go to Page layout > Print Area and click Set Print Area (do it for every worksheet if needed); Batch print them via Print Conductor.

Beside above, how do I print two Excel sheets front and back?

Click the Microsoft Office Button/File, point to Print, click Print, and then click Properties. On the Layout tab, select the one of the duplex options, and then click OK. Click OK in the Print dialog box. Repeat these steps for every sheet in the workbook.

How do you print multiple Excel files at once without opening?

Simply follow these steps:

  1. Use the Explorer, My Computer, or any Open dialog box to display the workbook that you want to print.
  2. Right-click on the file. Windows displays a Context menu.
  3. Choose the Print option from the Context menu.
  4. Windows loads Excel (if it is not already open), opens the workbook, and prints it.

How do you Print worksheets on one page in Excel?

Shrink a worksheet to fit on one page
  1. Click Page Layout.
  2. Select the Page tab in the Page Setup dialog box.
  3. Select Fit to under Scaling.
  4. To fit your document to print on one page, choose 1 page(s) wide by 1 tall in the Fit to boxes.
  5. Press OK at the bottom of the Page Setup dialog box.

How do I Print multiple Excel sheets into one PDF?

Solutions:
  1. Click Excel Options. Click Entire Workbook or Sheets From a Range. With Sheets From a Range you will need to specify the range you want.
  2. Click OK. Click Convert to PDF.
  3. Choose The file location and name to save to then click Save.

How can I Print two pages on one sheet?

Choose File > Print. From the Page Scaling pop-up menu, select Multiple Pages Per Sheet. From the Pages Per Sheet pop-up menu, select a value. Click OK or Print.

How do I make an Excel spreadsheet two pages?

On the Page Layout tab, in the Page Setup group, click Breaks. 3. Click Insert Page Break. Excel displays a solid line (manual page break) to show you where the new page begins.

How do I print selected worksheets in Excel 2010?

Select the worksheets you want to print. To print multiple worksheets, click the first worksheet, hold down the Ctrl key, then click the other worksheets you want to select. Click the File tab. Select Print to access the Print pane.

How do I print different tabs in Excel?

To print multiple sheets
  1. Load the appropriate Excel file.
  2. Use the CTRL or SHIFT keys in conjunction with the mouse to select all appropriate sheet tabs displayed at the bottom of your Excel workbook.
  3. Save the workbook.
  4. From the File menu, click Print.
  5. Make sure the Snapshot printer is selected before clicking OK.

How do I print back to back sheets?

Set up a printer to print to both sides of a sheet of paper
  1. Click the File tab.
  2. Click Print.
  3. Under Settings, click Print One Sided, and then click Manually Print on Both Sides. When you print, Word will prompt you to turn over the stack to feed the pages into the printer again.

How do I print my Excel spreadsheet as a booklet?

Print the booklet or newsletter
  1. On the File menu, click Print, and then click the Publication and Paper Settings tab.
  2. In the Print dialog box, under Printing options, verify that Booklet, side-fold is selected.
  3. Select any other options that you want, and then click OK to print the publication.

How do I print a long row on one page in Excel?

One way to set this is: Go File > Print and select the Scaling dropdown under the Settings. Select Custom and on the Page tab set "Fit to" 1 page wide and 99 (or any large number) tall.

How do you hide a worksheet?

Hide or unhide a worksheet
  1. Select the worksheets that you want to hide. How to select worksheets.
  2. On the Home tab, in the Cells group, click Format > Visibility > Hide & Unhide > Hide Sheet.
  3. To unhide worksheets, follow the same steps, but select Unhide.

How do I print multiple files at once?

Press [Ctrl], and select the files you want to print. (If the files are adjacent, select the first file in the list, press [Shift], and select the last file in the list.) Right-click the selection, and select Print from the shortcut menu. Select the desired print options, and click OK.

How do I make Excel print larger?

Follow these steps to scale the worksheet for print by increasing or decreasing its font size.
  1. In the worksheet, click File > Print.
  2. Under Settings, click Custom Scaling > Custom Scaling Options.
  3. Click Page and in the Adjust to box, choose a percentage by which you want to increase or decrease the font size.

What will the current worksheet look like when printed?

When you select one or more sheets and then click File > Print, you'll see a preview of how the data will appear on the printout. Select the worksheet(s) you want to preview. Click File, and then click Print to display the Preview window and printing options. Keyboard shortcut You can also press Ctrl+F2.

Why does excel print to multiple PDF files?

This happens because one (or multiple) sheets in your workbook have a different dpi setting for printing. Because of this, Excel assumes that each individual sheet has to be sent for printing separately, so it will send it in the same way to the PDF printer which will prompt to create a PDF from each sheet.

How do I print without opening a file?

When you want to print a document without opening it, simply drag the document file to the correct printer icon on your desktop. You can drag multiple files simultaneously and they will print, but not in any particular order. Next week's tip will explain how to set up a drag and drop PDF creator.

How do you print all the files in a folder without opening each one?

How to print all the files in a folder without opening each one?
  1. Type *. PDF in the Search box at the upper right.
  2. For 1-15 files, press CTRL+A to select all of them.
  3. For 16 or more files, select 15 of them (click the first, SHIFT +click the last).
  4. Right-click any file and click Print .
  5. Repeat steps 3-4 as required.

How do I print all files in a folder?

To print all of the files in a folder, open that folder in Windows Explorer (File Explorer in Windows 8), press CTRL-a to select all of them, right-click any of the selected files, and select Print. Of course, you can also select a few specific files and print them the same way.