Excel 2013 & 2016: Editing a worksheet

Updated 2013.08.07

Objectives:

·        Learn how to edit a cell.

·        Learn how to insert new rows and columns.

·        Learn how to delete existing rows and columns.

·        Learn how to insert/delete a range of cells.

·        Learn how to recognize and correct circular references.

Editing

To get this result:

Do this:

Replace the contents of a cell

Select (click on) the cell and type the new data on top of it.

If you change your mind before you press the Enter key, press Escape.

Edit a cell

Either:

·       Double-click on the cell

Or:

·       Select (click on) the cell and press F2

Delete cells

Select the cells, then press the Delete key on the keyboard.

Insert rows

Select the row(s) where you want the new row(s) to appear, then either
(1):

·       Right-click on the selected row(s) and from the popup menu, click on Insert.

Or (2):

·       Click on the Home tab.

·       Click on Insert.

·       Click on Insert Sheet Rows.

https://p3plcpnl0895.prod.phx3.secureserver.net:2078/public_html/Excel/2013/002-Editing_files/image001.jpg

The selected rows will be pushed down.

Insert columns

Select the column(s) where you want the new column(s) to appear, then either
(1):

·       Right-click on the selected column(s) and from the popup menu, click on Insert.

Or (2):

·       Click on the Home tab.

·       Click on Insert.

·       Click on Insert Sheet Columns.

https://p3plcpnl0895.prod.phx3.secureserver.net:2078/public_html/Excel/2013/002-Editing_files/image002.jpg

The selected columns will be pushed to the right.

Delete entire rows

Select the row(s) you want to delete, then either
(1):

·       Right-click on the selected rows and from the popup menu, click on Delete.

Or (2):

·       Click on the Home tab.

·       Click on Delete.

·       Click on Delete Sheet Rows

https://p3plcpnl0895.prod.phx3.secureserver.net:2078/public_html/Excel/2013/002-Editing_files/image003.jpg

Delete entire columns

Select the column(s) you want to delete then either
(1):

·       Right-click on the selected columns and from the popup menu, choose Delete.

Or (2):

·       Click on the Home tab.

·       Click on Delete.

·       Click on Delete Sheet Columns

https://p3plcpnl0895.prod.phx3.secureserver.net:2078/public_html/Excel/2013/002-Editing_files/image004.jpg

Insert a range of cells

Select the range where you want the cells to be inserted. Then either
(1):

  • Right-click on the selected cells and from the popup menu, click on Insert.
  • Click on either Shift Cells Right or Shift Cells Down.

Or (2):

  • Click on the Home tab.
  • Click on Insert.
  • Click on Cells.

https://p3plcpnl0895.prod.phx3.secureserver.net:2078/public_html/Excel/2013/002-Editing_files/image005.jpg

  • Click on either Shift Cells Right or Shift Cells Down.

Delete a range of cells:

Select the range of cells you want to be deleted. Then either (1):

  • Right-click on the selected cells and from the popup menu, click on Delete.
  • Click on either Shift Cells Left or Shift Cells Up.

Or (2):

·       Click on the Home tab.

·       Click on Delete.

·       Click on Cells.

https://p3plcpnl0895.prod.phx3.secureserver.net:2078/public_html/Excel/2013/002-Editing_files/image006.jpg

·       Click on either Shift Cells Left or Shift Cells Up.

Check spelling

·       Click on the Review tab.

·       Click on Spelling.

https://p3plcpnl0895.prod.phx3.secureserver.net:2078/public_html/Excel/2013/002-Editing_files/image007.jpg

Search and replace text

Either:

(1)

·       Type <ctrl>+H

Or (2):

·       Click on the Home tab.

·       Click on Find & Select

·       Click on Replace.

https://p3plcpnl0895.prod.phx3.secureserver.net:2078/public_html/Excel/2013/002-Editing_files/image008.jpg

Circular References

Occasionally, you may create a circular reference when writing a formula in a cell. A circular reference is a formula that refers to itself. For example, if you put the formula =A1+1 in the cell A1, you would have a circular reference. This is generally a bad thing. Whenever this happens, the word "Circular" appears on the status bar of the worksheet followed by the cell that contains the circular reference. Go to this cell and correct your formula.