how to move up shifted data records in columns (Numbers 3)

Question

oppuknowme Author

Level 1

8 points

how to move up shifted data records in columns (Numbers 3)

One of the columns a Numbers 3 spreadsheet has shifted one cell down. How do I get that column come back up please?

iMac (21.5-inch Mid 2011), OS X El Capitan (10.11.4), Numbers 3.6.1

Posted on Apr 29, 2016 1:56 PM

Reply

Answer 1

Best reply

SGIII

Level 8

35,276 points

Apr 30, 2016 1:36 PM in response to oppuknowme

Just select all the cells that have shifted down, and while holding the mouse button down, drag the cells up.

SG

Reply

Answer 2

oppuknowme Author

Level 1

8 points

Apr 30, 2016 1:38 PM in response to SGIII

Thank you! I spent an hour Googling for the answer and could not find it. Your solution was easy and, even though I had over 500 lines of entries, the column moved up very easily!

Thank you again!

Reply

Answer 3

SGIII

Level 8

35,276 points

Apr 30, 2016 5:27 PM in response to oppuknowme

Yes, it's a nice feature of Numbers that doesn't seem to be written up anywhere. Thanks for the green tick!

SG

Reply