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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies