Skip navigation

Cannot add column -the command is not active. why?

421 Views 8 Replies Latest reply: May 8, 2013 11:02 AM by Jo Sweets RSS
Jo Sweets Calculating status...
Currently Being Moderated
May 5, 2013 12:39 PM

I am trying to add a column to my spreadsheet. I only have about 30 columns. But when I go to the drop down menu, the add column before/add column after commands are not active so I cannot click on them. Why? How do I fix this? thx

  • Wayne Contello Level 6 Level 6 (12,820 points)

    can you confirm this behavior on all tables or just a particular table?  Have you tried rebooting?  Can you post a screenshot with a cell selected in the problem table ?

  • Jerrold Green1 Level 7 Level 7 (28,280 points)

    Jo,

     

    Have you Selected the table or something in it?

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,280 points)
    Currently Being Moderated
    May 5, 2013 10:59 PM (in response to Jo Sweets)

    In Numbers, you have a limited number of Header columns. Once you have 5 Header Columns, and if your selected column or cell involves one of those 5 Header Columns, you are done adding Header Columns and the menu item will be grayed out. A Screen Shot would have shown Wayne which column had the focus on it.

     

    Header Columns and Rows and Footer Rows are treated specially and have special features in Numbers. You can read about them in the Numbers User Guide, downloadable from the Help Menu.

     

    See Using Table Tools, beginning on page 48.

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,280 points)

    Jo,

     

    Have you Merged or Split any cells?

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,280 points)
    Currently Being Moderated
    May 7, 2013 12:28 AM (in response to Jo Sweets)

    Here's a quick way out of the situation:

     

    Select cell F1

     

    Type Option-LeftArrow 5 times, creating 5 blank (Body) Columns to the left of your present Column F.

     

    Select all the cells in columns A-E

     

    Command-C to Copy them

     

    Select the blank cell F1

     

    Command-V to Paste (You now have two copies of the first five columns)

     

    Delete (Header) Columns A-E

     

    This process replaces your unintended 5 Header columns with Body columns and your problems with adding columns should be over.

     

    When you get some time, read the User Guide reference on Header and Footer columns in tables.

     

    Jerry

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.