Excel 2016 Introduction

Lesson - Working with Columns and Rows

Excel 2016

NOTE When you are selecting the columns or rows you want to hide, make sure that the mouse pointer is a single, black arrow rather than the black, double-headed arrow used to adjust column width and row height. You can also hide a column or row by dragging the line to the right of a column heading or below a row heading until the column or row is sized to 0.00 .



P ROCEDURES 1. Drag to select the columns or rows you want to hide. 2. Release the mouse button. 3. Right-click any one of the selected columns or rows. 4. Select the Hide option on the shortcut menu.  S TEP - BY -S TEP Hide columns and rows in a worksheet.

Steps

Practice Data

1. Select the columns or rows you want to hide. The columns or rows are highlighted as you select them.

Select rows 2 through 5

2. Release the mouse button.

Release the mouse button

The columns or rows are selected.

3. Right-click any one of the selected columns or rows. A shortcut menu displays. 4. Select the Hide option on the shortcut menu. The columns or rows are hidden, and a wide, black line indicates their location.

Right-click anywhere in the selected rows

Click Hide

Practice the Concept: Hide columns B through D .

Page 136

OFFICEPRO, Inc.