printing multiple (but not all) worksheets in a workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-2022899%22%20slang%3D%22en-US%22%3Eprinting%20multiple%20(but%20not%20all)%20worksheets%20in%20a%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2022899%22%20slang%3D%22en-US%22%3E%3CP%3E%3CEM%3EUsing%20MS%20365%20Excel%20I%20want%20to%20print%20selected%20worksheets%20from%20a%20workbook.%20Using%20the%20control%20key%20or%20shift%20key%20as%20I%20select%20the%20worksheet%20doesn't%20work.%20My%20mistake%20is%20%3F%3CBR%20%2F%3EThank%20you%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2022899%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2022921%22%20slang%3D%22en-US%22%3ERe%3A%20printing%20multiple%20(but%20not%20all)%20worksheets%20in%20a%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2022921%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F914435%22%20target%3D%22_blank%22%3E%40Howard1630%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20select%20few%20worksheets%20with%20Ctrl%20and%20Print%20Active%20Sheets%20in%20Print%20Preview%20it%20shall%20work%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2022944%22%20slang%3D%22en-US%22%3ERe%3A%20printing%20multiple%20(but%20not%20all)%20worksheets%20in%20a%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2022944%22%20slang%3D%22en-US%22%3E%3CP%3EEvery%20time%20I%26nbsp%3B%20hold%20down%20control%20or%20shift%20and%26nbsp%3B%20than%20select%20a%20sheet%20it%20lets%20go%20of%20the%20prior%20selected%20sheet.%20I%20can't%20select%20more%20than%20one%20sheet.%26nbsp%3B%20Any%20idea%20what%20I%20am%20doing%20wrong.%20This%20always%20worked%20with%20other%20versions%20of%20excel.%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Using MS 365 Excel I want to print selected worksheets from a workbook. Using the control key or shift key as I select the worksheet doesn't work. My mistake is ?
Thank you

4 Replies

@Howard1630 

If you select few worksheets with Ctrl and Print Active Sheets in Print Preview it shall work

Every time I  hold down control or shift and  than select a sheet it lets go of the prior selected sheet. I can't select more than one sheet.  Any idea what I am doing wrong. This always worked with other versions of excel.

Thank you.

@Sergei Baklan 

@Howard1630 

I'm not sure. You click on one sheet. Press and hold Ctrl, click on other sheet(s) tab - you selected all of them. It shall work.

@Sergei Baklan 

Doesn't happen. Can anyone help?

Thanks,  Howard