DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
move the worksheet as the last sheet
|
|
|
right-click a worksheet tab and then click Hide
|
|
|
double-click a worksheet tab
|
|
|
None of the above
|
Detailed explanation-1: -Right-click the sheet tab you want to hide, or any visible sheet if you want to unhide sheets. On the menu that appears, do one of the following: To hide the sheet, select Hide. To unhide hidden sheets, select them in the Unhide dialog that appears, and then select OK.
Detailed explanation-2: -In your Excel workbook, right-click any sheet tab and select Unhide… from the context menu. In the Unhide box, select the hidden sheet you want to display and click OK (or double-click the sheet name). Done!
Detailed explanation-3: -The Show sheet tabs setting is turned off. First ensure that the Show sheet tabs is enabled. To do this, For all other Excel versions, click File > Options > Advanced-in under Display options for this workbook-and then ensure that there is a check in the Show sheet tabs box.