I'm trying to deleting certain cells within the same column but I don't know how without deleting the entire column. It sounds so simple but I'm sure I'm overlooking something. Thanks.
MacBook Pro
jackiego26 wrote:
Bummer! Thought there would be something similar to Excel.
Excel describes this in different terms, and the Excel user goes through a different set of steps, but the reality is that in Excel as in Numbers you are shifting content from one set of cells to another, not 'deleting cells'.
If you were actually 'deleting cells' from rows 2-11 of a column, then shifting all cells right of the deleted cells into the space left by the 'deleted' cells, one of the results would be that at the right edge of the table, rows 2 through 11 would end one column 'earlier' than the rest of the rows (from which 'cells' had NOT been deleted.
Excel: Select the cells whose content is to be replaced, tell Excel to 'delete cells'. Tell Excel which direction to move content to fill the cells. Excel moves that content into the emptied cells.
Numbers (method 1): Select the cells whose content is to be moved. Copy. Select the first cell that is to receive the content. Paste.
Numbers (method 1a): Select the cells whose content is to be moved. Drag the content to the first cell that is to receive the content. Drop.
Numbers (method 2): Select the cells whose content is to be moved. Press shift-command-X (or go Edit > Mark for Move. Select the first cell to receive the content. Press Shift-command-V (or go Edit > Move.
Regards,
Barry
Hi Jackiego26,
Highlight the cells to be deleted the click Edit > Delete.
If the cells are not contigious then as you click each cell hold down the Cmd key. Again, Edit > Delete.
Hope that is what you are looking for.
Cordially,
RicD
Hi RicD,
Thanks for the response but unfortunately that only deletes the contents in the cells and not the actual cells. I'd like to be able to delete the cells and shift everything to the right. Sorry if I wasn't clear before.
Thanks again!
Jackie
It's not so much a bummer as a different way. Numbers is not Excel-- which is mostly good. On occassion there are features and things that remind you Numbers is not Excel. Overall I like Numbers better.
Good luck
Bummer! Thought there would be something similar to Excel.
Thanks much, Wayne. I'll do that. =)
That operation is not available. The easiest way to acieve the same thing is to select everything (including what you want to move), then unselect the cells you want to "delete", then drag everything that is highlighted to the left (or right) by one cell. To select contiguous cells:
1) click the top left cell
2) shift-click the bottom-right cell
To unselect cells:
use the Command+click
How do I delete part of a column without deleting the whole column
