Excel 2016 Introduction

Lesson - Working with Columns and Rows

Excel 2016

Steps

Practice Data

1. Select the columns with the width you want to change. The columns are highlighted as you select them.

Select columns A through I

2. Release the mouse button. The columns are selected.

Release the mouse button

3. Drag the line to the right of any

Drag the line to the right of column E to the left, until the ScreenTip displays 12.00 (89 pixels)

selected column heading to increase or decrease the width of all the selected columns. The width of the selected columns changes accordingly.

4. Release the mouse button.

Release the mouse button

The column width has changed.

Click any cell to deselect the range. Scroll to the left, if necessary, to view the modified column widths.

C HANGING THE H EIGHT OF R OWS  D ISCUSSION

The height of rows in a worksheet automatically adjusts to fit the largest font in that row. The standard row height is 15.00 points. You can, however, manually increase or decrease row height as needed. You may want to increase the height of a row to emphasize headings or totals, or decrease the height of a blank row to use it as a narrow separator row.

When you increase or decrease row height, the current row height in both points and pixels appears in a ScreenTip to the right of the row you are re-sizing.

NOTE When you click the line below any row heading, a ScreenTip displays the height of the row in both points and pixels. If you are adjusting the height of a single row, it is not necessary to select the row first.

Page 132

OFFICEPRO, Inc.