Excel 2016 Introduction

Lesson - Working with Columns and Rows

Excel 2016



P ROCEDURES 1. Point to any cell that displays pound signs instead of the cell value.  S TEP - BY -S TEP Use narrow column tooltips.

Scroll to view cell K2 .

Steps

Practice Data

1. Point to any cell that displays pound signs instead of the cell value. A tooltip displays the formatted cell value.

Point to cell K2

C HANGING THE W IDTH OF C OLUMNS  D ISCUSSION

When you create a new worksheet, approximately eight characters in the default font will fit within the default width of each column. You may need to adjust the column width to accommodate the number of characters entered in the column cells or changes in the font size, as well as to save worksheet space.

If you change the font or number format in a worksheet, the text or numbers may become longer than the column is wide. Text will spill over into the next cell to the right, as long as that cell is empty. However, if there is an entry in the cell adjacent to a long text entry, the long text entry becomes truncated, and you must increase the column width in order to see the entire cell entry.

If, however, a cell contains a numeric entry that is longer than the column is wide, pound signs (#) appear. In other words, numeric entries do not spill over, and you must either increase the column width or decrease the font size in order to view the numeric entry.

When you increase or decrease column width, the column size and number of pixels appears in a ScreenTip to the right of the column you are re-sizing.

Page 130

OFFICEPRO, Inc.