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)

3

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. ...

MORE FROM ALLEN

Goal Seeking

Excel provides a great tool that is helpful in figuring out what certain variables should be in your formulas. This tip ...

Discover More

Changing Horizontal Orientation

One of the international features of Excel is the ability to switch the orientation of how information is presented. This tip ...

Discover More

Creating a String

Need to use a macro to create a text string? One easy way to do it is to use the String function, described in this tip.

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)

Locking the Print Area

Excel allows you to specify an area of your worksheet that should be printed. Here's how to "lock" that area so it cannot be ...

Discover More

Printing Just the Visible Data

In a large worksheet, you may want to display and print just a portion of the available data. Displaying the desired ...

Discover More

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
Subscribe

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

View most recent newsletter.

Comments for this tip:

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. 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 3 - 0?

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

David

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

Or:
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
Subscribe

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.

Links and Sharing