DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Rows and columns can not be deleted
|
|
|
Right-click on the header and select Delete from the menu
|
|
|
Use the Format button on the Home tab
|
|
|
Right-click on the header and select Insert from the menu
|
Detailed explanation-1: -Shift+Spacebar to select the row. Ctrl+-(minus sign) to delete the row.
Detailed explanation-2: -Right-click in a table cell, row, or column you want to delete. On the menu, click Delete Cells. To delete one cell, choose Shift cells left or Shift cells up. To delete the row, click Delete entire row.
Detailed explanation-3: -Select the cells, rows, or columns that you want to delete. Right-click, and then select the appropriate delete option, for example, Delete Cells & Shift Up, Delete Cells & Shift Left, Delete Rows, or Delete Columns.
Detailed explanation-4: -Click a table cell in the column or row that you want to delete. On the Layout tab, in the Rows & Columns group, click Delete, and then click Delete Columns or Delete Rows.