Insert Cell, shift cells down...

KOENIG Yvan wrote:
Feature unavailable.

For a row it's the same.
Inserting a cell pushing to the bottom cells below the insertion point would be a catastroph.

When we think that we 'must' do that, it's time to try to discover what was wrongly defined in our table design.

Yvan KOENIG (VALLAURIS, France) lundi 7 juin 2010 21:47:19

I disagree that this is catastrophic, or implies a poorly designed spreadsheet. I have a financial spreadsheet which has some standard projections that need to get bumped up every month. Because this spreadsheet gets updated, and saved for historical reasons, it doesn't make sense to make it be automatically updated by date, so I simply go in once a month and bump 9 rows over one month. It's worked great in Excel, but now in Numbers I have to copy paste many cells, which is simply more prone to human error.

Scott Odgers wrote:
Basically looking for an "Insert Cell' command, which I can't find.

Not surprising—there is no such command.

You can, though, Select the cells that need to move. then drag them down one row, leaving what used to be the top cell in the selected group empty and ready.

See also "Copying and Moving Cells" on page 83, and "Copying or Moving Formulas and Their Computed Values" on page 126 of the Numbers '09 User Guide, which you can download via the Help menu in Numbers.

Regards,
Barry

This question was asked and responded many times.

Feature unavailable.

We must see the datas stored in a row as an object of its own.

Most of the time, we can't discard our right leg from our trunc.
When an accident split or body, it's a catastroph.

For a row it's the same.
Inserting a cell pushing to the bottom cells below the insertion point would be a catastroph.

When we think that we 'must' do that, it's time to try to discover what was wrongly defined in our table design.

Yvan KOENIG (VALLAURIS, France) lundi 7 juin 2010 21:47:19

There is no defined rule to design a spreadsheet.
The only one which apply to all of them is that it must do correctly what it is supposed to do.

The Numbers designers decided, and as an End User like you I feel that it's a good choice, that a row is a coherent object which must not be modified.

Given this metaphor, inserting a single cell, pushing existing ones to the bottom, would be odd.
Something like replacing page 112 of the "Holy Bible" by page 112 of the "Kama Sutra"
and replacing page 112 of the "Constitution of the USA" by page 112 of "Das Kapital".

You are free to prefer the XL behaviour but Apple Engineers are free to choose an other design.

Nobody force you to use a product which doesn't fit your needs.
A FREE 30 days trial version is available since january 2009.
If you bought the product without checking that it matches your needs, *_it's your own fault_*.

If you bought it since less than 30 days, ask Apple for a refund and return to your dear XL.

Yvan KOENIG (VALLAURIS, France) dimanche 18 juillet 2010 17:11:59