![]() If we want to delete the non-contiguous rows, then continuously press the Ctrl Key and click the row number only by one. ![]() If we want to delete the sequential rows, then press the Shift+Down arrow (⬇) or Shift+Up arrow (⬆). ⇒ WAY 2: Alternatively, select a row by clicking the row number (mouse pointer changes to a thick right arrow). ⇒ WAY 1: Click in any cell within the row we want to delete, then press Shift+Spacebarwhich will select the entire row. We can delete rows in excel either in 04 methods.īut before deleting rows, we should select a single row any of the following 02 ways: ➢ METHOD 4: DELETE CELLS IN EXCEL USING THE RIBBON.➢ METHOD 3: DELETE CELLS IN EXCEL USING THE MOUSE RIGHT-CLICK. ![]() ➢ METHOD 2: EXCEL DELETE CELLS SHORTCUT ALT+H+D+D.➢ METHOD 1: EXCEL DELETE CELLS SHORTCUT CTRL+ – (MINUS).➢ METHOD 4: DELETE COLUMNS IN EXCEL USING THE RIBBON.➢ METHOD 3: DELETE COLUMNS IN EXCEL USING THE MOUSE RIGHT-CLICK. ![]() ➢ METHOD 2: EXCEL DELETE COLUMN SHORTCUT ALT+H+D+D.➢ METHOD 1: EXCEL DELETE COLUMN SHORTCUT CTRL+ – (MINUS).➢ METHOD 4: EXCEL DELETE ROWS BY USING THE RIBBON.➢ METHOD 3: EXCEL DELETE ROWS BY USING THE MOUSE RIGHT-CLICK.➢ METHOD 2: EXCEL DELETE ROW SHORTCUT ALT+H+D+D.➢ METHOD 1: EXCEL DELETE ROW SHORTCUT CTRL+ – (MINUS).
0 Comments
Leave a Reply. |