Excel 2016 Introduction

Excel 2016

Lesson - Working with Columns and Rows

Steps

Practice Data

2. To select a range of adjacent columns or rows, select the desired column or row headings. The rows or columns are highlighted as you select them.

Select column headings B through D

3. Release the mouse button.

Release the mouse button

The rows or columns are selected.

4. To select a non-adjacent range of columns or rows, select the first column or row to be included in the range. The column or row is selected. 5. Hold [Ctrl] and select the additional columns or rows. The additional columns or rows are selected. 6. To select all the columns and rows in a worksheet, click the Select All button (located to the left of the first

Click the column A heading

Hold [Ctrl] and click the column E heading

Click

column and above the first row). All the columns and rows in the worksheet are selected.

Click any cell to deselect the range.

U SING N ARROW C OLUMN T OOLTIPS  D ISCUSSION

When a column is too narrow to display the full value of the data in it, pound signs (#####) appear instead. Excel provides tooltips for narrow columns. When you point to any cell containing pound signs due to a narrow column, a tooltip displays the formatted cell value.

Tooltip

OFFICEPRO, Inc.

Page 129