DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
How do you delete an ENTIRE column or columns?
|
Select the column(s) header, select the drop-down arrow on the Delete command in the Cells group, and select Delete Sheet Columns
|
|
Select the column(s) and press Delete
|
|
Right-click on the worksheet name and select Delete
|
|
Select the column(s), go to the Data tab, Data tools group, and select Remove Duplicates
|
Explanation:
Detailed explanation-1: -Delete a row or column Select a row or column that you want to delete. Press Backspace, or select the Table Tools Layout tab >Delete, and then select an option. Note: In Excel, select a row or column that you want to delete, right-click and select Delete, and choose the option you want.
There is 1 question to complete.