Excel 2016 Introduction

Lesson - Working with Columns and Rows

Excel 2016



P ROCEDURES 1. Right-click the column heading to the left of which you want to insert a column. 2. Select the Insert option on the shortcut menu.

3. Select the Insert Options button . 4. Select the desired formatting option.



S TEP - BY -S TEP Insert a column into a worksheet.

If necessary, scroll to view column H .

Steps

Practice Data

1. Right-click the column heading to the left of which you want to insert a column. A shortcut menu displays. 2. Select the Insert option on the shortcut menu. A column is inserted to the left of the selected column, and the Insert Options button displays. 3. Select the Insert Options button. A menu of available formatting options displays. 4. Select the desired formatting option. The Insert Options list closes, and the selected formatting is applied to the inserted column.

Right-click the column H heading

Click Insert

Click

Click Right

Format Same As

Type Commission in cell H1 . Type 345 in cell H2 . Notice that the new column H has adopted the formatting of column I .

Page 140

OFFICEPRO, Inc.