View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
sri sri is offline
external usenet poster
 
Posts: 37
Default display names of defined cells

Easiest way to get a overview of your named cells is to just change the zoom
view %.

Just adjust the zoom to any number less than 40%, excel will display all
names highlighted in Blue font with a border.
--

Regards

Sri


"Melissa" wrote:

Is there a way to visually show on the spreadsheet which cells have been
named and what the names are? Something like a coloured border around the
cells and the name displayed like a comment box? I don't actually need it in
this particular format but would just like to see where my named cells are so
I can edit them if I see errors.