Insert Row & Column tools on Toolbar Always Grayed Out

[John Dough]

Running Office X, latest update, under Panther.

The Insert Row and Insert Column tools on my toolbar NEVER work -- they
never are available (always display grayed/faded). I CAN insert rows and
columns using commands from the menu. And yes, I have a complete row or
column highlighted when I am trying to use the tools. The delete row and
delete column tools on the toolbar seem to work just fine.

What is the reason for this. If these tools do not work as expected (and how
they worked in Office 2001), why do they bother even having them?

 

[J.E. McGimpsey]

Running Office X, latest update, under Panther.

The Insert Row and Insert Column tools on my toolbar NEVER work -- they
never are available (always display grayed/faded). I CAN insert rows and
columns using commands from the menu. And yes, I have a complete row or
column highlighted when I am trying to use the tools. The delete row and
delete column tools on the toolbar seem to work just fine.

What is the reason for this. If these tools do not work as expected (and how
they worked in Office 2001), why do they bother even having them?

There are two sets of Insert Row/Column commands - one set works as
buttons and one doesn't

Choose Tools/Customize/Commands. The Insert Row/Column buttons that
work on toolbars are the ones under the Insert Category. The ones
under the Edit category (which have the same icon) don't work.

 

[Jim Gordon MVP]

Hi John,

There are two pairs of identical looking buttons. One pair works everywhere.
The other pair only works within a managed list (using the List Manager).

McGimpsey has the right answer concerning where to find both sets of
buttons.

If you find this confusing, please send a note to Microsoft requesting that
they make this distinction easier to understand. The URL to send such
request is:
http://www.microsoft.com/mac/feedback/suggestion.asp

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

 

[J.E. McGimpsey]

There are two pairs of identical looking buttons. One pair works everywhere.
The other pair only works within a managed list (using the List Manager).

McGimpsey has the right answer concerning where to find both sets of
buttons.

If you find this confusing, please send a note to Microsoft requesting that
they make this distinction easier to understand. The URL to send such
request is:
http://www.microsoft.com/mac/feedback/suggestion.asp

Thanks for the correction, Jim!

I've never found an actual use for managed lists, so I wasn't aware
that they had a separate command.