Written by Allen Wyatt (last updated October 3, 2020)
This tip applies to Excel 97, 2000, 2002, and 2003
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! This guide will provide you with all the information you need to automate any task in Excel and save time and effort. Learn how to extend Excel's functionality with VBA to create solutions not possible with the standard features. Includes latest information for Excel 2024 and Microsoft 365. Check out Mastering Excel VBA Programming today!
If you want to save paper on a printout, you might consider printing multiple pages on a single piece of paper. This can ...
Discover MoreWant to print one ore more workbooks without the need of actually opening the file? It's easy to do when you rely on ...
Discover MoreIf you are using a macro to create your printed Excel output, you may need a way to specify that paper should come from a ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2024-04-12 14:19:22
Barbie
Couldn't you simply save the file to a flash drive, take it to Joe's computer, open it there, and print normally without going through extra, unfamiliar steps?
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.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments