DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
CTRL
|
|
SHIFT
|
|
ALT
|
|
None of the above
|
Detailed explanation-1: -Press and hold down the Ctrl key, and click the worksheet tabs you want to group. Tip: If you want to group consecutive worksheets, click the first worksheet tab in the range, press and hold the Shift key, and click the last worksheet tab in the range.
Detailed explanation-2: -2) To group non adjacent worksheets, select the first worksheet and then hold down the Ctrl key while you select the other worksheets.
Detailed explanation-3: -To group non-adjacent worksheets, first click the sheet tab of the first sheet to be in the group. Hold down the Control key, and then click the next sheet to be in the group. Keep the CTRL key down and continue to click on the sheets you wish to be in the group.
Detailed explanation-4: -When you hold the Control key down (Command on the Mac), and click another worksheet tab the active worksheet and clicked worksheet will be selected. You can select as many additional worksheets as you like.