An ongoing shortfall on the Mac (for me) has always been the lack of Alt-key control of the menus in Office--in Word, PowerPoint and especially Excel. Since I can't take 'no' for an answer I thought I'd try this forum, although Apple.com doesn't seem to have a place for non-Apple apps for the Mac.
Enter: Complete a cell entry ⌘ + Shift + Return or Ctrl + Shift + Enter: Enter a formula as an array formula: Esc: Cancel an entry in the cell or formula bar: Ctrl + A: Display the Formula Builder after you type a valid function name in a formula ⌘ + K or Ctrl + K: Insert a hyperlink: Ctrl +. A clear list of over 200 Excel shortcuts for both Windows and Mac, side-by-side. Windows shortcuts in dark gray on the left, Mac shortcuts in white on the right. Microsoft 365 includes premium Word, Excel, and PowerPoint apps, 1 TB cloud storage in OneDrive, advanced security, and more, all in one convenient subscription. With Microsoft 365, you get features as soon as they are released ensuring you’re always working with the latest. Create, view, edit, and share your spreadsheets using Excel for Mac. Hold the ALT key and press the Enter key for Windows (for Mac – hold the Control and Option keys and hit the Enter key). See Also: 200+ Excel Keyboard Shortcuts. Start a New Line in Excel Cell Using Formula. While keyboard shortcut is fine when you are manually entering data and need a few line breaks. With Excel on a Mac a line break is entered by adding the Command (cmd) key to the other two - cmd alt enter. The Command key may be replaced by the Control key (ctrl) in some versions of Excel.
I am looking for Alt-key navigation for the Mac versions of Windows Office (at least as available through Windows Office 2003 versions). If you've never used Excel on a Windows machine, you will likely misunderstand this request (based on my review of Google search results). In Windows Excel 2003, you can access any menu command through the keyboard in a very efficient way.
A lot of Mac people respond to Alt-key questions with the standard shortcuts (Command 'O' is open) or thinking the problem is that there is user confusion because there is no Alt key ('it's the Option or Command key'). All this is known and used often. I'm also not interested in the Accessibility feature (Ctrl-F2) which is very slow compared to direct access since you're essentially replicating a mouse action, rather than an actual keyboard shortcut. This question is application specific (Office); I know about OS system shortcuts (and use those often as well).
Excel Mac Ctrl Shift Enter
What I am interested in is leveraging keyboard commands, since although not GUI and oh-so-not-nouveau- cool, are the old fashioned way expert users get work done really fast. When you need to pound in data, keeping your hands on the keyboard is always faster than typing, the mouse/eye, then hands back to typing, then mouse/eye.
What I am looking for is some trickery, macro, add-in, something that replicates being able to hold down the 'Alt' (option or command or control on the Mac) key and type TOG (for example), which will instantly execute toggling grid on or off (Tools/Option/Grid). WAO (window/arrange/horizontal), and so on through tens or hundreds of very frequently used menu combinations. In addition to just being faster, this approach is faster if you get 'mouse fatigue' (eye strain or wrist/hand strain or both), especially on multiple and large displays at high resolution. With Windows Alt key navigation, you can navigate by touch typing even if you're using an infrequently used menu combination by holding down the Alt key and reading the menu, seeing the shortcut (underlined letter), typing it, and moving on to the next submenu (or the next work task).
Granted, Microsoft's new Ribbon interface (started on Office 2007 on Windows) seems to indicate the world thinks more GUI is needed, but I've yet to find an expert user who doesn't hate it. Fortunately in 'Ribbon' versions of Office, you can still type most Alt key shortcuts from memory. They're not documented anymore since there are no 'menus' with the Ribbon. Sort of the world's largest collection of Easter Eggs.
I'm bilingual Windows/Mac. I've always had Macs at home, and mostly Windows at work (except for two companies... one of which was Apple!). I'm resurrecting this issue because I'm really kind of aggravated that when I have serious Excel work to do for my personal life, I do it on my work computer because the mouse/menu approach is so much slower.
So, isn't there some Add-in that can simulate the keyboard shortcuts at least partial Windows users know and love (and are really better... it's ok guys, sometimes one can learn from the dark side).
Ctrl Shift Enter Excel Macro
Posted on
In Windows, when I want to select several non-consecutive items in a list, I hold the ctrl key and click the items I want. If I want a range of consecutive items, I hold the ctrl AND shift key and click on the first and the last item and windows highlights everything in between.
On the Mac, I hold the command key (clover thing) and click to select non-consecutive items, but is there anything equivalent to the Ctrl-shift (to select a lot of consecutive things with individually clicking each one)?
Thanks.
15.4 MacBook Pro 2009, Mac OS X (10.5.6), 2.4 Mhz, 4GB, 320 HDD 7200
Ctrl Enter Excel Functions
Posted on