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:
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:
Figure 1. The Paste Special dialog box.
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.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
In a large worksheet, you may want to display and print just a portion of the available data. Displaying the desired ...
Discover MoreNeed to print several portions of a worksheet all on a single piece of paper? Here's an easy way you can get what you ...
Discover MoreGot just a small amount of worksheet data to print out? It might look better on the printed page if you center it. Excel ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
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
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.
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 © 2021 Sharon Parq Associates, Inc.
Comments