Editing a Cell:

Editing a cell means changing the data or formula inside it.


Steps to edit a cell include: -

  1. Double-click on the cell you want to edit. The cell becomes active, and the cursor appears inside.
  2. Make your changes.
  3. Press Enter to confirm or Esc to cancel.


Alternatively,

  1. Click once on the cell to select it.
  2. Click in the Formula Bar (above the worksheet, next to the Name Box).
  3. Edit the content.
  4. Press Enter to save the changes.


Selecting a Range:

Steps to select a range include: -

  1. Click the first cell you want to select in the cell range and hold the mouse button.
  2. Drag to select multiple cells. As you drag, the selected cells are highlighted.
  3. Release the mouse button.

The cell range is selected.


Alternatively,

Select the first cell of the cell range. Press and hold the <Shift> key and select the last cell of the cell range.


Deleting Cells, Rows, and Columns:


Steps to delete cells include: -

1. Select the cell(s) you want to delete.


2. Click the Home tab on the Ribbon and click the Delete list arrow in the Cells group. Select Delete Cells.

The Delete dialog box appears. Here you can tell Excel how you want to move the remaining cells to cover the hole left by the deleted cell(s) by selecting “Shift cells left” or “Shift cells up.”

You can also select Entire row or Entire column in the Delete dialog box to delete an entire row or column.


3. Select an option and click OK.


The cell(s) are deleted and the remaining cells are shifted.


Alternatively,

Right-Click the selected cells and press delete. Choose from the following options and select OK.


Steps to delete rows or columns include: -

  1. Select the row or column heading(s) you want to delete.
  2. Click the Home tab on the Ribbon and click the Delete button in the Cells group. The rows or columns are deleted. Remaining rows are shifted up, while remaining columns are shifted to the left.


Alternatively,

Select the column or row heading(s) you want to delete, right-click any of them, and select Delete from the contextual menu. Or, click the Delete list arrow and select Delete Sheet Rows or Delete Sheet Columns. The row or column of the active cell is deleted.


Deleting Worksheet:

Steps to delete a worksheet include: -


  1. Right-click the sheet tab you want to delete and select Delete from the contextual menu. A dialog box appears, asking you to confirm the deletion.
  2. Click Yes.

The worksheet is deleted.


Alternatively,

Select the worksheet you want to delete, click the Home tab on the Ribbon, click the Delete list arrow in the Cells group and select Delete Sheet.


Renaming, Moving and Copying Worksheets:

You can manipulate your workbooks by renaming worksheets and moving them into different orders and even into different workbooks.


Steps to rename a worksheet include: -

  1. Double-click the sheet tab. The sheet name is selected so that it can be renamed.
  2. Type a new name for the worksheet.
  3. Press <Enter>.

The sheet is renamed.


Alternatively,

Right-click the sheet tab, select Rename from the contextual menu, and type a new name. Or, select the worksheet you want to rename, click the Home tab on the Ribbon, click the Format button in the Cells group and select Rename Sheet. Type a new name.


Steps to move or copy a worksheet include: -

  1. Select the sheet tab(s) for the worksheet(s) you want to move or copy.
  2. Right-click one of the sheet tabs you want to move or copy and select Move or Copy from the contextual menu. The Move or Copy dialog box appears.
  3. Select the sheet after which you want your moved or copied sheet(s) to appear in the Before Sheet list. The moved or copied sheet will be placed in front of the sheet that is selected.
  4. (Optional Step) Click the Create a copy check box to copy the selected sheet. If this box is check marked, the worksheet(s) will be copied to the new location, instead of simply being moved.
  5. Click OK.

The worksheet(s) are moved or copied to the new location.


Alternatively,

  1. Select the sheet(s) you want to move or copy.
  2. Click the Home tab on the Ribbon and click the Format button in the Cells group.
  3. Select Move or Copy Sheet from the list.
  4. Select the sheet after which you want your moved or copied sheet(s) to appear in the Before Sheet list. The moved or copied sheet will be placed in front of the sheet that is selected.
  5. (Optional Step) Click the Create a copy check box to copy the selected sheet. If this box is check marked, the worksheet(s) will be copied to the new location, instead of simply being moved.
  6. Click OK.

The worksheet(s) are moved or copied to the new location.


Protecting a Workbook:

Steps to protect a workbook include: -


  1. Go to the File tab
  2. Select Info, then click Protect Workbook.
  3. Choose an option like,
  4. Encrypt with Password to require a password to open the file, or
  5. Protect Workbook Structure on the Review tab to prevent changes to the workbook's structure like adding or deleting sheets. 
  6. Enter a strong password if you choose option 1 and for option 2, password is optional.
  7. Click OK.
  8. Save Workbook.


Your workbook is protected now.