How to print selected sheets in an excel file?

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

I came across with this problem when I am going to print some sheets in Microsoft excel file. There are several sheets in that file. But I want to print only few selected sheets. How can I do this?

SHARE
Best Answer by Geisha Nitta
Best Answer
Best Answer
Answered By 0 points N/A #135085

How to print selected sheets in an excel file?

qa-featured

In Microsoft excel it is easily can be printed selected sheets in an excel file. I will explain you how should you do that using an example. I will take an excel file which include four pages. Please see the image below.

Print Ms Excel

Out of that sheets I assume that I want to print sheet 1 & 3.

First go to the Sheet 1, hold the “Ctrl” key and click on the sheet 3.

Now you can see the background of the sheet name of sheet 1 and 3 are whiter than the other sheet.

That means these sheets are selected. Now go to the print preview.

Now print preview only shows the sheet 1 & 3 only.

Print Preview

Therefore now you can print page 1 & 3 only.

Print Preview Zoom
Answered By 0 points N/A #135086

How to print selected sheets in an excel file?

qa-featured

Hello,



First, select one of the sheets you wanted to print, then press & hold down on "Ctrl" key, and then select the other sheets you wanted to print. After all the sheets you wanted to print are highlighted, then press print, it should print all the highlighted sheets at one go.



Otherwise, if you really want a checkbox / listbox menu, you can set that up, and then add the following line of code after the checkboxes are ticked (similar coding):

Answered By 0 points N/A #135087

How to print selected sheets in an excel file?

qa-featured

What you should do is to set the print area of the sheets that you want printed. To do that, follow these steps:

1. Highlight the area that you want to print.

2. Select “Page Layout” tab of your excel.

3. Look for the “Page Setup” area (actually depends on the version of excel, otherwise just click on the “File” tab then select “Page Setup”).

4. Then press the “set print area”.

After setting the print area of each of the sheets that you want to print, press CTRL+Left Click on the “Sheet” tabs. Then just press CTRL+P which should lead you to the print options. Then your good to go. Hope this helps.

Login/Register to Answer

Related Questions