Apple routinely releases watchOS updates with new features and watch faces. watchOS 6, for example, comes with a new App Store app and awesome new analog watch faces. Here’s how you can update your Apple Watch.
[mai mult...]
How to Count Data Matching Set Criteria in Google Sheets
The COUNTIF function in Google Sheets lets you analyze data in your spreadsheet and returns the number of times it appears in your document if it meets a set of specific criteria. Here’s how to use it.
[mai mult...]How to Connect Your Android Device to a Projector
Android devices are great, but their small size can sometimes be limiting. When you connect your device to a projector, you can share your screen with others for business or pleasure. Here are a few ways to do it.
If you don’t have a projector, you can also connect Android to a TV. Projectors are the better option, though, as they normally project a much bigger screen size than a TV, making them ideal for media playback or data presentations.
[mai mult...]How to Assign Tasks in Google Drive
When collaborating on files in Google Drive (Docs, Sheets, and Slides), it’s easy to lose sight of who’s working on specific parts of a project. With Google Drive, you can assign tasks to another collaborator on your team.
Fire up Google Drive and open a file you currently collaborate on with other people.
[mai mult...]How to Change the Default Shell to Bash on macOS Catalina
With macOS Catalina, Apple is now using Zsh as the default shell. We love Zsh, but the trusty old Bash shell is still included with macOS, and you can quickly switch back to Bash if you prefer.
Zsh is only the default shell on newly created user accounts, so any existing accounts you have on an upgraded Mac will still use Bash by default unless you change it. Each user account has its own default shell preference.
[mai mult...]How to Mute Mail Threads on iPhone, iPad, and Mac
There’s no way to leave email conversations if someone accidentally hits the “Reply All” button. What you can do is mute the conversation on your end to disable notifications. Here’s how to mute threads on your iPhone, iPad, or Mac using the Mail app.
[mai mult...]Filter Google Sheets Data without Changing What Collaborators See
Filters in Google Sheets let you analyze data in your document by showing only the things you want. However, it changes how others see the document, too. Here’s how to use filter views to leave each collaborator’s view unchanged.
[mai mult...]How to Stop Selfies From Appearing in the iPhone’s Selfies Album
The Photos app on your iPhone automatically populates all photos from the front-facing camera in the Selfies album. But what if you don’t want a photo to appear there? Here are a couple of solutions.
[mai mult...]How to Edit Files and Images Using Quick Look on Mac
Quick Look on Mac is an incredibly useful way to preview a file without completely opening it. In macOS Mojave and above, you can perform quick edits on files in the Quick Look popup without needing to open a third-party app.
[mai mult...]All the Best Google Sheets Keyboard Shortcuts
No one likes to do things the hard way, which is why we have keyboard shortcuts! We’re going to look at the shortcuts you can use in Google Sheets to save yourself some time.
By no means is this a complete list of all keyboard shortcuts available in Google Sheets. We’ve limited our list to those that are more generally useful. There are plenty more you can explore if you can’t find what you’re looking for in this guide.
To open a list of keyboard shortcuts in Google Sheets, press Ctrl + / (Windows and Chrome OS), Cmd + / (macOS) If you want to see the complete list, check out the Google Sheets support page.
[mai mult...]