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

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

Type a label. A label can include ...

Get Excel® 2013 On Demand now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.