Which key do you press to group two or more nonadjacent worksheets? - ProProfs Discuss
Cancel
TopicsDown
Products Down
Follow Us:
FacebookTwitter
Advertisement

Which key do you press to group two or more nonadjacent worksheets?

Which key do you press to group two or more nonadjacent worksheets?<br/>

Change Image    Delete

This question is part of MICROSOFT EXCEL EXAM
Asked by Wyatt Williams, Last updated: Sep 18, 2020

+ Answer
Request
Question menu
Vote up Vote down

6 Answers

smlambo.nwu

smlambo.nwu

smlambo.nwu
Smlambo.nwu

Answered Mar 30, 2017

I agree, "Shift" isn't the answer. Shift is for "Adjacent" cells OR worksheets
upvote downvote
Reply 

lalauni.baker

lalauni.baker

lalauni.baker
Lalauni.baker

Answered Mar 08, 2017

I am with the majority here. The key word is "Non Adjacent" If I want to group every other cell, then I would use Ctrl. If I want to group "adjacent cells", then I will use shift.
upvote downvote
Reply 

annadavis0728

annadavis

annadavis0728
Annadavis

Answered Feb 16, 2017

The answer is CTRL.
upvote downvote
Reply 

jdjack423

jdjack

jdjack423
Jdjack

Answered Dec 05, 2016

The answer here is misleading. If you have two worksheets that are non adjacent and wanted to group just those two, you would use ctrl, not shift. If you use shift, you will grab all the worksheets between the two you wanted to group. This answer is not correct.
upvote downvote
Reply 

John Adney

John Adney

John Adney
This is incorrect. The correct answer is CTRL. The key word here is "nonadjacent".
SHIFT will group all worksheets between the two that are selected. SHIFT will NOT select nonadjacent worksheets. Holding CTRL while selecting two or more nonadjacent worksheets will group only those that are selected (ie non-adjacent), rather than all worksheets between the selections.
upvote downvote
Reply 

John Smith

John Smith

John Smith
John Smith

Answered Oct 24, 2016

Shift
upvote downvote
Reply 

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

Email Sent
We have sent an email to your address "" with instructions to reset your password.