DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Delete
|
|
|
Select all sheet
|
|
|
Paste
|
|
|
Move or copy
|
Detailed explanation-1: -Open the Move or Copy dialog box either by right-clicking the sheet tab and selecting Move or Copy from the context menu or by clicking Home tab > Format > Move or Copy Sheet.
Detailed explanation-2: -Right click on the worksheet tab and select Move or Copy. Select the Create a copy checkbox. Under Before sheet, select where you want to place the copy. Select OK.
Detailed explanation-3: -Right-click the sheet tab, click Rename, and type the new name. Use the keyboard shortcut Alt+H > O > R, and type the new name.
Detailed explanation-4: -Press SCROLL LOCK, and then hold down CTRL while you press the LEFT ARROW or RIGHT ARROW key. Press SCROLL LOCK, and then simultaneously hold down CTRL and an arrow key to quickly move through large areas of your worksheet.