Excel 2016 Introduction

Lesson - Working with Columns and Rows

Excel 2016



P ROCEDURES 1. Drag to select a column or row on each side of the hidden columns or rows, so that the hidden columns or rows are included in the selection. 2. Release the mouse button.

3. Right-click any one of the selected columns or rows. 4. Select the Unhide option in the shortcut menu.



S TEP - BY -S TEP Unhide columns and rows in a worksheet.

Steps

Practice Data

1. Select a column or row on each side of the hidden columns or rows, so that the hidden columns or rows are included in the selection. The columns or rows are highlighted as you select them.

Select rows 1 and 6

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 Unhide option in the shortcut menu. The previously hidden columns or rows now display in the worksheet.

Right-click anywhere in the selected rows

Click Unhide

Practice the Concept: Unhide columns B through D . Then click any cell to deselect the range.

I NSERTING A C OLUMN  D ISCUSSION

You can insert columns into an existing worksheet to add new information or to create logical divisions in the worksheet data. Since columns are inserted from row 1 to row 65,536, you should verify that inserting a new column will not adversely affect any data above or below the current data. For example, you may have data in A1:G10 and A50:G60 . If you insert a column between columns E and F , a blank column is inserted not only between the data in A1:G10 , but also between the data in A50:G60 .

Page 138

OFFICEPRO, Inc.