How to print a selected range of cells on Microsoft Excel and Google Docs

If you need to organize data in a tabular form, there is nothing better than doing that in a spreadsheet. When it comes to spreadsheet programs, Microsoft Excel is the most popular one, however, Google Sheets has also earned a lot of popularity among a number of users in the recent days for the flexibility to work on it from anywhere. But even after organizing everything in a tabular form, you sometimes need to print the same out, which can be done by the conventional method. Depending upon the number of tables, you might need several sheets of paper to print the entire spreadsheet.

However, at times, you might need to print a part of the spreadsheet, and you can do that with both Microsoft Excel and Google Docs by tweaking a small setting at the time of printing the spreadsheet. Apart from printing, the tutorial will also be applicable, if you want to save a certain part of a spreadsheet as a PDF document, using a PDF printer. The ability to print certain parts of a spreadsheet can surely come in handy in a number of real-life situations, both for your official, as well as your personal requirements.

So, without any further delay, let’s get started with, how you can print a certain area of a spreadsheet using Microsoft Excel and Google Docs.
 

Print selected cells in Microsoft Excel

Step 1: Open the spreadsheet on Microsoft Excel, which you are going to print, and select the cells within the spreadsheet that you want to print.

Print selected set of cells on Excel and Google Docs 10

Step 2: After you have selected the cells that will be printed, click on ‘File’ and then on ‘Print’. Alternatively, you can use the universal shortcut key, i.e. ‘Ctrl + P’ to get the ‘Print’ dialogue.

Ctrl + P to print excel sheet cells

Step 3: In the ‘Print’ dialogue, click on the first drop-down menu under ‘Settings’, and select ‘Print Selection’. By default, the selected option will be ‘Print Active Sheets’. After you have made the selection, a preview will be displayed on the right side of the screen. If you are satisfied with the preview, just click on the ‘Print’ button.

Print Active Sheets

You will get only the cells that you have selected, printed on a piece of paper. However, if the selected set of cells is too big for one page, it will require more pages to get the selected set of cells printed.

I have used Microsoft Excel 2019 for this tutorial. However, the process will hardly vary, on the older versions of Microsoft Excel, as well.

Print selected cells in Google Docs

The process is similar if you are using Google Docs, as well.

Step 1: Just select the set of cells that you want to print on the spreadsheet selected by you.

Print selected cells in Google Docs

Step 2: Now, click on ‘File’, and then click on ‘Print’. Just like the previous case, you can use the ‘Ctrl + P’ shortcut key, as well.

Print selected set of cells  in Google Docs 50

Step 3: After the Print dialogue appears, just select ‘Selected cells’ from the drop-down menu under ‘Print’. The selected range of cells will also be displayed to you. A preview will be displayed to you, just like it was, in the case of Microsoft Excel. After you are satisfied with the preview, click on ‘Next’.

Take a print out of select cells in Google Docs 60

Finally, you will have to select the printer, and other system-specific settings to print the selected set of cells on a piece of paper.

So, it is really easy to print a selected set of cells both in Microsoft Excel and Google Docs. This will really be useful in your everyday life. Do you have any questions? Feel free to comment on the same below.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.