How-To Geek

If you've spent any time working with data in Excel, you've probably come across filtering. It's a quick way to focus on the records you need, analyze a subset of your data, and hide everything else from view. But Excel's regular filter buttons come with a few annoyances: they hide entire worksheet rows, can make the original dataset harder to see, and leave you with filters to clear when you've finished.

I got a new phone for my birthday. And you know what happens next: you start playing around with everything. Relatable enough, right? At first, I was genuinely excited. New phone, new tricks, new excuses to spend way too much time digging through settings.

For years, my dishwasher drove me insane. No matter what settings I changed or how carefully I loaded it, some things always came out far from clean, and I had to wash them myself or run another cycle. The solution I discovered through a truly awesome YouTube video was incredibly simple: I just needed to add a little dishwasher powder.

HDDs are definitely not dead yet, especially since so many PCs and laptops still have them. Because they are so affordable, they still hold value, and people actually purchase them. HDDs are also useful for NAS setups and archiving or backing up data. Some last longer than others based on design and use, yet many can fail for any reason at any time. Velcro is one potential way to help prolong their life, helping you get years of use out of them… and your money's worth.

Android reigns supreme over foldable phones at the moment. It has a lead stretching several years, with a wide range of designs and prices. You can get everything from an affordable flip phone like the Motorola Razr through to three-panel beasts like the Huawei Mate XT2.

Ryobi's 18V ONE+ power tool system is massive, but one thing that's often overlooked is the battery pack. In recent years, the biggest advancement isn't a tool, but the new "EDGE" battery technology that powers them. It's a pack that promises extra power, longer runtime, and more. If you're in the market for a new battery, here's what you need to know and whether it's worth buying.

This week's recommendation roundup for Paramount+ subscribers in the U.S. is a glorious mixed bag. Up top, it features a new addition to starring Russell Crowe that, despite it getting skewered by critics and a 45% on Rotten Tomatoes, remains the No. 1 movie on the service this week. Meanwhile, Joe Dirt, which we wrote about two weeks ago, is still hovering in the top 10.

Are you planning to record some professional audio but don't own a good microphone? Turns out, that old phone you've been keeping in your drawer for years is nearly as good, if not as good, as some of the cheap USB microphones out there. With some setup around your recording space, you can get good audio quality without compromising your wallet.

Excel is usually filed under spreadsheets, yet its formulas and macros can carry software that goes well beyond budgets and pivot tables. From schedulers to games to financial dashboards, these three kinds of programs show how far a workbook can stretch before it needs a separate application.

There was a time when creating automations on your phone required powerful third-party apps with complex tools. Nowadays, most Android phones come with built-in automation features. You can easily set them up without much effort.

Microsoft replaced Battery Saver with Energy Saver in Windows 11 a couple of years ago. The new feature includes an always-on toggle that, if left enabled, can reduce your PC's performance without you even noticing. Combine that with a power mode set to favor efficiency, and your Windows PC might throttle itself even when it's plugged in.

My home network has grown into a small lab with computers, virtual machines, storage devices, and plenty of other things that occasionally decide to behave strangely. When something goes wrong, figuring out what happened can be difficult because the useful information may already be gone by the time I start investigating.

The Apple iPad is an exceptionally long-lived device. There's no reason to upgrade them frequently and in my personal experience these tablets don't show much battery wear over the years either.

Waze is one of the most popular navigation apps, thanks to its excellent live road alerts, traffic avoidance, and crowdsourced hazards and map corrections. If you use Waze for navigation, a few key settings are worth changing for the best experience.

Most people run a speed test the same way you check weight on a scale, as if one number tells the whole story. The number tends to look good, but it is a really narrow way to judge your connection quality. That Wi-Fi speed test has almost nothing to do with how a connection works in real conditions. It's better to know what it is doing before you assume it is correct.

It's a good time to be Guy Ritchie on Netflix. The Brit grit master has got a hit series, The Gentlemen, in its second season that's in the streamer's Top 10. Plus, the movie that series is based on is here, as is the recently added The Ministry of Ungentlemanly Warfare, both of which we have the details on below as part of this week's roundup that is decidedly savage.

For a single unit conversion, Google wins on convenience. But if I have a bunch of measurements to convert, I don't want a scrap of paper covered in random numbers, or to keep copying values out of a spreadsheet and back again. Excel's CONVERT function lets me keep the measurements, units, and results together, while reusing the same formula for as many conversions as I need.

Connecting your Android phone to a new Wi-Fi network is usually something you do without thinking. You find the network, enter the password, and get on with whatever you need an internet connection for. But that quick process can expose you to problems you might not notice until it's too late, especially when you're using networks you don't fully control.

If you've spent any time using the Linux terminal, you've probably used the grep command. It's what you use to quickly find a search term in a file or find all the files containing that term. It's useful, reliable, and fundamental to most terminal workflows. That said, grep is old — more than 50 years old. A lot has changed since then — our computing habits have evolved, and new technologies have emerged.

Are you always throwing out old USB cables? You’re not alone; cables and the ports into which they fit can be frustratingly delicate.