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.
STEPS TO DELETE SHEETS IN EXCEL
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.
- Following dialog box will be opened.
- 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
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.
KEYBOARD SHORTCUT TO DELETE SELECTED COLUMN
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.
KEYBOARD SHORTCUT TO DELETE SELECTED ROWS
You can delete the selected rows by pressing ALT + H + D + R
YOU MAY LIKE
- HOW TO TROUBLESHOOT A FORMULA IN EXCEL?
- USE OF FONTS, FONT SIZE, INDENTATION, TEXT TO THE RIGHT, TEXT TO THE LEFT, TEXT IN THE MIDDLE ETC.
- how to insert table in excel?
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.