How to print selected sheets in an excel file?

Asked By Jordon Troutman 20 points N/A Posted on - 08/01/2012

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?

• Status: Open
• Question Views: 1121
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Geisha Nitta

Go To Solution

Best Answer

Best Answer

Answered By Geisha Nitta 0 points N/A #135085

How to print selected sheets in an excel file?

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.

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.

Therefore now you can print page 1 & 3 only.

About Geisha Nitta

Questions
1

Answers
55

Best Answers
27

• Vote Up 0 Vote Down

• Posted on - 08/01/2012
• Question Category: MS Excel

Answered By lastday123 0 points N/A #135086

How to print selected sheets in an excel file?

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):

About lastday123

Questions
0

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 08/01/2012
• Question Category: MS Excel

Answered By Anthew Staw 0 points N/A #135087

How to print selected sheets in an excel file?

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.

About Anthew Staw

Questions
3

Answers
34

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 08/01/2012
• Question Category: MS Excel