Excel 2016 Introduction

Excel 2016

Lesson - Working with Columns and Rows

When you insert a column, any formulas with ranges that include cells on both sides of the new column expand automatically to include the new column. For example, if you insert a new column between columns B and C , the SUM function =SUM(B2:F2) adjusts to =SUM(B2:G2) .

Columns are inserted to the left of the currently selected column. By selecting an entire column before you insert a new one, Excel automatically moves the selected column to the right and inserts a new, blank one. If you select multiple columns, Excel inserts the same number of columns into the worksheet.

Once you have inserted one or more columns, the Insert Options button appears to the right of the top cell in the new column(s). Clicking the Insert Options button displays a list of available formatting options. You can choose to format the newly inserted column the same as either the column to the left or the column to the right, or you can clear all formatting.

Formatting a newly inserted column

NOTE By default, the cells in an inserted column adopt the formatting of the cells in the column directly to the left. You can also insert columns by selecting the right-hand part of the Insert button in the Cells group on the Home tab, and then selecting the Insert Sheet Columns option. Excel will insert the same number of columns as are selected.

OFFICEPRO, Inc.

Page 139