Which key do you press to group twoor more nonadjacent worksheets? - ProProfs Discuss
Topics-
Products +
     

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

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

Change Image    Delete



A. CTRL.
B. SHIFT
C. ALT

This question is part of MICROSOFT EXCEL EXAM
Asked by Wyatt Williams, Last updated: Jul 30, 2018

+ AnswerRequest Answer
...

6 Answers

smlambo.nwu

Smlambo.nwu

Answered on Mar 30, 2017

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

lalauni.baker

Lalauni.baker

Answered on 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.
 Reply

annadavis

Annadavis

Answered on Feb 16, 2017

The answer is CTRL.
 Reply

jdjack

Jdjack

Answered on 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.
 Reply

mmb

Mmb

Completely agree. Shift could be correct sometimes (when you want all the in between worksheets selected as well) but control will always be correct.

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

John Smith

John Smith

Answered on Oct 24, 2016

Shift
 Reply

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

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