Numbers Column Letters Are Messed Up. How Can I Fix That?

I suspect you have accidentally hidden column D by selecting the column or selecting a cell in the column, then engaging the Hide column menu item in the local menu (or in the Table menu).

Here's an example where I've done that with column D. Note that the formula shown here was entered into a footer row cell (A11), then filled right to K11.

Sums in the columns shown should decrease by 1 per column, due to the deleted values in the columns.

Select the whole table then use "Unhide all columns" in the Table menu to bring column D back into view.

Regards,

Barry

Either would be OK.

SUM(J2:J41) will sum the values of all cells in rows 2 to 41 of column J. If the values in the other four cells should not be included in the sum, they should not be in the formula, and can be deleted.

If this formula (when corrected) is to be placed in cell J42, and row 42 is the last row of the table, you can simplify the formula by making Row 1 a Header Row (if row 1 has the grey fill shown in my examples above, and had that fill colour when the table was created, it is already a header row.) Footer rows are not included by default in tables created from one of the general purpose templates, but you can specify the number of Header rows and Footer rows using the Table menu.

Placing Header Row(s) at the top of a table and Footer Row(s) at the bottom of the table makes summing the individual columns a very simple formula, as shown below:

If you need the formula in more than one column, you can, after clicking the checkmark to confirm the formula and close the editor, drag to fill it into adjacent cells. In the example, where the formula was entered into J42, hover the pointer near the left edge of the cell. When a small yellow filled circle appears, grab it with the pointer and drag left into the rest of the cells that should contain the same formula (adjusted automatically to sum the column they are filled in to).

One other note: The header row at the top of the table is 'frozen'. This keeps that row on screen while you scroll down the table, moving it up the screen and sliding it behind the 'frozen' header row.

Regards,

Barry

HI Fran,

Is there a formula in the cell at the bottom of 'what is now column J'?

Does that formula contain a reference to column K or to cell K38?

Would that formula be one that expects cell K38 to contain a number value?

If so, the error message is correct, and you would need to replace the text in K8 with an entry that Numbers recognized as a numeric value, or revise the formula to one that does not require a numeric value in K38.

Removing the content of K38 leaves an empty cell. If the data format setting for that cell is Automatic, numbers may interpret an empty cell as a zero, and use that value in its formula.You can check the data format setting of a cell by selecting the cell, clicking the format brush (upper right corner of the window), and clicking Cell in the sidebar that opens.

Regards,

Barry