• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Making Label Entries

Excel has three types of cell entries: labels, values, and formulas. Excel uses values and formulas to perform its calculations. A label is text in a cell that identifies the data on the worksheet so readers can interpret the information, such as titles or column headings. A label is not included in calculations. A value is a number you enter in a cell. To enter values easily and quickly, you can format a cell, a range of cells, or an entire column with a specific number-related format. Labels turn a worksheet full of numbers into a meaningful report by identifying the different types of information it contains. You use labels to describe or identify the data in worksheet cells, columns, and rows. You can enter a number as a label (for example the year 2003), so that Excel does not use the number in its calculations. To help keep your labels consistent, you can use Excel's AutoComplete feature, which completes your entries based on the format of previously entered labels.

Enter a Text Label

Click the cell where you want to enter a text label.

Type a label.

A label can include uppercase and lowercase letters, spaces, punctuation, and numbers.

Click the Enter button on the formula bar, or press Enter.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint