We just need to select the sheets, Right-click on the Sheet tab, and press D from the keyboard. Delete Multiple Worksheets by Hybrid Keyboardĭeleting multiple worksheets in Excel by pressing the keyboard is one of the easiest and fastest ways. Now on the Sheet tab, Right-click on the mouse and select Delete.ģ.Select the cells we want to delete by pressing the Ctrl key.We can also delete the non-adjacent worksheets. Right-click your mouse button on the Sheet tab and select Delete.By pressing and holding the Shift key, select the first sheet and the last one with the mouse we want to delete.We need to follow the steps below to delete multiple worksheets that are adjacent. Use Sheet Option to Delete Multiple Sheets in Excel 2.1 For Adjacent Worksheet Then we can see that the selected sheets are deleted.Ģ.Now go to the Home tab and select Delete > Delete Sheet. Select the Sheets we want to delete by pressing and holding the Shift key.Use Ribbon Option to Delete Multiple Sheets in Excelįrom the Ribbon option, we can delete multiple sheets. You cannot delete selected non-adjacent cells in Google Sheets.4 Easy Ways to Delete Multiple Sheets in Excel 1. In the Menu, select Edit > Delete and then select the appropriate option (eg: Cells and shift up) You can then, as with Excel, either right- click on any selected cell, and then select the appropriate Delete cells option from the quick menu (eg Delete cells and shift up). You can select adjacent cells by clicking on the first cell you require, and dragging down or across to the last cell you wish to delete. How to Delete Multiple Cells in Google Sheetsĭeleting multiple adjacent cells in Google Sheets works much the same as it does in Excel. Select the appropiate acction and click OK. The Delete dialog box will once again appear. Right click on one of the selected cells, and then click Delete. Select the appropiate acction and click OK.Ĭlick in the first cell that you wish to delete and then, holding down the Control key, click on each additional cell that you wish to delete. In the Ribbon, select Home > Cells > Delete > Delete Cells.Ī Delete dialog box will appear asking you where you wish to move the remaining cells to, or if you want to actually delete the entire row or column that the selected cells are in. Right click on the selection, and then click Delete. This tutorial will demonstrate how to Delete Multiple Cells in Excel & Google Sheets.Ĭlick in the first cell that you wish to delete and then drag your mouse to the last cell you wish to delete.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |