DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
to delete a cell
|
|
|
to delete a column
|
|
|
to delete a row
|
|
|
to delete a sheet
|
Detailed explanation-1: -Ctrl + Shift + Delete-This shortcut will delete the selected cells, column, or row and shift the remaining cells down or right. Alt + Delete-This shortcut will delete the selected cells, column, or row and all cells to the left or above.
Detailed explanation-2: -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-3: -Delete a Column in Excel and Google Sheets If we want to delete a column in Excel we have to select the column by clicking on the column header and to do the right mouse click and choose the Delete option in the drop-down list.
Detailed explanation-4: -Columns in an Excel worksheet are ALWAYS named A, B, C, … It doesn’t matter if you insert or delete columns. Afterwards, the columns will still be A, B, C, … The column letters are just a way to refer to columns; they don’t have an intrinsic meaning.