Tech Talk Jong! - How to Print Multiple Excel Files?

[Chainsaw_Willie]

I have 72 separate Excel spreadsheets I need to print out.

Is there any way to do this that's more efficient than opening and printing each one?

[DJSapp]

If the cell locations were identical, could you do a vlookup table and put it all into one sheet?

By the time you figure it out, you'd be done and 4 beers deep with just doing cntrl p
--------------------------------------
my phone is better than yours.

[Yonder_River]

hold down control and highlight all tabs and print or just create pdf from those and print that.

Sent from my SPH-L710 using TGR Forums

[Chainsaw_Willie]

They are all individual files, not tabs in one file.

[Yonder_River]

They are all individual files, not tabs in one file.

Then just select all of them and right click and select print from the menu. Should be simple.

[PNWbrit]

Then just select all of them and right click and select print from the menu. Should be simple.

^ This.

You may not be able to print all 70 at once depending on the size of documents. but should work for batches of them at a time. You'll need to make sure your print preferences are set to be spread sheet friendly too - landscape, size to include all columns print all active pages...

There is software that'll do this on large scale but not worth the time let alone $ if this is one off thing.

[Chainsaw_Willie]

Then just select all of them and right click and select print from the menu. Should be simple.

???

If I open the directory on my hard drive that contains the files, select all, then right-click there is no "print" option. The files aren't open at that point, so how could they be printed?

[Chainsaw_Willie]

I just opened all of them, so now I have 72 instances of Excel running on my machine. Still no way to print from more than one at a time...?

[PNWbrit]

???

If I open the directory on my hard drive that contains the files, select all, then right-click there is no "print" option. The files aren't open at that point, so how could they be printed?

try right right clicking on one you see the print option there?

now select two of them right click - still see print option?

try a bunch more say 10 at a time.

Excel will briefly open each one and send to print.

If you don't have preferences set correctly they will all be fucked up though.

Ultimately might be quicker to do one at a time now rather than later.

I just opened all of them, so now I have 72 instances of Excel running on my machine. Still no way to print from more than one at a time...?

Face palm.

I give up.

Have you tried turning it off and on again.

[Yonder_River]

They can be printed without being open. Not sure why you aren't seeing your files. It works though.

[Chainsaw_Willie]

the files were all created from a single template that's formatted for printing a single page in portrait orientation, so no worries there.


Okay, just discovered something - if I select only a few files then I get a "print" option in Explorer but if I select all of them the menu is missing several options, one of which is print. I guess doing it in batches is still better than doing each one individually.

Thanks!

[grrrr]

Open control panel, open printers, right click, click see what's printing, drag files from directory into box, say yes when it asks you if you want to print multiple files. Assuming you're on da windows.

[grrrr]

the files were all created from a single template that's formatted for printing a single page in portrait orientation, so no worries there.


Okay, just discovered something - if I select only a few files then I get a "print" option in Explorer but if I select all of them the menu is missing several options, one of which is print. I guess doing it in batches is still better than doing each one individually.

Thanks!

That happens when you have too many files or the files are not all the same filetype. Found that out trying to batch print pdf's.

[PNWbrit]

Okay, just discovered something - if I select only a few files then I get a "print" option in Explorer but if I select all of them the menu is missing several options, one of which is print.

Exactly That's it....

Found that out trying to batch print pdf's.

PDF are far easier. there are some pretty good freeware tools that'll let you do effectively limitless PDFs.

This one is super simple for starters http://www.freewarefiles.com/Multipl...ram_24346.html

[Chainsaw_Willie]

Thanks again for the help. I had no idea you could print directly from Windows like that, much less multiple files.

This machine will let me print 15 files in one batch, good enough.