Excel 2016 Introduction

Excel 2016

Lesson - Working with Columns and Rows

I NSERT A R OW  D ISCUSSION

You can insert rows into an existing worksheet to add new information or to create logical divisions of worksheet data. Since rows are inserted from column A to column IV, you should verify that inserting a new row will not adversely affect any data to the left or right of the current data. For example, you may have data in A1:G10 and P1:T10 . If you insert a row between rows 5 and 6 , a blank row is inserted not only between the data in A1:G10 , but also between the data in P1:T10 .

When you insert a row, any formulas with ranges that include cells both above and below the inserted row expand automatically to include the new row. For example, if you insert a new row between rows 4 and 5 , the SUM function =SUM(C3:C8) adjusts to =SUM(C3:C9) .

Rows are inserted above the currently selected row. By selecting an entire row before you insert a new one, Excel automatically moves the selected row down and inserts a new, blank one. If you select multiple rows, Excel inserts the same number of rows into the worksheet. Once you have inserted one or more rows, the Insert Options button appears below the first cell of the inserted row(s). Clicking the Insert Options button displays a list of available formatting options. You can choose to format the newly inserted row the same as either the row above or the row below, or you can clear all formatting.

Formatting a newly inserted row

OFFICEPRO, Inc.

Page 141