However, the process will hardly vary, on the older versions of Microsoft Excel, as well. I have used Microsoft Excel 2019 for this tutorial. 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. You will get only the cells that you have selected, printed on a piece of paper. If you are satisfied with the preview, just click on the ‘Print’ button. After you have made the selection, a preview will be displayed on the right side of the screen. By default, the selected option will be ‘ Print Active Sheets ’. Step 3: In the ‘Print’ dialogue, click on the first drop-down menu under ‘Settings’, and select ‘ Print Selection ’. ‘ Ctrl + P ’ to get the ‘Print’ dialogue. Alternatively, you can use the universal shortcut key, i.e.

Step 2: After you have selected the cells that will be printed, click on ‘File’ and then on ‘Print’. 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 cells in Google Docs Print selected cells in Microsoft Excel 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. 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. 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. 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. Depending upon the number of tables, you might need several sheets of paper to print the entire spreadsheet.

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. 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. If you need to organize data in a tabular form, there is nothing better than doing that in a spreadsheet.

Google excel set print area