DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Right click on the selected cells
|
|
|
Click the Page Layout tab
|
|
|
Press the Ctrl-Delete keys
|
|
|
Click the Data tab
|
Detailed explanation-1: -Right-click a sheet tab, and then click Select All Sheets on the shortcut menu. On the Home tab, click Format > under Visibility > Hide & Unhide > Hide Sheet.
Detailed explanation-2: -Go to the Home tab > Cells group, and click the Format button. Under Visibility, point to Hide & Unhide, and then select Hide Rows.
Detailed explanation-3: -On the Home tab, in the Cells group, click Format. Do one of the following: Under Visibility, click Hide & Unhide, and then click Unhide Rows or Unhide Columns.
Detailed explanation-4: -Select the column or any cell within the column(s) you want to hide. On the Home tab, in the Cells group, click Format > Hide & Unhide > Hide Columns.
Detailed explanation-5: -To hide the selected cells, press Ctrl + Shift + 8. To unhide the cells, press Ctrl + Shift + 8 again. If you want to quickly hide all cells that are selected, you can use the Hide command. To do this, select the cells you want to hide, then click the Home tab and click the Hide button.