As a trainer, you get to like the unusual (and so do your trainees).
In the old days Microsoft applications were full of "Easter eggs" - hidden features programmed in by developers but not readily available.
Who can forget the Microsoft Access eight-ball, which dispensed life advice, or the flight simulator built into Excel?These days you have to look harder for weirdness - but features don't come much odder than the way Excel allows you to display range names on screen.
Creating Range Names A range name is a name which you can give to any cell or block of cells in Excel.
So if you want to call cell B17 in worksheet Sheet1 "Bob", for example, you can then easily navigate to this range (and use the range name within formula too, in place of the cell reference).
To create a range name like this for a cell or cells:

1. First select the cell or cells that you want to name (say B17, for the sake of argument).
   
2. Go to the name box at the top left corner of the Excel screen (this will display the cell reference of the active cell - B17 in the above example).
   
3. Type in a name for this range, making sure that you don't include any spaces, then press ENTER.
   A good name would be something like InputCost or InterestRate.
   
4. You can now use the drop arrow next to the name box to move between ranges, and also refer to cells by their name in formulae.
   

So much for creating range names - now, how can you display these names within the cells they refer to? Displaying Range Names If you select a cell, Excel will show you its name in the name box (see above).
If you have named a block of cells, you need to select the entire block to get this to work.
Wouldn't it be nice if you could tell Excel to display your range names as watermarks within the cells they refer to?And wouldn't it be weird if Microsoft built in this feature and then made it virtually unusable? To display your range names like this, what you need to do is to zoom out - usually to a view which is smaller than 40% (39% would do fine!).
To zoom out, do one of the following:

• - hold down the CTRL key and use your mouse wheel
• - use the slider at the bottom right of Excel to change your zoom figure
• - use the Zoom tool on the View ribbon of Excel to zoom out

Whichever method you choose, you should then be able to see any range names that you have created written in faint type in the relevant cells or blocks of cells.
Can't see them?Try looking closer.
Now do you see them? The problem is that they're quite small, so your natural instinct will be to zoom out so that you can see the names more clearly; but the moment that you change your zoom view to anything more than 40%, the names will disappear again! This article ends with a question: why would Microsoft programme in this feature, then restrict it in this way?We would be genuinely interested in the answer!