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

HOW TO DELETE sheets, columns and rows IN EXCEL?

how to DELETE sheets in excel?

“SHEET” IS A SUB-GROUP OF ANY FILE. SHEETS ARE THE DIFFERENT WORKING AREAS BUT IN THE SAME FILE.

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

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

DELETE SHEETS EXCEL

steps TO DELETE SHEETS IN EXCEL?

STEPS:

  • Open the option under tab HOME>CELLS>DELETE.
  • CLICK Delete Sheet.
  • The selected sheet will be deleted.

 

steps TO delete cells IN EXCEL?

STEPS:

  • Open the option under tab HOME>CELLS>DELETE.
  • CLICK Delete Cells.
  • Following dialog box will be opened.
delete cells excel

STEPS:

  • 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.

 

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

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.

OTHER WAYS TO REACH THIS ARTICLE

  • how to delete sheets, how to delete rows, how to delete columns,how to delete cells, what happens when cells are deleted in excel, how to insert new workspace

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

gyankosh060309@gmail.com

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: