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...]How to Work with Trendlines in Microsoft Excel Charts
You can add a trendline to a chart in Excel to show the general pattern of data over time. You can also extend trendlines to forecast future data. Excel makes it easy to do all of this.
A trendline (or line of best fit) is a straight or curved line which visualizes the general direction of the values. They’re typically used to show a trend over time.
In this article, we’ll cover how to add different trendlines, format them, and extend them for future data.
How to Leave an iOS or iPadOS Public Beta Program
Apple now makes it easy to install iOS betas using over-the-air updates. While simple to install, iOS Public Betas can be buggy as well. Fortunately, you can leave the iOS Public Beta at any time.
[mai mult...]How to Create a Website Contact Form With Google Forms
Google Forms is a powerful tool used to create free surveys and quizzes online. However, that’s not all it does. With this guide, you can create a contact form which can be embedded directly into your website.
Creating a contact form on Google Forms is super simple. Google even has a template already made for you to use, which makes your job that much easier. All you need to do is load the template—customize it if you want—then embed the form directly into your website. That’s all there is to it. Let’s get started.
[mai mult...]How to Switch to Editing Mode in Excel
When opening Excel spreadsheets from unknown sources, a feature in Excel called Protected View shields you from potential risks. This is great, but to work on the document, you will need to switch to editing mode.
[mai mult...]How to Stop Companies From Listening to Your Voice Assistant Recordings
It’s been in the news for weeks: Employees and contractors at Amazon, Google, Apple, and Microsoft are listening to recordings of you talking to voice assistants like Alexa, Google Assistant, Siri, Cortana. Here’s how to stop humans from listening in.
[mai mult...]How to Cross Reference Cells Between Microsoft Excel Spreadsheets
In Microsoft Excel, it’s a common task to refer to cells on other worksheets or even in different Excel files. At first, this can seem a little daunting and confusing, but once you understand how it works, it’s not so hard.
In this article, we’ll look at how to reference another sheet in the same Excel file and how to reference a different Excel file. We’ll also cover things like how to reference a cell range in a function, how to make things simpler with defined names, and how to use VLOOKUP for dynamic references.
[mai mult...]