How to print selected cells in Microsoft Excel or Google Sheets

Even if you have a large spreadsheet, sometimes you may want to print only selected cells in Google Sheets or Microsoft Excel. There are built-in options that let you do it quickly. You can customize and print only a specific selection of cells in Excel and Google Sheets using this step-by-step guide.

If you use the default settings or options in Google Sheets or Microsoft Excel, it will print the entire active worksheet. Now suppose you have a large spreadsheet with lots of data, but you only need to print a few rows and columns for some reason. These rows and columns can be placed anywhere in your spreadsheet.

The two tools have similar options, but they have different names. In other words, there is no need to install an add-on in Google Sheets or Microsoft Excel.

How to print selected cells in Excel

To print the selected cells in Excel, follow these steps:

1. Open the Excel spreadsheet and select all cells.
2. Press Ctrl + P to print.
3. Select Print selection from the list.
4. Personalize the sheet and print it.

You must open and select all the cells you want to print, if you are using Microsoft Excel. After selecting, press the key Ctrl + P shortcut to open the print prompt. From here you have to extend Print active sheets drop down menu and choose the Print selection option.

You can now make other changes and print the spreadsheet.

How to Print Selected Cells in Google Sheets

To print the selected cells in Google Sheets, follow these steps:

1. Open the spreadsheet in Google Sheets and use your mouse to select all the cells.
2. Press the Print button.
3. Choose the Selected cells option from the list.
4. Customize the other settings and print the spreadsheet.

You need to open the spreadsheet in Google Sheets to start this tutorial. After that use your mouse to select all the cells you want to print. You can click on a cell and drag your mouse to choose everything according to your needs.

After that click on the Impression visible button on the navigation bar. You should get the icon under the File / Edit options. You can also access the File menu and select it Impression option. You can also press Ctrl + P Do the same thing.

You can now find some options on your right. By default, the first option would be the Current sheet. You must expand this drop-down list and select the Selected cells option.

Here you can see the cell numbers you have selected previously. After that, you can customize everything to print the spreadsheet accordingly.

That’s it! I hope this helps.