Unable to print only selected cells in excel

Asked By 0 points N/A Posted on -
qa-featured

I am working in a company and recently I was assigned to verify parcels and logistics. I work in mail room. My job involves reading the cells in the Excel document and comparing that with all th mail room goods and if it matches, have to hand it over to concerned departments. I feel, it will be easy to take print out in hand and verify the contents. But I tried printing it but it printed full document which is several pages. I will be in need typically a few cells which can be printed in one sheet. Please show the way to print only selected cells in Excel. Or also any alternate methods to perform the task.

SHARE
Answered By 0 points N/A #193917

Unable to print only selected cells in excel

qa-featured

Solution 1:

1. As you want to print only selected cells you can do it in printer settings.

2. Click Ctrl+P after selecting the selection.

3. The print settings and preview page will be opened.

4. In MS 2010 excel there is Settings.

5. Under that go for “Print Selection”.

6. This will enable the option to print only selected area.

7. Now if you check the preview, the selected cell will be only visible.

8. Click Print

Related Questions