Hacker News new | ask | show | jobs
by p00dles 1930 days ago
^1 for Excel keyboard shortcuts.

One can customize the ribbon at the top for must used functions, which can make Excel such a fast tool to use compared to Google Sheets or even Excel for Mac (speaking as a Windows user).

If I had a big Excel project to do, and I had the choice of 1/2 day on Excel (Windows) vs. a full day with Google Sheets or Excel (Mac), I would pick the 1/2 day with Excel (Windows).

2 comments

The keyboard shortcuts improve productivity so much. Yeah, as another said it’s amazing when I try to use Excel on a Mac how much I evidently depend upon the shortcuts in normal use. They’re all different on the Mac version, and I can only take so much of it before I just email myself what I was working on and pick it back up on the PC. Seems like an easy thing for MS to reconcile but I don’t want to give up my keyboard mapping, and I’m sure the Mac Excel guy doesn’t either. Nice feature would be to choose what shortcut layout you wanted despite platform.
Agreed..I actually have a separate laptop (Windows) that I use for nothing but excel. Even Excel on Mac isn't the same as on Windows
I removed the F1 from a keyboard so that I don't misfire when going for F2, resulting in the dreaded 'Help' window that you have to use a mouse to click out of.
Ctrl+Space, C used to work for closing the Help window until recent versions. Unfortunately that doesn’t work anymore, the only solution is to use a VBA macro bound to a keyboard shortcut. At least in return the keyboard focus now remains in Excel instead of switching to the Help dialog.
Microsoft PowerToys on Win10 will let you remap keys. If nothing else you could make F1 do what F2 does.

https://docs.microsoft.com/en-us/windows/powertoys/