Excel 2016 Introduction

Lesson - Working with Columns and Rows

Excel 2016

NOTE Formulas that refer to specific cells in a deleted column display the error message #REF!. The formula must be edited to remove the reference to cells in the deleted column.



P ROCEDURES 1. Right-click the heading of the column you want to delete. 2. Select the Delete option in the shortcut menu.  S TEP - BY -S TEP Delete a column from a worksheet.

If necessary, scroll to view column H .

Steps

Practice Data

1. Right-click the heading of the column you want to delete. A shortcut menu displays. 2. Select t..he Delete option in the shortcut menu. The column is deleted.

Right-click the column H heading

Click Delete

Click any cell to deselect the range.

D ELETING A R OW  D ISCUSSION

You can delete unwanted rows from a worksheet. When you delete a row, the entire row and its contents are removed from column A through column IV. You should make sure that the row does not contain any data you want to keep. If you inadvertently delete a row, you can use the Undo button in the Quick Access Toolbar to undo the deletion.

When you delete a row, any formulas with ranges that include that row will adjust automatically. For example, if you delete row 5 , the SUM function =SUM(C2:C9) adjusts to =SUM(C2:C8) .

When deleting rows, you should first select the entire row. Otherwise, a message box opens, in which you must indicate exactly what you want to delete.

Page 144

OFFICEPRO, Inc.