How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask bytestream Your Own Question
bytestream, Computer Systems Analyst
Category: Computer
Satisfied Customers: 515
Experience:  MSc, MCP; over 15 years of experience in all aspects of computing
Type Your Computer Question Here...
bytestream is online now
A new question is answered every 9 seconds

How can I print multiple excel files at one time

This answer was rated:

I have about 50 excel files under the same folder name which I would like to print all at once - this would avoid the time consuming task of having to open each file individually to print

hello, Joanna,

Using your Windows Explorer (right-click on Start and select "Explore"), select all the workbooks you want to print, then open the File menu and select "Print".

To select the files, if they are all together, click the first one, then while holding down the SHIFT key, click the last one - SHIFT acts as "through". If the files are not all together, click the first one, then while holding down the CTRL key, each and all files you want to print.

Understand that this will print the entire workbook, so if you have one spreadsheet in a workbook and two blank sheets (sheet2 and sheet3 tabs) you will get a blank print for the empty sheets. So I recommend deleting the blank sheets first.

Explorer will open each one, but you do not have to select each and order a print for each; it's like a batch print command.

bytestream and 5 other Computer Specialists are ready to help you