If you want to print specific cells in Excel, you can use the VLOOKUP function. This function looks up a value in a column and prints the corresponding cell. Here’s how to do it:
- Open Excel and create a new worksheet.
- Enter the following data into the worksheet: A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
- Select the range A1:D10 on the worksheet.
- In the formulas bar, enter VLOOKUP(A1,B2). This will return the value in cell B2 as a result of looking up A1 in column B. The result should look like this: A B C D E F G H I J K L M N O P Q R S T U V W X Y Z ..
Sometimes you want to print only a specific selection of cells on a worksheet. But when you print in Microsoft Excel, all data on a worksheet is printed by default. This article will show two ways to print a selected range.
Printing a Specific Selection of Cells in Microsoft Excel
This first option is the quickest method to print a selected range of cells.
Select and highlight the range of cells you want to print.
Next, click File > Print or press Ctrl+P to view the print settings.
Click the list arrow for the print area settings and then select the “Print Selection” option.
The preview will now show only the selected area. Click “Print” to finish the process.
Setting the Print Area in Microsoft Excel
If you print the selected area frequently, you can set the selected range as the print area. This option will save you from needing to select the range each time you print.
Select the range of cells you want to set as the print area. Next, click Page Layout > Print Area > Set Print Area.
The print area is now set.
The next time you print (File > Print or press Ctrl+P), this area will be printed by default.
To remove a print area, click Page Layout > Print Area > Clear Print Area.
RELATED: Why Do You Need Formulas and Functions?
