Excel 2016 Introduction

Excel 2016

Lesson - Working with Columns and Rows

NOTE You can also delete rows by selecting the right-hand part of the Delete button in the Cells group on the Home tab, and then selecting the Delete Sheet Rows option. Excel will delete the selected rows. Formulas that refer to specific cells in a deleted row display the error message #REF! . The formula must be edited to remove the reference to cells in the deleted row.



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

Steps

Practice Data

1. Right-click the heading of the row you want to delete. A shortcut menu displays.

Right-click the row 7 heading

2. Select the Delete option in the shortcut menu. The row is deleted.

Click Delete

Click any cell to deselect the range. Close but do not save Q1RPT.XLSX .

OFFICEPRO, Inc.

Page 145