When you have a Google Sheets spreadsheet full of data, it can be difficult to see certain cells at a glance. If you have empty cells where you expect data or errors generated from formulas, you can automatically highlight them. Google Sheets offers useful features to make data entry and analysis easier. One such feature is conditional formatting. With it, you can configure your cells to contain a fill color or specific font style, color, or format when conditions like blanks or errors occur.
[mai mult...]How to Lock an Image’s Position in Google Docs
Laying out a document with both text and images can sometimes be a challenge. To make this task a bit easier, you can lock an image into a fixed position in Google Docs. You can choose a spot for the image, adjust it relative to the top left of the page, or pick a quick layout. So when you add, delete, or move text, the image will stay exactly where you want it.
[mai mult...]How to Get the Word Count of Your PowerPoint Presentation
Knowing the word count of your Microsoft PowerPoint presentation and speaker notes can give you a rough idea of how long it may take to present the slideshow and where you may need to cut back. Here’s how to find out. You can get the word count of your PowerPoint notes and slides—or just the speaker notes—on both Windows 10 and Mac. Unfortunately, you can’t currently get the word count on PowerPoint for the web.
[mai mult...]How to Use the LEN Function in Microsoft Excel
If you’ve ever wanted to try and find the number of characters in a line of text, you can use Microsoft Excel to do so, thanks to the LEN function. Here’s how to use it.
What Is the LEN Function?
The LEN function is a simple calculation function that counts all the characters in a given text string, including numbers, letters, special characters, and spaces. The function name (LEN) is shorthand for length, as the function output provides the total length of a text string as a number.
To give you an example, let’s assume that an Excel workbook contains a cell with the following text:
This is an example text string containing 56 characters!
The text string contains spaces, text, numbers, and a special character, and has a length of 56 characters. Should you wish to confirm this calculation, you could use LEN to do so.
[mai mult...]How to Add a Status Message in Microsoft Teams
Now that Microsoft Teams seems to have taken over many companies, people expect to know when you’re available or not. Set a custom status message so your colleagues know what you’re up to.
[mai mult...]How to Change the Measurement Unit in Microsoft PowerPoint
Most of the world uses the Metric system, whereas the U.S. still uses the Imperial system of measurement. Depending on what you are used to, you may want to change the measurement unit in Microsoft PowerPoint. Here’s how.
While there’s a built-in option for changing the measurement unit in Microsoft Word, that’s not the case for PowerPoint. Microsoft PowerPoint actually uses the system of measurement that the computer it’s installed on uses, which means that you need to adjust your computer’s system settings—not PowerPoint’s.
[mai mult...]How to See When Apps Access Your Camera and Microphone on Android
Privacy is a big topic when it comes to mobile devices. iPhones and iPads show little orange and green indicator icons when apps access the device’s camera or microphone. Here’s an Android app that can do the same. Like the LED light on a webcam, the iPhone and iPad show colored dots in the status bar when an app is accessing the camera or microphone. Android shows when apps are accessing your location, but it lacks these indicators.
The app we’ll be using to bring this functionality over to Android is called “Access Dots.” It mimics the colored dots that are present on iPhone and iPad. The app is easy to set up and gives you more information about what apps are doing in the background.
[mai mult...]How to Charge Your Apple Pencil
Apple offers two different generations of Apple Pencil, which are compatible with different iPads. As both are battery powered, they are inevitably going to run out of juice. Here’s how to charge and check the battery percentage of your Apple Pencil.
[mai mult...]How to Check Which Websites Are Tracking You on Safari
Safari prevents advertiser’s trackers from following you all over the web. It can also tell you which websites tried to collect data on you, and how many it’s blocked. Here’s how to generate your privacy report on Safari.
[mai mult...]How to Uninstall Windows 10’s October 2020 Update
As usual, Microsoft is slowly rolling out Windows 10’s October 2020 Update (20H2) to check for bugs. If your PC experiences a problem after installing the update, here’s how to roll back to your previous version of Windows 10.
You Only Have 10 Days!
Windows 10 only gives you ten days to uninstall big updates like the October 2020 Update. It does this by keeping the operating system files from the previous version of Windows 10 around. When you uninstall the update, Windows 10 will go back to whatever your previous system was running. This will probably be the May 2020 Update.
These old operating system files take up gigabytes of space. So, after ten days, Windows will automatically remove them. This saves disk space but prevents you from rolling back without reinstalling Windows 10 from scratch.
[mai mult...]