How to Enlarge Box to See Complete Sheet Name

  • Thread starter Thread starter JG Scott
  • Start date Start date
J

JG Scott

When auditing for cell dependencies and I get the dotted line with
arrow to another sheet and I double-click on the line to see the
ranges, sometimes the box is not wide enough for me to see the entire
sheet name. I tried to resize it, but to no avail. Is there a way to
make the box larger so I can view the entire contents?

Thanks.
 
JG,

If you select the dependant you want, it puts it in the box Reference box at the bottom of
the dialog box. You can then click in that box to put the cursor in it, then use the arrow
keys to force it to scroll left or right. Not as good as having a larger box, but it does
at least let you see the rest of the link.

--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
 
Back
Top