SOLVED
Home

Printing certain sheets in a workbook.

%3CLINGO-SUB%20id%3D%22lingo-sub-810547%22%20slang%3D%22en-US%22%3EPrinting%20certain%20sheets%20in%20a%20workbook.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-810547%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20report%20in%20which%20it's%20based%20on%20a%20database.%20The%20report%20consists%20of%2030%20sheets%2C%20and%20I%20only%20want%20to%20print%20the%20first%2025%20(the%20other%205%20are%20a%20database).%20Now%20I%20understand%20i%20can%20print%20between%20pages%2C%20but%20the%20number%20of%20pages%20(not%20sheets)%20changes%20due%20to%20the%20amount%20of%20info%20on%20sheets.%20How%20can%20I%2C%20without%20searching%20for%20the%20end%20of%20the%20report%2C%20print%20the%20first%2025%20tabs%20without%20printing%20the%20entire%2030%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBailey100%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-810547%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-810575%22%20slang%3D%22en-US%22%3ERe%3A%20Printing%20certain%20sheets%20in%20a%20workbook.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-810575%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F351100%22%20target%3D%22_blank%22%3E%40Bailey100%3C%2FA%3E%26nbsp%3BI%20have%20answered%20this%20myself.%20I%20can%20use%20the%20shift%20button%20to%20select%20the%20first%20and%20last%20sheet%20i%20want%20and%20the%20print%20active%20sheets.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-810577%22%20slang%3D%22en-US%22%3ERe%3A%20Printing%20certain%20sheets%20in%20a%20workbook.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-810577%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F351100%22%20target%3D%22_blank%22%3E%40Bailey100%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20variant%20you%20may%20select%20your%20first%2025%20sheets%20(click%20on%20first%20sheet%2C%20Shift%2C%20click%20on%2025th%20sheet)%20and%20print%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-810578%22%20slang%3D%22en-US%22%3ERe%3A%20Printing%20certain%20sheets%20in%20a%20workbook.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-810578%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F351100%22%20target%3D%22_blank%22%3E%40Bailey100%3C%2FA%3E%26nbsp%3B%2C%20good%2C%20I'm%20bit%20late%20with%20the%20answer%3C%2FP%3E%3C%2FLINGO-BODY%3E
Bailey100
Contributor

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

3 Replies
Solution

@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.

@Bailey100 

As variant you may select your first 25 sheets (click on first sheet, Shift, click on 25th sheet) and print

@Bailey100 , good, I'm bit late with the answer

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
12 Replies