Excel 2007 : How to view defined names on worksheet

[STGE2]

Hi

I have a worksheet where I want to view all defined ranges on the worksheet at all times.

I know you can set zoom to 30 percent or below and the defined names appear on the sheet, but I want to see all defined ranges at 100 percent zoom.

Is this possible?

Best regards
Stine

[Richard Buttrey]

Hi,

I'm not clear what you mean by a 'defined range', or indeed what you're really asking for. Are you wanting to see lots of ranges all at the same time but still at 100%. Perhaps you could upload your workbook and explain with reference to specific cells/ranges what you expect to see.

Rgds

[STGE2]

Hi Richard

Sorry for bad explanation.

I mean named ranges. E.g. I select A1:D30 and give this range the name TEST.

When I zoom to below 30 percent in my worksheet the named range is shown in gray letters in the worksheet.

Is it possible to see this also at 100 percent zoom?

Best regards
Stine