Excel - insert column and row

I have Office Mac and I cannot get the insert column and insert row toolbar buttons to work.

They are shaded out or lighter than the rest of the icons in the toolbar.

I have gone through the preferences and tried all other sorts of views, options and such and cannot figure out how to do this.

It quite challenging because I am used to using the toolbar from my computer at work and it is hard to break that habit.

Please let me know if you have any ideas on how to get the insert column and row buttons to work.

Thanks,

15'PowerBookG4 667mhz1GBram+12'iBookG3 700mhz640mb, Mac OS X (10.4.7), iPod 5G and iPod Mini - lacie FW porche external & dvdrw

Posted on Aug 7, 2006 6:50 PM

Reply
4 replies

Aug 7, 2006 7:09 PM in response to p Nicholas k

The insert row probably was not set up correctly. Go the View-Toolbars-Customize Toolbars/Menu. The Insert Row command is used in a List Manager which is probably the icon you have. Remove that one. Go the the Command Tab. In the Category column choose the Insert Commands. In the command menu on the right, choose Column & Row (2nd and 3rd icon on this list). Place those on your toolbar and they should work to insert columns or rows in Excel.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Excel - insert column and row

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.