PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

HOW TO DELETE SHEETS , COLUMNS AND ROWS IN EXCEL?

HOW TO DELETE SHEETS IN EXCEL ?

“SHEET” IS A SUB-GROUP OF ANY WORKBOOK .

SHEETS ARE THE DIFFERENT WORKING AREAS BUT IN THE SAME WORKBOOK OR FILE.

SHEETS CAN BE USED TO CLASSIFY THE DATA OR KEEP THE GROUPS DIFFERENT.

IN THIS ARTICLE WE WOULD LEARN ABOUT DELETING SHEETS, COLUMNS AND ROWS.

BUTTON LOCATION FOR DELETION OF SHEETS, COLUMNS OR ROWS IN EXCEL

The buttons or options for the deletion of sheets, columns or rows is found under the HOME TAB under CELLS subsection as shown in thepicture below.

DELETE SHEETS EXCEL
SELECT THE DELETE OPTIONS UNDER HOME TAB AND CELLS SECTION

STEPS TO DELETE SHEETS IN EXCEL

DELETE SHEETS EXCEL
SELECT HOME TAB> CELLS > DELETE> DELETE SHEET

KEYBOARD SHORTCUT TO DELETE CURRENT SHEET

You can delete the current sheet by pressing ALT + H + D + S

STEPS TO DELETE CELLS IN EXCEL

Cells is the basic entity of a sheet.

If we specifically want to delete certain cells only, we can use this option.

STEPS:

  • Select the cells to be deleted.
  • Open the option under tab HOME>CELLS>DELETE.
  • CLICK Delete Cells.
  • Following dialog box will be opened.
DELETE SHEETS EXCEL
SELECT HOME TAB > CELLS SECTION >DELETE > DELETE CELLS
  • Following dialog box will be opened.
delete cells excel
  • Choose the action to be performed on rest of the cells when Selected Cells are deleted.
  • SHIFT CELLS LEFT: Delete the selected cells and shift rest of the cells to the left.
  • SHIFT CELLS UP: Delete the selected cells and shift rest of the cells upwards .
  • ENTIRE ROW: Delete the entire row of the selected cells.
  • ENTIRE COLUMN: Delete the entire column of the selected cells.

KEYBOARD SHORTCUT TO DELETE CELLS

Select the cells to be deleted.

You can delete the selected cells by pressing ALT + H + D + D

The dialog box shown above will follow and rest of the procedure is same.

STEPS TO DELETE COLUMNS IN EXCEL

Refer to the picture below.

STEPS:

  • SELECT the column to be deleted.
  • Go to HOME>CELLS>DELETE.
  • Click DELETE SHEET COLUMNS.
  • The Selected column will be deleted.
  • Rest of the columns to the right of the deleted column will  be shifted leftwards.
DELETE SHEETS EXCEL

KEYBOARD SHORTCUT TO DELETE SELECTED COLUMN

Select the column to be deleted.

You can delete the selected columns by pressing ALT + H + D + C

STEPS TO DELETE ROWS IN EXCEL

Refer to the picture below.

STEPS:

  • SELECT the row/rows to be deleted.
  • Go to HOME>CELLS>DELETE.
  • Click DELETE SHEET ROWS.
  • The Selected rows will be deleted.
  • Rest of the rows below the selected row/rows will be shifted upwards.
DELETE SHEETS EXCEL

KEYBOARD SHORTCUT TO DELETE SELECTED ROWS

Select the Rows to be deleted.

You can delete the selected rows by pressing ALT + H + D + R

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]

KINDLY SPEND FEW SECONDS HERE....

-We might be compensated for the visits or purchases you make by clicking the ads on this website .  They help us to keep bringing excellent quality articles for you.
-Click on the pictures if you can’t read. All of them are High Resolution .
-If you can’t find what you were looking for, kindly message in the chat box.
*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW