Keyboard shortcut to select all cells below current cell.

_Go to "Provide Numbers Feedback" in the "Numbers" menu_, describe what you wish.
Then, cross your fingers, and wait _at least_ for iWork'10 😉

Yvan KOENIG (from FRANCE lundi 2 mars 2009 23:23:26)

How about this as a workaround:

First some disclaimers. I am assuming there are no gaps in the data in a column. If there were, Excel's Control-Shift-Down wouldn't work either. I'm not sure what you are going to do after you select those cells so this idea might not work for you. And, I don't know if you are trying to select all of the non-blank cells in the column or going down to row 10000 and selecting from there to the bottom. I am assuming you are selecting all, or at least from somewhere near the top all the way to the bottom.

Click "reorganize" on the menu bar. In the second part of the pane that pops up is "show rows that match the following". Choose the column you are interested in. Select "is not blank". Now your table will show only the rows with non-blank cells in that column. Back on the table, you can now click on the top cell, quickly scroll to the bottom, and shift-click the bottom cell. When done, uncheck the "show rows that match the following" box in the reorganize pane. Once this is set up it is easy to repeat for other columns; just leave the reorganize pane open. Not as easy as Control-Shift-Down but better than "mousing to the middle".

I use the following shortcuts all the time in Excel:

CTRL-UP, CTRL-DOWN, CTRL-LEFT, CTRL-RIGHT - These move the view to the beginning end, left, right of a block of data. Or if a blank cell is selected, they move the view to the closest data filled cell in the indicated direction. This is incredibly useful for moving around large spreadsheets.

CTRL-SHIFT-UP, CTRL-SHIFT-DOWN, CTRL-SHIFT-LEFT, CTRL-SHIFT-RIGHT - These do the same thing, but also select all the cells along the way. Much more efficient than using the mouse for selecting long lists of data, or deleting large areas of empty cells

These shortcuts, as well as their Mac equivalents (CMD instead of CTRL), do nothing in Numbers 09. I'm going to send this post to Apple as feedback as well. Get on it Apple!

I work with spreadsheets from several hundred to 70,000 lines long, and currently use VMWare Fusion to run Windows Excel 2007. Excel 2008 for Mac is not an option because it is horrendously slow comparatively even though it doesn't have to run through a virtual machine. If Numbers could be a Mac-native Excel replacement for me, I wouldn't have to run Windows at all (Woohoo!). Unfortunately there are too many details like this missing. Hopefully in a few years!

Pages (and ClarisWorks/AppleWorks) offer a similar function in the word processor environment.

Command-arrow will move the insertion point to the beginning or end of a line (left or right arrow) or the document (up or down arrow).

Option-arrow will move the insertion point to the beginning or end of a word (left or right) or a paragraph (up or down).

Adding Shift to either combination Selects the text between the staring and ending points of the insertion point's travel.

But not in Numbers.

Do Provide Numbers feedback.

Regards,
Barry

Hey Ezekielf:

I'm curious about your experience with Windows Excel 2007 in Parallels and large spreadsheets. I have some large spreadsheets as well, and I've been a little dismayed at how slow Excel 2008-Mac is. How is your performance using Windows Excel in Parallels? Is there much difference in speed than in a Windows machine?

I use the Spreadsheet Assistant (add-ins.com) to do lots of nice selection tricks in Windows Excel. I wish there was a similar add-in for Excel 2008-Mac.

Thanks

No.
Numbers is written for 80% of spreadsheet users and is totally different to excel.
S.