USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
copy
|
|
hide
|
|
unhide
|
|
move
|
Detailed explanation-1: -You can move a sheet to a different position, click and hold the sheet tab at the bottom of the screen with the mouse and drag it to its new position. select Edit → Sheet → Move/Copy from the main menu. Specify the new position of the sheet in the dialog.
Detailed explanation-2: -Use the keyboard shortcut CTRL + TAB This keyboard shortcut works similarly to the previous two, but it has the added benefit of allowing you to move between sheets in both directions. Simply press CTRL + TAB to move to the next sheet, or CTRL + SHIFT + TAB to move to the previous sheet.
Detailed explanation-3: -You can move worksheets with the keyboard by using Ctrl+PgUp and Ctrl+PgDown. Ctrl+PgUp moves toward the first worksheet in the workbook and Ctrl+PgDown moves toward the last.
Detailed explanation-4: -You can also use the “Ctrl+PgUp” and “Ctrl+PgDn” keyboard shortcuts to move between tabs. These shortcuts will move you to the previous or next tab, respectively.
Detailed explanation-5: -Press Ctrl+Page Down to move to the next worksheet. For example, if you’re currently in Sheet1, this key sequence jumps you to Sheet2.