Learn how to delete row and column in excel
You can use keyboard shortcut keys to delete rows or columns in Excel, or even delete them with the mouse.
To delete a row, select the row you want to delete in Excel. Right-click on the row with the numbers on the left side of the seat and click on Delete Row. Row will be given.
30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details
Similarly, to delete a column, select the column name (eg A, B, C, D). And right click with the mouse and click on delete option.
Let us now see how to delete rows and columns in excel using shortcut keys.
Use the shortcut key Shift + Space to select the entire row of selected cells. And use the shortcut CTRL + minus sign (-) to Delete the selected row. All selected rows will be deleted immediately.
Similarly, use the shortcut CTRL + Space to select the entire column of the selected cell. Ctrl + minus sign (-) is also used to delete the selected column.