picking multiple cells in a column in numbers for mac

How to pick a cell and all those under it in a column

Posted on Aug 14, 2019 10:02 AM

Reply
Question marked as ⚠️ Top-ranking reply

Posted on Aug 14, 2019 11:16 AM

Click the cell, then while holding down the shift and command keys, hit the down arrow.


Recommend taking advantage of the resources in you Help menu: Numbers Help, Keyboard Shortcuts, and Formulas & Functions Help.


This one is in Keyboard Shortcuts, but there are so many there it's hard to find.


SG

3 replies
Sort By: 
Question marked as ⚠️ Top-ranking reply

Aug 14, 2019 11:16 AM in response to I'mWillie

Click the cell, then while holding down the shift and command keys, hit the down arrow.


Recommend taking advantage of the resources in you Help menu: Numbers Help, Keyboard Shortcuts, and Formulas & Functions Help.


This one is in Keyboard Shortcuts, but there are so many there it's hard to find.


SG

Reply

Aug 14, 2019 6:51 PM in response to I'mWillie

In addition to the key stroke combination SGIII presented, each of this modifier keys ( shift and command) can be used individually to add cells to a selection.


Click the first cell to select it,

then:


command-click another cell to add it to the selection

OR:


shift-click another cell to add all cells between it and the original cell* to the selection.


Regards,

Barry


*"all cells between it and the original selection" in this context means

"All cells contained in the rectangular array containing both the originally selected cell and the cell on which the shift-click was performed:"


Examples:


Regards,

Barry

Reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

picking multiple cells in a column in numbers for mac

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.