How To Print Multiple Excel Spreadsheets At Once

By Author: Sheree Schiffman
Total Articles: 5
Comment this article

Microsoft Excel is a spreadsheet program that is standard in the Microsoft Office Suite. As a spreadsheet program, it is extremely useful for organizing information into separate rows and columns. However, gathering data into the Excel spreadsheet can be a time-consuming process. As Excel operates using cells, entering information can be slow because the correct cell must be selected each time information is entered. A list of information may all appear within one cell rather than down a list of cells. Excel is also useful for generating tables of data. The spreadsheet layout of Excel is very beneficial for structuring data in rows and columns as a table. These tables permit very quick analysis of data. However, actually getting this information into a hard copy format (on paper) can be tough due to the tabs and active/ inactive spreadsheets within Excel. The terminology of Excel can get puzzling as to what you are actually printing.
There is of course the standard method of printing. This means to first locate the Excel file that you want to print. Open the file and then click the file button in the upper ...
... left-hand corner of the Excel window. Scroll down the list of options and locate the one listed ‘Print'. Click this button and more options will be made available. Here you can decide to print either the active sheets in the workbook (sheets actively being used) or you can decide to print all the sheets. There are additional properties that can be changed including the color of the print or the orientation of the print.
A far easier way of printing multiple spreadsheets is with software attainable through http://www.hothotsoftware.com/excel-print-multiple-excel-files-spreadsheets-at-once_software/. By going to the website and searching ‘How to Print Multiple Excel Spreadsheets' you will find software specially designed to suit your needs. The software will open up in a single window and works entirely within a single window. This reduces the chance of getting confused by the software. You will initially see an empty field at the top of the software window. Excel files needing to be printed may be added to the software by clicking the ‘Add File(s)' button or the software can sort through a folder for any Excel files available. Any files chosen or found will be listed in the field at the top of the window. Then you can determine which sheets in the workbooks need to be printed. You can choose to only print active sheets in each file, which are the sheets actively being used, or you can print all the sheets in each file. Finally, just click the button labeled ‘Print off Microsoft Excel Files/Spreadsheets Now'. An item to note regarding this software is to make sure that all Excel windows are closed before starting the software. Due to the how the software is written having a window open may cause the program to not complete successfully.
To learn more about this software, please visit http://www.youtube.com/watch?v=IoCLEfZPb_U. Data listed in an Excel spreadsheet is very useful for analysis. Use this program to print that information into hard copy format for more analysis or storage.