In MS Excel there is a keyboard shortcut, Ctrl ShiftDown, that selects all the cells from the currently selected cell to the bottom of the column. How can I do this in Numbers '09.using a keyboard shortcut.? Yes, I have googled the.
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!). All Virtual Lab users must use their ONYEN (User ID) to access VL. If you have special needs in Virtual Lab, please submit an Online Request for Help and we will try our best to meet those needs. All programs available through Virtual Lab are free to the end user.
of this. I have three other engineers also seeking an answer, with no luck. I have searched this forum and the user manual for Numbers. I know it can be done with a mouse, but that is not the solution I'm looking for. I have 20,000 rows in the column I want to select, and 40,000 in the column next to it. Mousing down 'somewhere in the middle' is ridiculous.
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'. How about this as a workaround: First some disclaimers.
![Virtual lab iit Virtual lab iit](https://help.unc.edu/files/2012/04/VirtualLabSetup_SS1.png)
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.
![Excel Virtual Lab For Mac Excel Virtual Lab For Mac](/uploads/1/2/5/3/125385950/763647471.png)
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. Apple Footer. This site contains user submitted content, comments and opinions and is for informational purposes only. Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the.