How to Rename Columns or Rows in Google Sheets

If you’re creating a Google Sheets spreadsheet for others to use, you can make it easier to refer to certain sections of data by renaming columns or rows using named ranges. Here’s how.

What Are Named Ranges?

Named ranges allow you to add a custom name to a group of cells, from entire columns or rows to smaller groups of cells. Creating a named range doesn’t overwrite the original cell references (A1, A2, etc.), but it does make it easier to refer to these cells (and the data contained within them) when you’re adding new formulas.

Using the Name Box

The quickest way to add a named range to Google Sheets is to use the name box. This is the box, positioned to the left of the formula bar, that shows you the cell reference for the cell or cells that are currently selected in your spreadsheet. To begin, open your Google Sheets spreadsheet and select a new column or row. With the row or column selected, replace the existing cell reference in the name box with a new name, and then press the Enter key to save your choice.

[mai mult...]

How to Disable the Mic and Camera from Android’s Quick Settings

Android 12 Quick Settings access tiles.

Apple is taking a privacy-focused approach with the iPhone, which has caused Google to take it more seriously. One such privacy feature in Android lets you completely turn off the microphone and camera access from the Android Quick Settings. We’ll show you how.

Introduced in Android 12, the “Privacy Dashboard” gives you an easy way to see which apps are using which permissions and how often. This is great for seeing what’s been accessed in the past, but what about stopping it from happening right now?

[mai mult...]

How to Use the Automatic Data Type Tool in Microsoft Excel

Add details to your Microsoft Excel spreadsheets for cities, foods, music, plants, and more. With the data type tool, there’s no need to open your web browser. When Microsoft implemented its data type tool in Excel, we showed you just how easy it is to use. You could gather geographical data or add stock details to your sheets without scouring the internet. But the tool goes beyond its early stages of a few data types to over a dozen now, including an automatic data detector.

[mai mult...]

How to Call Google Assistant Speakers and Displays in Your Home

You unlock some handy features by having several Google Assistant speakers or smart displays spread throughout your home. One such feature is the option to make audio and video calls between rooms using Nest devices or even your smartphone. You may be familiar with the ability to “broadcast” a message to a Google Nest speaker or display. While this can be useful in certain situations, it can also feel limiting. Sometimes, a two-way conversation is better.

[mai mult...]

How to Reduce (and Disable) Background Noise in Microsoft Teams

During a Microsoft Teams meeting with your colleagues, any background noise can be distracting. The Teams desktop app for Windows 10 provides an option to reduce background noise and helps to keep participants focused on their meeting.

The latest Microsoft Teams desktop app has an AI-based Noise Suppression feature that can reduce outdoor construction noise, the sound of kids playing, or ambient sounds. Let’s take a look at how to reduce background noise in meetings using the Teams app. Before you start, make sure that you’re running the latest version of the Microsoft Teams app on your Windows 10 PC. You can download the latest Teams app from Microsoft’s website.

[mai mult...]

How to Use the LinkedIn Resume Assistant in Microsoft Word

Resumes are important for job seekers but can also be tough to create. If you’d like extra help with which skills to include or how to best write your work experience, check out the LinkedIn Resume Assistant in Microsoft Word.

The Resume Assistant is available to Microsoft 365 subscribers. It’s a feature in Word for Microsoft 365 on both Windows and Mac. You can also use it with Word online using your personal account, but not with a work or school account. The tool is an English language feature.

[mai mult...]

How to Buy Movie Tickets Using Google Assistant

google duplex movie tickets

Buying movie tickets online is much easier than waiting in line at the theater, but what if it could be even better? Thanks to Google’s “Duplex” technology, Assistant can do all the legwork for you. We’ll show you how.

This Duplex feature is available for Android and works with the Google Chrome browser. Google Assistant will launch the ticketing website and guide you through the multi-step process of buying tickets.

[mai mult...]