Excel® 2013 On Demand

Entering Labels on a Worksheet

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 the data in worksheet cells, columns, and rows. You can enter a number as a label (for example, the year 2013), 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 automatically completes your entries (excluding numbers, dates, or times) based on previously entered labels.

Enter a Text Label

Click the cell where you want to enter a label.

Type a label. A label can include ...