Excel 2016 Introduction

Lesson - Working with Columns and Rows

Excel 2016

Steps

Practice Data

3. Drag the line below any selected row heading down to increase or up to decrease the height of the selected rows. The height of the selected rows changes accordingly.

Drag the line below row 2 down, until the ScreenTip displays 18.75 (25 pixels)

4. Release the mouse button. The row height has changed.

Release the mouse button

Click any cell to deselect the range.

A DJUSTING C OLUMNS A UTOMATICALLY  D ISCUSSION

You can use the AutoFit feature to automatically adjust column width to fit the widest entry in a column. This feature is useful when you want your columns and rows to expand or contract to neatly fit the column or row content in large worksheets. As a result, you can save time, because you do not have to adjust each column or row individually.

NOTE Be careful when you are automatically adjusting columns that contain very wide entries, such as long worksheet titles. The column width will adjust to display the entire title in one column. If you are adjusting the width of a single column, it is not necessary to select the column first.



P ROCEDURES

1. Select the columns you want to adjust. 2. Double-click the line to the right of the heading of the column you want to AutoFit.



S TEP - BY -S TEP Adjust columns to AutoFit cell entries.

If necessary, scroll to view column H .

Page 134

OFFICEPRO, Inc.