Excel Delete Row Shortcut For Mac

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*?

Learn 200+ Excel shortcuts (Mac and PC) with this easily searchable list. This App is not compatible with Smartphones and Tablets. Shortcut Coach. Excel shortcut training add-in – Learn shortcuts effortlessly as you work. Delete Row: Ctrl +-^ +-191.

Yes, I have googled the **** 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. Mac disk reader for windows. 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. 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!