Excel 2016 Introduction

Excel 2016

Lesson - Working with Columns and Rows

Type District Sales Report in cell A1 and press [Enter] . Notice that the inserted row adopts the default worksheet formatting, since the option to clear all formatting was selected from the Insert Options list.

Practice the Concept: Insert a row above row 7 . Clear the formatting. Click any cell to deselect the range.

D ELETING A C OLUMN  D ISCUSSION

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

When you delete a column, any formulas with ranges that include the deleted column adjust automatically. For example, if you delete column C , the SUM function =SUM(B2:G2) adjusts to =SUM(B2:F2) .

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

Delete a column

OFFICEPRO, Inc.

Page 143