Change columns from header to normal

Correct. The conversion is available, but only in one direction—the leftmost regular column may be converted TO a header column, the topmost regular row may be converted TO a header row, to a maximum of five in each case.

For your situation (one header column that you want to replace with a regular column), you can do the whole table replacement described by Wayne, or you could replace only the single column:

• Click on any cell in column B to select it. Press option-left arrow to Add a Column before column B.
• Click on the Column A reference tab to Select the whole column. Copy.
• Click on cell B1 (in the new column B).
• Go Edit > Paste and Match Style.
• Click on any cell in column A.
• Go Table > Delete Column.

Works fine IF the table contains no formulas that referenced cells in column A. Any such formulas will now show a REF error, and will need to be reconstructed to correct the cell references to the new column A.

You can get past this issue by formatting any cells containing column A cll references as Text before deleting column A, then changing their format back to Automatic (or whatever setting you had previously) after column A is deleted.

Regards,

Barry

I found a way to convert header columns back to regular columns. Because of the limit of 5, you can simply drag 5 blank regular columns to the left of the existing header columns and the existing columns will be forced back to regular columns. Afterward, the new blank header columns can be deleted.

Hi Renagerie,

Nowadays you can also just change this popup here:

quinn

Hi Lachia,

The grey fill isn't just fancy formatting; it's there to let you know that these are Header cells, with properties not shared with 'regular' (or 'body') cells.

If you do choose to use a 'plain' table, you lose not just the grey fill, but also the properties that make these rows and columns "Headers".

You may want to spend a bit of time with the Numbers '09 User Guide to learn how Headers are different, and how those differences can be used.

You'll find a link to download the guide in the Help menu in Numbers.

Regards,

Barry

PS: To remove the bold attribute when following Wayne's instructions above, use Paste and Match Style rather than Past when pasting the data and formulas into the new , Plain table.

B

Don't waste time trying to guess this or that, download and read Numbers User Guide.

Yvan KOENIG (VALLAURIS, France) lundi 20 février 2012

iMac 21”5, i7, 2.8 GHz, 12 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.3

My Box account is : http://www.box.com/s/00qnssoyeq2xvc22ra4k

you can copy the data out of the existing table, then create a NEW plain table from "Tables" menu in the toolbar:

Then paste the data you previously copied into the new table

Indeed; much better. I didn't try that because the comment above indicated that it deleted the columns. I guess that has changed.