DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
On the View tab, in the Show group, click the Tabs button and select the tab you want to display.
|
|
|
Right-click any tab on the ribbon and select Display Hidden Tabs
|
|
|
On the Home tab, in the Cells group, click Insert and then select Show Hidden Tabs
|
|
|
Display the Excel Options dialog box, select Customize Ribbon, and then select the check box next to the name of the tab you want to add.
|
Detailed explanation-1: -Tip: Press Ctrl+F1 to show and hide your commands in the Ribbon. Click Show Tabs to display the Ribbon tabs without the commands. To access the commands in the Show Tabs option, click any of the tabs. Click Auto-hide Ribbon to hide all tabs and commands.
Detailed explanation-2: -The Excel ribbon tabs. There are nine tabs on the Excel Ribbon: File, Home, Insert, Page Layout, Formulas, Data, Review, View, and Help. The Home tab is the default tab when Excel is opened. Now let’s go through each tab, from left to right, to understand each of their features.
Detailed explanation-3: -The fastest way to detect hidden sheets in Excel is this: right-click any sheet tab and see if the Hide… command is enabled or not. If it is enabled, click it and see which sheets are hidden. If it is disabled (greyed out), the workbook does not contain hidden sheets.
Detailed explanation-4: -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.