Even you probably have a giant spreadsheet, generally, it’s your decision to print solely selected cells in Google Sheets or Microsoft Excel. There are some in-built choices that allow you to do it rapidly. You can customise and print solely a selected number of cells in Excel and Google Sheets with the assistance of this step-by-step information.
If you employ the default settings or choices in Google Sheets or Microsoft Excel, it is going to print the entire energetic spreadsheet. Now, let’s assume that you’ve got a giant spreadsheet with lots of information, however you want to print just some rows and columns due to any motive. These rows and columns will be positioned anyplace in your spreadsheet.
Both instruments have related choices, however they carry completely different names. In different phrases, there isn’t a want to set up an add-on in Google Sheets or Microsoft Excel.
How to print selected cells in Excel
To print selected cells in Excel, observe these steps:
- Open the Excel spreadsheet and choose all cells.
- Press Ctrl+P to print.
- Select Print Selection from the checklist.
- Customize the sheet and print it.
You want to open and choose all of the cells that you really want to print, in case you are utilizing Microsoft Excel. After choosing, press the Ctrl+P shortcut to open the Print immediate. From right here, you want to develop the Print Active Sheets drop-down menu and select the Print Selection choice.
Now you may make different adjustments and print the spreadsheet.
How to print selected cells in Google Sheets
To print selected cells in Google Sheets, observe these steps:
- Open the spreadsheet in Google Sheets and use your mouse to choose all cells.
- Press the Print button.
- Choose Selected cells choice from the checklist.
- Customize different settings and print the spreadsheet.
You want to open the spreadsheet in Google Sheets to get began with this tutorial. After that, use your mouse to choose all of the cells that you really want to print. You can click on on a cell and drag your mouse to select all the pieces as per your wants.
After that, click on the Print button seen on the navigation bar. You ought to get the icon below the File/Edit choices. Alternatively, you’ll be able to go to the File menu and choose the Print choice. Also, you’ll be able to press Ctrl+P to do the identical.
Now you will discover some choices in your proper aspect. By default, the primary choice could be the Current sheet. You want to develop that drop-down checklist and choose the Selected cells choice.
Here you’ll be able to see the cell numbers as you selected earlier. After that, you’ll be able to customise all the pieces to print the spreadsheet accordingly.
That’s it! Hope it helps.