Range of worksheets for printing.

  • Thread starter Thread starter Don J
  • Start date Start date
D

Don J

How do I select and then deselect a range of worksheets for printing?
 
Click the tab of the first worksheet, hold the Shift key
down and click a second tab. All the worksheets between
those two endpoints (inclusive) have been selected--and
you can print them, print preview, etc. The selected
sheet tabs will appear slightly whiter than the non-
selected sheet tabs.

If you want particular sheets, then CTRL + click on each
of the sheet tabs.

To unselect the sheets, click on a different sheet tab
(not holding the Shift or CTRL key down). Or rightclick
one of the sheet tabs within your selection and select
Ungroup sheets from the resulting popup.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top