Hi guys, we know very well about the MS Excel. MS Excel is an application software which is widely used in different locations. MS Excel is an electronic spreadsheet software which is used for data analysis, modeling, representation data inform of chart, solve complex calculations using functions and many more. There are lot of options available in print dialog box, for printing the data. Today, we have to discuss how to print selected range of cells in MS Excel.
If you give print command then by default all the data of active sheet will be printed. It consumed lot of ink and paper during the printing. But if you don’t need to print completed data of active sheet then you must select or set print area. When you are doing job, you will get large database. There are lot of rows and columns in which records are stored. If you directly give print command all active sheet data will be printed. But if you want to print selected range of cells in MS Excel then you must have to take following given steps.
Must Read: Prevent duplicate values with Data Validation in MS Excel
Steps to print selected range of cells in MS Excel:
There are different ways from which you can easily print selected range of cells in MS Excel.
Method 1:
Step 1: Open the active sheet in which you want to print selected cells in MS Excel.
Step 2: Select the required area which you want to print selected cells in MS Excel. For selection range of cells either you can drag mouse button or use SHIFT+Arrow Keys.
Step 3: Open the Print dialog box by clicking Print command from File/Home tab. You can also press CTRL+P to directly open the Print dialog box.
Step 4: Choose Print Selection option in the Settings. Now, click the Print button.
Method 2:
Step 1: Open the active sheet in which you want to print selected of cells in MS Excel.
Step 2: Select the required area which you want to print selected range of cells. For selection range of cells either you can drag mouse button or use SHIFT+Arrow Keys.
Step 3: Click on the Page Layout tab > Choose Print Area option > Click on the Set Print Area button. This option is used to print any specific area for printing. Now, you will see a dashed border draw on the selected range of cells.
Step 4: Open the Print dialog box by clicking Print command from File/Home tab. You can also press CTRL+P to directly open the Print dialog box. Now, click the Print button.
Must Read: VLookup Function in MS Excel with Appropriate Match
I hope you like this article. After reading all these easy steps you will be able to know how to print selected range of cells in MS Excel. Kindly share your knowledge with your friends, family members and others. Thanks to all.