Posted by jpluimers on 2020/06/26
[WayBack] Add or edit words in a spell check dictionary – Office Support:
By default, the words are stored in a text file called “RoamingCustom.Dic” – Google Search.
You can get there from the menu:
–jeroen
Posted in Office, Power User | Leave a Comment »
Posted by jpluimers on 2020/04/20
Since I tend to forget the Mac shortcut (the Windows one feels like it is in my autonomic nervous system):
F4Windows shortcut⌘TMac shortcutWhile editing a formula, this shortcut toggles cell references from relative to absolute, to partially absolute, back to relative again:A1–>$A$1–>A$1— >$A1— >A1It’s much faster and easier than typing$characters manually.To convert an existing formula, enter cell edit mode, place the cursor in or next to the reference you’d like to convert, then use the shortcut.Note: in Excel 2016 for the Mac, you can also use fn + F4.
Source: Excel Shortcut: Toggle absolute and relative references | Exceljet
–jeroen
Posted in Excel, Office, Office 2011 for Mac, Power User | Leave a Comment »
Posted by jpluimers on 2020/04/13
Toggle between regular view and view all formulas in a worksheet via [WayBack] Quickly See All the Formulas in Excel with This Shortcut which I wish I had known years ago:
- Windows:
Ctrl+`(the acute accent key, found next to the number 1 on your keyboard).- MacOS:
Cmd+`
Found using image search macos excel show all formulas – Google Search
–jeroen
Posted in Apple, Excel, Mac, Mac OS X / OS X / MacOS, MacBook, MacBook Retina, MacBook-Air, MacBook-Pro, macOS 10.12 Sierra, macOS 10.13 High Sierra, Office, Office 2011 for Mac, Power User | Leave a Comment »
Posted by jpluimers on 2020/04/02
According to [WayBack] Hightlight active row/column in Excel without using VBA? – Stack Overflow: no, but you do not need much code.
On my list of things to try is to combine both answers there into one.
–jeroen
Posted in Development, Excel, Office, Power User, Software Development | Leave a Comment »
Posted by jpluimers on 2020/03/31
As I need this one day:
To sum based on multiple criteria using OR logic, you can use the SUMIFS function with an array constant. In the example shown, the formula in H6 is:
Source: [WayBack] Excel formula: SUMIFS with multiple criteria and OR logic | Exceljet
–jeroen
Posted in Development, Excel, Office, Office 2011 for Mac, Office 2013, Office 2016, Power User, Software Development | Leave a Comment »
