Printing certain sheets in a workbook.

Hi,

I have a report in which it's based on a database. The report consists of 30 sheets, and I only want to print the first 25 (the other 5 are a database). Now I understand i can print between pages, but the number of pages (not sheets) changes due to the amount of info on sheets. How can I, without searching for the end of the report, print the first 25 tabs without printing the entire 30?

Thanks,

Bailey100

excel

Formulas and Functions

Bailey100
Aug 19, 2019
Bailey100 I have answered this myself. I can use the shift button to select the first and last sheet i want and the print active sheets.

3 Replies

SergeiBaklan
Diamond Contributor
Aug 19, 2019
Bailey100

As variant you may select your first 25 sheets (click on first sheet, Shift, click on 25th sheet) and print
Bailey100
Brass Contributor
Aug 19, 2019
Bailey100 I have answered this myself. I can use the shift button to select the first and last sheet i want and the print active sheets.
- SergeiBaklan
  Diamond Contributor
  Aug 19, 2019
  Bailey100 , good, I'm bit late with the answer

Forum Discussion

Printing certain sheets in a workbook.