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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top