Where Do I Put The Label? In #Excel

Sometimes you need to label the result of a function, but have no where to add it. Here’s an option:

You can download the file here to follow along. If you get a preview, look for the download arrow in the upper right hand corner.

Here we have a list of sales for several locations.

cfor1

The values in row 11 are actually the averages, not the sum or median of the list above. However, we don’t have any columns where we can indicate what these are. We can add a comment or a footnote, but an alternative would be to custom format the values in cells C11 & D11 to indicate what they are.

So, if we either right click on cell C11 and select “Format Cells..”, or use the keyboard shortcut Ctrl + 1, the format dialog box appears. From the Number tab, choose “Custom” at the bottom of the list:

cfor2

What is currently highlighted is the formatting of cell C11. That format also appears in the box right below “Type:”, and the result of that formatting is at the top under “Sample”.

Let’s say we want cell C11 to say “Avg: 460,875”, all we need to to is add “Avg: ” in front of the current format in the “Type:” box. Note that any text needs to be in double quotes:

cfor3

Notice how the result of your format change appears in the “Sample” box. Now click OK and the formatted cell is changed:

cfor4

And although the result in cell C11 appears to be text, if you make any changes to the values, the formula is updated accordingly:

cfor5

Looking back at the formula dialog box, you’ll see that your new format is now included at the bottom of the list, and the original formatting is still in tact:

cfor6

You can also add text to the end of a format:

cfor7

Try different labels, text, and locations and see how it works for you!

Happy Excelling!

Related Post

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

, , , ,

No comments yet.

Leave a Reply