Results 1 to 12 of 12
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Filled Grid tool (XP)

    This may turn out to be one of those things that everyone except me knew about. I have a question about a toolbar button (Filled Grid) that appears to have no purpose. This 'mystery' button isn't contained on any of Excel's built-in toolbars. It is the second last item in the list of Format commands (Tools, Customize, Commands, Format) in the toolbars Customize dialog. I had never noticed this command before so I did some searching but found nothing other than 2 or 3 other people wondering what the command was for but no answers. Nothing on the Microsoft website. Nothing in Excel Help. Do you happen to know anything about the Filled Grid command?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Filled Grid tool (XP)

    I have no idea, and as you have found the question has been asked in other forums too but without a reply. It can't be a really important button... <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Filled Grid tool (XP)

    If you goto Tools, Customize, Commands, Format and press description it tells you what it does:
    "Toggles the Draw Border Button to Draw Border Grid"

    The "Draw Border" button turns the cursor into a pencil and allows the users to draw in excel. When the button is the "Draw Border" it just outlines the selected range with a border around the end (like the "Outside Borders" button does to the selected region.

    When toggled to the "Drow Border Grid" the outlined area has the outer borders as well as all internal borders added (like "All Borders" does to the selection.

    The "Draw Border" button is on the "Borders" Toolbar (underneath the "Filled Grid" tool in Tools, Customize, Commands, Format ) and the "Draw Border" button by itself is a few items above the "Filled Grid" item. If you add both the Filled Grid and the "Draw Border" items to the toolbar, you can press the "Filled Grid" button to toggle the "Draw Border" button.

    Why it is needed is unclear, since the "Draw Border" button has an arrow which allows one to toggle it directly, perhaps in the past this ability of the buttons was not available.

    Steve

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Filled Grid tool (XP)

    Great, thanks!

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Filled Grid tool (XP)

    Wow - how dumb can we all be at one time??? Pretty darn dumb, apparently.

    Thank you, sir.

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Filled Grid tool (XP)

    Of course it would appear to do nothing in most instances. One has to have that button visible so one can see it toggle <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Steve

  7. #7
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Filled Grid tool (XP)

    Well I've now put it on MY toolbar so I can experience the nothing that it does - should make for some fascinating time-wasting!

    Have a great weekend - and, again - many thanks for the pleasure of your company.

    Aunt Linda

  8. #8
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Filled Grid tool (XP)

    As you've read - turns out it most certainly is NOT a very important button - I'm convinced the people or person who decided to make this particular button available to all of us - and then not tell us of its existence and - to add insult to injury - make it do nothing of any consequence - sits alone in the dark at night and comes up with stuff like this - AND they're the same people who write the instructions for "some assembly required" items . . .

    Enjoy the weekend

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Filled Grid tool (XP)

    It's a pretty useless button since it is only useful in combination with the Draw borders tool, and its functionality is already available from the Borders toolbar that you'll use anyway if you want to draw borders directly on the worksheet.

  10. #10
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Filled Grid tool (XP)

    I'll be certain to share the existence and function (NOT) of this button with my students this Fall - hahahahahaha - they'll love me for this one, dontcha think?

  11. #11
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Filled Grid tool (XP)

    Excellent idea! I'll be sure to tell them where it came from - and how far they'd have to travel to pay you back . . . .

    Aunt Linda

  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Filled Grid tool (XP)

    You could have a quiz - 10 useless facts I know about Microsoft Excel... <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •