Posted by jpluimers on 2019/06/28
I hardly print with Excel, so I always forget these two:
–jeroen
Posted in Excel, Office, Office 2011 for Mac, Office 2013, Power User | Leave a Comment »
Posted by jpluimers on 2019/06/10
Via [WayBack] ms office – Keyboard shortcut to select all text in a cell in Excel – Ask Different a few keyboard tips.
Lets start with the shortest one:
Command–Z or Control–Z to undo the changeThis probably is unintended, but works great: all text is now selected, so you can copy/cut with Command-C/Command–X.
Now the “official” way:
Control–U or F2 to edit the cell (the cursor is now at the end)Shift–Alt–Home or Shift–Control–Home (to select all text)Home can also be Fn–Left.Other selections you can make while the cell is in edit mode:
Shift–Alt–End or Shift–Control–End (to select to the end of the cell)End can also be Fn–Right.Shift–Alt–Right or Shift–Control–Right (to select one word to the right)Shift–Alt–Left or Shift–Control–Left (to select one word to the left)Shift–Alt–Down or Shift–Control–Down (to select to the same position on the line below)Shift–Alt–Up or Shift–Control–Up (to select to the same position on the line up)Keyboard symbols (more at [WayBack] Command, Option, & Shift Symbols in Unicode):
⇧ – Shift^ – Control⌥ – Alt which is the same as Option⌘ – CommandFn – Function–jeroen
Posted in Apple, Excel, Mac, Mac OS X / OS X / MacOS, MacBook, MacBook Retina, MacBook-Air, MacBook-Pro, MacMini, macOS 10.12 Sierra, Office, Office 2011 for Mac, Power User | Leave a Comment »
Posted by jpluimers on 2019/06/03
What key combination do I have to press to create a line break in a cell in Excel for Mac 2011? The Windows combination of Alt+Enter does not work on the Mac.
Source: [WayBack] keyboard – How to add a line break in a cell in Excel for Mac – Ask Different
The answer depends on the Excel for Mac OS X version you are using.
Excel 2015 is simple (thanks esham): use Option+Enter.
In older Excel <= 2011 (thanks nwinkler), use Command+Option+Enter or Control+Option+Enter.
Some users report the also need the Fn key in addition to the above modifiers.
–jeroen
PS: Later I found out that [WayBack] Beckism.com: Use a linebreak in Excel on Mac also shows the Excel <= 2011 solution Control+Option+Return (note that Return is the same key as Enter).
Posted in Apple, Excel, Mac, Mac OS X / OS X / MacOS, MacBook, MacBook Retina, MacBook-Air, MacBook-Pro, macOS 10.12 Sierra, Office, Office 2011 for Mac, Power User | Leave a Comment »
Posted by jpluimers on 2019/04/15
Just when I thought I made a note of a password I hardly ever use, I didn’t, luckily this open source tools understands how to recover many kinds of passwords: AlessandroZ/LaZagne: Credentials recovery project.
–jeroen
Posted in *nix, *nix-tools, Chrome, Development, DVCS - Distributed Version Control, Firefox, git, Internet Explorer, Office, Opera, Outlook, Power User, Python, Scripting, Skype, Software Development, Source Code Management, Web Browsers, WiFi, Windows | Leave a Comment »
Posted by jpluimers on 2018/11/12
For a very long time, gMail did nothing with Outlook Calendar entires.
So I had to view at the message source, then translate them to Google Calendar entries myself.
As of late, they seem to be processed into Google Calendar compatible entries. Nice!
–jeroen
Posted in GMail, Google, GoogleCalendar, Office, Outlook, Power User | Leave a Comment »
