
Insert or delete rows and columns - Microsoft Support
Select the cells, rows, or columns that you want to delete. Right-click, and then select the appropriate delete option, for example, Shift cells up, Shift cells left, Entire row, or Entire column.
Find and remove duplicates - Microsoft Support
Select Data > Remove Duplicates, and then under Columns, check or uncheck the columns where you want to remove the duplicates. For example, in this worksheet, the January column …
Video: Add and delete table rows and columns - Microsoft Support
Note: In Excel, select a row or column that you want to delete, right-click and select Delete , and choose the option you want. Or select a cell, and then select Home > Insert or Home > Delete, …
Delete a row, column, or cell from a table - Microsoft Support
Use the right-click menus to delete cells, columns, or rows in a document table.
Remove columns (Power Query) - Microsoft Support
To remove a single column, select the column you want to remove, and then select Home > Remove Columns > Remove Columns. To remove several columns, select the columns by …
Filter for or remove duplicate values - Microsoft Support
Select one or more of the check boxes, which refer to columns in the table, and then click Remove Duplicates. Tip: If the range of cells or table contains many columns and you want to …
Resize a table by adding or removing rows and columns in Excel
You can also right-click one or more rows or columns, hover over Delete on the shortcut menu, and then select Table Columns or Table Rows. Or you can right-click one or more cells in a …
Clear or remove a filter - Microsoft Support
Click the Filter button next to the column heading, and then click Clear Filter from <"Column Name">. For example, the figure below depicts an example of clearing the filter from the …
Filter for unique values or remove duplicate values
If the range of cells or table contains many columns and you want to only select a few columns, you may find it easier to select Unselect All, and then under Columns, select those columns. …
Lock or unlock specific areas of a protected worksheet
To delete an editable range, select it in the Ranges unlocked by a password when sheet is protected box, and then select Delete. In the Title box, type the name for the range that you …