Last week we spoke about printing duplex or double sided spreadsheets from Microsoft Excel. Today let’s talk about a couple of other printing issues you might see with Microsoft Excel and your Xerox printer, gridlines and collation. The information in this article comes straight from the cases and solutions in our online support pages.
Printing gridlines is another printing issue from Excel that we get questions about on the Xerox Customer Support Community Forum. Please take a look at the following instructions for enabling the gridlines.
Enable the Gridlines Option in the Microsoft Excel Application
NOTE: This solution assumes Microsoft Excel 2010 is being used. Other versions of Excel may vary.
- Open the file to be printed, and then select click the Microsoft Office Button/File, point to Print, click Print, and then click Page Setup. The Page Setup window will be displayed.
- Click on the [Sheet] tab.
- Click on the [Gridlines] check box in the Print section to insert a check mark and enable the option.
- Click on [OK].
- Click [Print].
Collating from Microsoft Excel is also an issue we receive questions about on the Xerox Customer Support Community Forum. Printing collated depends on collation being chosen in the correct area. Let’s look at the instructions for an explanation of how to get your jobs to collate.
Use the collate feature from the print driver instead of from within Microsoft Excel.
If the Collate check box is selected in the Excel Print window, Microsoft Excel creates and sends a separate identical print job to the printer for each copy requested. For example, if five copies of a worksheet are printed, five print jobs are created and sent to the printer.
If the Collate check box is unchecked in the Excel Print window, Microsoft Excel creates one print job and sends it to the printer with instructions to print it five times. The printer will still collate the job if the Collate option is selected in the print driver properties.
- From Excel, select [Print] from the File menu. The Print window will be displayed.
- Click on the [Properties] button. The Properties window will be displayed.
- Click on the [Paper / Output] tab, if necessary.
- From the Output / Stapling or Select Finishing menu, select [Collated].
- Click on [OK] to return to the Print window.
- In the Copies section, click on the Collate check box to remove the check mark.
- Enter the number of copies to be printed in the Number of Copies field.
- Click on [OK] to submit the print job.
If these instructions have not cleared up any confusion or issues you were having when printing from Microsoft Excel please consider searching the online support or contacting your local support centre for additional information. You can also search posts or post your own question on the Xerox Customer Support Community Forum.