In Excel 2011 I can select the entire sheet with Cmd + A and I can select all cells in a column with Cmd + arrow however this only selects cells with data in them and not blank cells. Is there a shortcut to select an entire column please, regardless of whether there are blank cells in there.
Windows shortcuts in blue. Mac shortcuts in red. Editing Copy ctrl+ c ctrl+ c Paste ctrl+ v ctrl+ v Undo ctrl+ z ctrl+ z Redo ctrl+ y ctrl+ y File Open ctrl+ o ctrl+ o New ctrl+ n ctrl+ n Print ctrl+ p ctrl+ p Save ctrl+ s ctrl+ s Save as f12 ⌘+ shift+ s Go to next workbook ctrl+ tab ⌘+ Close file ctrl+ f4 ctrl+ w Close all open Excel files alt+ f4 ctrl+ q Ribbon Show ribbon accelerator keys alt Show/hide ribbon ctrl+ f1 ⌘+ opt+ r Formatting Open Format dialog ctrl+ 1 ⌘+ 1 Bold ctrl+ b ⌘+ b Italic ctrl+ i ⌘+ i Underline ctrl+ u ⌘+ u Number format ctrl+ shift +!
Ctrl+ shift +! Chloe, Unfortunately for a Mac, that command does not exist, but there are ways to get close to the Windows functionality: a) You can Enable Ctrl + Arrows by disabling Mission Control settings on your Mac by following these steps: 1. Go to System Preferences Keyboard. Go to “Keyboard shortcuts” tab. Click “Mission Control” in the left window. Expand the “Mission Control” tab in the right window and click off “Move left a space” and “Move right a space” b) You can enable Ctrl+Spacebar for highlighting columns by disabling Spotlight Search 1.
System Preferences Keyboard.
Comments are closed.
|
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |