If the active cell is empty, Excel will extend the selection to the first non-empty cell below the active cell. If the active cell is non-empty, Excel will extend the selection on the last non-empty cell below the active cell. On a Mac, the command key (⌘) can be used instead of the control key.
![]()
For columns: the Home (Fn-Left Arrow) and End (Fn-RightArrow) keys take you to the top and bottom of the column your cursor is in but, unlike Excel, the focus remains on the existing cell. Once the top/bottom of the column is visible, holding the shift key down while selecting that top (or bottom) cell selects everything from the focus cell to that top/bottom cell. For rows: I haven't yet found an easy way to move to the start/end of a row. Maybe Numbers isn't really built for large datasets. It is probably more of a list manager (unfortunately). Within Numbers, selecting HelpKeyboard Shortcuts gives a list of shortcuts.
Comments are closed.
|
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |