Even if you have a big spreadsheet, sometimes, you may want to print only selected cells in Google Sheets or Microsoft Excel. There are some in-built options that let you do it quickly. You can customize and print only a specific selection of cells in Excel and Google Sheets with the help of this step-by-step guide.
If you use the default settings or options in Google Sheets or Microsoft Excel, it will print the whole active spreadsheet. Now, let’s assume that you have a big spreadsheet with a lot of data, but you need to print only some rows and columns due to any reason. These rows and columns can be placed anywhere in your spreadsheet.
Both tools have similar options, but they carry 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 selected cells in Excel, follow these steps:
- Open the Excel spreadsheet and select all cells.
- Press Ctrl+P to print.
- Select Print Selection from the list.
- Customize the sheet and print it.
You need to open and select all the cells that you want to print, if you are using Microsoft Excel. After selecting, press the Ctrl+P shortcut to open the Print prompt. From here, you need to expand the Print Active Sheets drop-down menu and choose the Print Selection option.
Now you can make other changes and print the spreadsheet.
How to print selected cells in Google Sheets
To print selected cells in Google Sheets, follow these steps:
- Open the spreadsheet in Google Sheets and use your mouse to select all cells.
- Press the Print button.
- Choose the Selected cells option from the list.
- Customize other settings and print the spreadsheet.
You need to open the spreadsheet in Google Sheets to get started with this tutorial. After that, use your mouse to select all the cells that you want to print. You can click on a cell and drag your mouse to choose everything as per your needs.
After that, click the Print button visible on the navigation bar. You should get the icon under the File/Edit options. Alternatively, you can go to the File menu and select the Print option. Also, you can press Ctrl+P to do the same.
Now you can find some options on your right side. By default, the first option would be the Current sheet. You need to expand that drop-down list and select the Selected cells option.
Here you can see the cell numbers as you selected earlier. After that, you can customize everything to print the spreadsheet accordingly.
That’s it! Hope it helps.
Read: Excel not printing gridlines properly [Fix]
How do I print only certain cells in Google Sheets?
To print only certain cells in Google Sheets, you need to use your mouse to select the desired cells first. Then, press the Print button or press the Ctrl+P. Now you need to expand the drop-down list and select the Selected cells option. Finally, you can change settings as per your requirements before starting the printing process.
How do I print only selected cells in Excel?
To print only selected cells in Excel, you need to open your spreadsheet and choose the cells you want to print. Then, press the Ctrl+P or go to File > Print. Next, you need to expand the drop-down menu and choose the Print Selection option. After that, you can change or modify all the required settings as per your requirements. Finally, click the Print button to start printing.
Read: How to print Document Properties while printing Word document
