Selecting the cell names in the drop down list usually shows you which cell is so named, however I now have cells that appear to have multiple names.

When you delete the cell, Im assuming you want the (contents of) the cells below itor to the right of itto move into the space.

In the example, the cells are shifted up into the empty cell space.

The original table.

We want to delete cell B6, which contains EEEEE.

The same table, with all cells in column B and below B6 selected.

The original results were copied, and the Values pasted back into the same cells before deleting B6.

End results would be different if the formulas had remained in the cells when the deletion was carried out.

Your suggestion is what I ended up doing after I couldnt find the desired solution in help or the manual.

Im too used to using Microsoft Excel (which has a shift up, down, left, right feature).

In Excel there is a menudialog in which you must answer these questions once you request the deletion before anything happens.

In Numbers, just select the data that needs to move to fill the gap, and move it.

There, done. I think the easiest way, for me the way requiring the least manual dexterity, is to Select the range to be moved.

Then Edit Mark for Move, click on the cell to be deleted, and Edit Move.

The only downside in Numbers is that if you are working with a very large table, selecting the range to move can involve some scrolling.

Its often the case in Numbers that extremely large tables can be more difficult to work with than in Excel.

Of course, I mostly used it when I had information in various areas of an AppleWorks spreadsheet just need to edit one section.

Deleting one cell out of a row can be disruptive of any table being used as a database, so I support the Numbers approach of assuring that the user knows what he or she is doing to the data.

I can see what you liked about the AW feature, but even in AW I would say it is an unnecessary tool, more in the class of bells and whistles.

Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums.

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.

Deleting Cell Names In Excel For Mac