Delete buttons description of Cells group Microsoft Excel

Delete buttons description Cells group MS Excel

Delete buttons Cells group Home tab MS Excel

Delete buttons Cells group Microsoft Excel 2016

See Previous Post: Insert buttons tools Cells group Microsoft Excel 2016

Previously, in the post, we’ve discussed about on the Delete buttons. Now, we’ll next explain deep about the Delete buttons. Also, these buttons are part of the Cells group of the Home tab. And, the key role of these buttons, as the topic of this post says, is to delete. Whether, it is the Row or the Column or the Cells in worksheet.

Almost similarly like the Insert button, in sum, the Delete button has four buttons. So, they’re the Delete Cells and the Delete Sheet Rows buttons etc. Also, the rest are the Delete Sheet Columns and the Delete Sheet buttons. Significantly, already we know that, the buttons have their own Shortcut Keys.

Delete buttons of Cells group Excel 2016 – continued

Firstly, the Delete Cells button helps to delete new cells, rows, and the columns. And, these’re deleted from a table or in the worksheet. Above all, the selected Rows gets deleted by first selecting them. The Shortcut Key for this buttons is the “Ctrl+-” in MS Excel.

Secondly, the Delete Sheet Rows button deletes new rows from the sheet. Most noteworthy, to delete more than a single row at once, first the rows shall be selected. For example, if we need to delete two rows, then we must select two rows.

Thirdly, the Delete Sheet Columns buttons helps to delete new columns in the sheet. And, to delete multiple columns at once, more than one column should be selected. Especially, the “Ctrl+-” keys deletes the new Columns and the Rows.

Delete tools of Cells group Microsoft Excel 2016

Lastly, the Delete Sheet buttons deletes the currently selected sheet from the bottom. The sheet is deleted automatically from the sheet, that is already present in Microsoft Excel.

So, the Shortcut Key of this button is “Alt+H+D+S“. Most of all, the deleting of the Rows, the Columns or the Cells’re most frequently done; in comparison to the insertion of these, while working.

And, for deleting multiple sheets at once, hold and press the Shift key and then click the numbers sheets. By this way, more than single sheets’re selected and then deleted easily.

Also, using the Ctrl key helps users to select multiple sheets; from in between, by clicking individually on the sheets for deleting.

See Next Post: Multiple ways use Autosum buttons functions Microsoft Excel 2016

Tags:

About the Author

After working on Microsoft Excel for so many years, now its time to share & spread my Experience and Knowledge, which I have gained on Excel with the world. Myself, Piyush Kr. Pandey is an Excel enthusiast and founder of IndiaExcel.com (Learn Microsoft Excel), a website since 2016. Kindly, Subscribe our blog email newsletters for daily vital and essential informative posts on Microsoft Excel. Email: indiaexcelblog@gmail.com

Post a Reply

Your email address will not be published. Required fields are marked *

Top