When you have range names in a worksheet and you set the zoom lower than 40%,
all range names appear in the background with borders around it.

Is there a way to show range names in the background in the same manner but
with a more user friendly zoom llike 75% or 100%?

I searched a lot on the web and all I found is the follwing:

Excel name manager highlights range names but it does not allow you to click
in the cells behing the range name. When you do so, you are in a text box
containing the range name, not in the cell.

I also found VBA functions that can be used with conditional formating.
Those functions scan all names in the workbook to test if the conditional
formated cell intercepts a range address. It works but since every single
names are scan in every single cell where the conditional formating is
applied, this method is not really efficient in large workbooks.

Any other suggestions?