Shortcut Keys for Deleting Cells in Excel If you have several cells to delete, it can be faster to use keyboard shortcuts instead of the mouse. The most common keyboard shortcut is “CTRL” + “–” (minus sign), which deletes the selected cells and shifts the contents of the cells ...
In Microsoft Excel, we can find the delete cells on the home menu, shown in the screenshot below. Once you click on the delete cells, we will get the following options: Delete cells: You can use this to delete the selected cells. Delete Sheet Rows: You can use this to delete the se...
Ctrl + – deletes whole rows that the selected cell is in. Rows are also deleted if you select more than one cell in a row (obviously). But selecting cells down a column is different. Select two or more cells in a column If you select two or more cells in a column, Ctrl + – ...
If you always search for a solution to automate this or that Excel routine, grab the macros below to streamline your delete-rows task. In this part you'll find 2 VBA macros that will help you remove rows with the selected cells or delete every other row in Excel. The macroRemoveRowsWith...
This will remove the contents of the selected cells without affecting the structure of your worksheet. The Shortcut Method for Deleting Blank Cells in Excel If you want to delete only the blank cells in your Excel worksheet and keep the rest of the data intact, there’s a quick shortcut ...
Shortcut: PressCtrl + G>Go Todialog box will open > PressSpecial. Select theBlanksradio button > PressOK. The following image shows that the blank rows along with the blank cells are selected. To delete the selected rows. PressCtrl + –. ...
Select Blanks in the Go To Special dialog box and press OK. You will get all the blank cells selected. From the Home tab, go to the Cells group, select the Delete segment and choose Delete Sheet Columns. Note: If a column has at least one blank value, it will be deleted regardless ...
First,select the cellsyou want to delete, thenright-click. In the drop-down menu, chooseDelete…(or use theCTRL + –shortcut). TheDelete dialog windowopens. Click onShift cells up, and thenOK. As a result, the selected cells are deleted and the cell from below is shifted up. ...
Shift Cells Left − Moves the selected cells to the left and delete a cell from the active cell. Shift Cells UP − Moves the selected cells upwards and deletes a selected cell. Entire Row − You may delete an entire row by clicking on this option to delete all the data from that...
(or use the CTRL + – shortcut). After that, the Delete dialog window appears. Choose Shift cells left and click OK. As a result, the selected cells are deleted, and the cells from the right side are shifted to the left. Note: When you delete an entire column, Excel automatically sh...