USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Ctrl Alt Tab
|
|
|
Alt Tab
|
|
|
Ctrl Tab
|
|
|
Shift Tab
|
Detailed explanation-1: -CTRL+TAB or CTRL+PAGE DOWN Switch to the next tab in a dialog box. CTRL+SHIFT+TAB or CTRL+PAGE UP Switch to the previous tab in a dialog box. Arrow keys Move between options in an open drop-down list, or between options in a group of options.
Detailed explanation-2: -To move to the next selected cell, press TAB or ENTER. To move to the previous selected cell, press SHIFT + TAB or SHIFT + ENTER.
Detailed explanation-3: -Move to the next or previous cell To move to the next cell in a row, press Tab. To move to the previous cell in a row, press Shift + Tab. You can also use the arrow keys to move to cells.
Detailed explanation-4: -Ctrl + Page Up/Page Down: This shortcut will take you to the previous or next tab in your workbook. If you’re on the first tab and you press Ctrl + Page Up, you’ll be taken to the last tab. Similarly, if you’re on the last tab and you press Ctrl + Page Down, you’ll be taken to the first tab.
Detailed explanation-5: -CTRL + Page Up: Move to the previous sheet in a workbook. Keep pressing this key combination to move across excel sheets till the first sheet.