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

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: Jan 20, 2020

+ Answer
Request

6 Answers

smlambo.nwu

Smlambo.nwu

Answered Mar 30, 2017

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

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.
 

annadavis

Annadavis

Answered Feb 16, 2017

The answer is CTRL.
 

jdjack

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

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.
 

John Smith

John Smith

Answered Oct 24, 2016

Shift
 

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.