by Allen Wyatt
(last updated January 5, 2018)
Let's say you work in an office and are preparing a presentation with Excel. You want your presentation to look as good as it can, but the only printer you have is an old low-resolution ink-jet printer. While this output might be acceptable for some purposes, you want your presentation to look real good. You know that Joe, down the hall, has a 1200dpi (dots per inch) PostScript color laser printer (lucky Joe!), and this would give your presentation the punch you need. Unfortunately, Joe's printer is not available through your office network. Short of unplugging his printer and hefting it down to your office, what do you do?
The easiest solution is to print your workbook to disk or to a thumb drive (one of those little memory-based drives) and then take the file down to Joe's computer where you can send it to the printer. While this might seem complicated, it is not really. There is, however, a specific sequence of steps you must follow:
Figure 1. The Print dialog box.
When you print, you will be asked for a filename where you want the printer output stored. Supply a regular filename. Outside of this, printing will appear to progress as normal. When you have finished printing, you can then copy the newly created output file to the disk or thumb drive and walk it down to Joe's machine. If the name of the file is REPORT.OUT , you would enter the following at the command prompt on Joe's machine:
COPY F:REPORT.OUT LPT1:
Just replace the F: with the drive letter of the drive on which your output file is located. (Chances are good it will be something else.) This command sends the report file to the parallel printer port on Joe's machine.
Shortly you will have the output you desire. (If you use this command and it does not seem to work properly on Joe's system, try it by adding a space and a /B to the end of the line.)
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3240) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!
Need to print an entire workbook? It's as easy as adding a single line of code to your macros.Discover More
The Print Preview feature can be a great way to see how something will look on paper without actually using any paper. ...Discover More
When you print out a filtered worksheet, you may want some sort of printed record as to what filtering was applied to the ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.