Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Printing Columns and Rows.

Printing Columns and Rows

by Allen Wyatt
(last updated May 30, 2015)


Brent asked if it was possible to print a single column and a single row from a worksheet on the same piece of paper. (His boss wanted to see just the "crossed" information.) Unfortunately, there is no intrinsic way within Excel to specify to print only a single column and a single row. If you select both the column and row you want to print, and then choose to print just the selection, Excel still treats them as separate selections and prints them in that way. There are a couple of workarounds, however.

The first approach is to simply "hide" the information you don't want to print by setting its font color to white. You can do that by following these general steps:

  1. Choose the first range of cells you don't want to appear on the printout.
  2. Change the color of the text in those cells to white.
  3. Repeat steps 1 and 2 for each range you don't want on the printout.
  4. Print your worksheet as normal.
  5. Select the entire worksheet (press Ctrl+A).
  6. Change the color of the text in the cells to Automatic.

Another approach is to copy the row and column to a different worksheet. This is quick and easy to do using the keyboard (Ctrl+C to copy and Ctrl+V to paste), but there is a drawback. If the row or column you are copying contains formulas that rely on other areas of the worksheet, the copied data will not show the proper results. Thus, the best "cut and paste" approach would be as follows:

  1. Insert a new, blank worksheet in your workbook.
  2. Switch to the worksheet that contains the row and column you want to copy.
  3. Select the column you want to copy and press Ctrl+C.
  4. Switch to the new worksheet and select the column where you want it pasted.
  5. Choose Paste Special from the Edit menu. Excel displays the Paste Special dialog box. (See Figure 1.)
  6. Figure 1. The Paste Special dialog box.

  7. Select the Values radio button, then click on OK.
  8. Switch back to the worksheet that contains your original data.
  9. Select the row you want to copy and press Ctrl+C.
  10. Switch to the new worksheet and select the row where you want it pasted.
  11. Again display the Paste Special dialog box, as you did in step 5.
  12. Select the Values radio button, then click on OK.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3029) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Printing Columns and Rows.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...


Turning Off Comment Color when Printing

Comments that you add to your document are most often displayed in a bright color so they aren't easily missed. If you ...

Discover More

Where Is that Text?

Looking for a formula that can return the address of a cell containing a text string? Look no further; the solution is in ...

Discover More

Limiting which File Types You See in Drive

Overwhelmed with the number of files displayed on your screen when using Drive? Here's a handy way you can limit what is ...

Discover More

Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!

More ExcelTips (menu)

Adding the Set Print Area Tool

Spend a lot of time defining print areas in your workbooks? You might benefit by adding a Set Print Area tool that makes ...

Discover More

Centering Your Worksheet

Got just a small amount of worksheet data to print out? It might look better on the printed page if you center it. Excel ...

Discover More

Setting the Print Area

Many people, when they print a worksheet, print the entire thing. You don't have to, however. You can specify that Excel ...

Discover More

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.


If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 5 + 9?

2015-05-31 08:04:53

Pamela - Computer Tutor

A really quick and easy way to print selected data is to:
1. Select (highlight) the data you wish to print.
2. Press CTRL P or go to the print icon.
3. In the printer settings click on "Print Selection" and the printer will print only the currant selection.

2015-05-30 10:36:26


Why not use Conditional Formatting?
1. Specify Print Range to include upper-lower, & left-right limits.
2. Set all Font colour to white; format all Fill to No Colour.
3. Highlight required Column & set Font/Fill to colours of your choice using Set formats against specific cells/ range of cells
4. Wash/Rinse/Repeat on requisite Row
5. & ..... Robert's your Father's Brother, as they say!!!

2015-05-30 08:35:39

Shawn Van Doren

1 In new blank worksheet use lookup function to show only the data to be printed
2 Use Data Filter function. Insert column(s) if necessary to insert a checkmark or "P" for print filter. When ready to print click on drop down arrow for column including your checkmark or "P". Deselect 'all' and click on checkmark or "P". Only selected data will show. Hide whatever information you don't want to print, then just print. After printing go back to columns and select 'all' from drop down arrows.

This Site

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.

Newest Tips

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.