I was looking for a quick way to blur out sensitive information in a screenshot using Preview on a Mac. While I didn’t find an actual blur tool, something can can accomplish the same thing is simply drawing a box around the area you want to hide and pressing delete – see screenshot below where my Access Key ID is whited out:
This seems to only work in image files, not pdfs.
Ever want to know how to switch the cursor from one column to the next in Microsoft Word? Simple, the keyboard shortcut is:
For some reason, on a Mac using Parallels Desktop to run Word and Visio in Windows, I cannot right click on an embedded Visio flowchart to open it in Visio. Usually, when you right click on an embedded Visio chart, you get the “Visio object” option, which includes an option to “edit”. But mine doesn’t have that option!!
However, I figured out that a simple keyboard shortcut can let you open the Visio for editing.
In Word running in Windows, use
alt+double click (or
option+double click) to open the embedded Visio chart in Visio for editing. When you hold down the
alt/option key while double clicking on the embedded flowchart, it will open in Visio. Sweet!
Simple, yet hidden!
So in Excel, the COUNTIF function is very useful. However, I couldn’t figure out how to just use COUNTIF to only count cells if another cell is greater than 0. So here is how you do it:
=COUNTIF(Y12,">=" & $Z$3)
Basically, put your operator in quotes, then use the ampersand, followed by the cell that you want to compare to. Simple!
Surprisingly (or maybe not), I found it hard to figure out how to make a meeting attendee optional in Outlook. It is annoying that Microsoft chose to make the Office for Mac versions different enough from their Windows versions to cause confusion. But, in any case, here is how to make an attendee optional:
When you are creating a new meeting, hit the scheduling button at the top to bring up the schedule view. The list of attendees will appear on the left. Click on the little arrow beside a person’s name to adjust their status between Required, Optional, or Resource. (I believe Required is default)
Not too difficult, but also not intuitive. Personally I’ve found Outlook so hard to deal with that I’ve switched to Mail, but I have found it not ideal either, and I with Calendar was integrated with Mail, as its annoying to switch between apps. If anyone has a wonderful email/calendar solution on Mac, please let me know!
I had no idea that you can make your dock icons transparent when you hide an app. In fact, I didn’t even know you can ‘hide’ apps….I always just either used ‘alt+tab’ to switch between apps, or minimized them. So I learned something!
To make your hidden app icons turn translucent in the Dock, all it takes is a simple Terminal command:
defaults write com.apple.Dock showhidden -bool YES
Then, you need to restart the Dock, which you can do using
To reverse this setting, simple run “No” instead of yes
defaults write com.apple.Dock showhidden -bool NO
Oh, and also the keyboard shortcut for hiding an app is “cmd+H”
Seems simple enough, right? Well its counter-intuitive, as is often the case with Microsoft.
If you want to copy/paste text while keeping the tracking changes in Word, then the secret is you need to actually have Tracked Changes turned OFF in both documents. As I said, counter-intuitive, but simple, right?