How-To Geek

Excel has hundreds of functions, and nobody needs to know them all. But a few are worth keeping in your back pocket because they save you headaches as your data changes. TRIMRANGE is a great example. When you build a spreadsheet that's going to grow, you usually leave room for data you haven't entered yet. Those empty cells can turn dynamic array results into a mess, but TRIMRANGE quietly trims the blank edges off a range and keeps things tidy.

I use Android Auto almost every day, and a few things about it drive me absolutely nuts. My wireless connection drops out, message notifications interrupt my music, Gemini struggles with commands, and some apps I want aren’t even on the launcher.

Terminal-based apps are awesome, but if you’ve ever tried to use them, you’re probably already aware of their biggest annoyance: you have to open a terminal and type a command every time. They don’t show up in your dock or app launcher the way regular desktop apps do. Thankfully, there’s a quick and easy fix for that. It’ll hardly take a few minutes, and you’ll be able to give your terminal apps their own icons and entries in your application launcher.

Hot on the heels of Apple’s HomeView launch, Amazon has unveiled a massive 16-inch Echo Show and updated the Echo Studio with a built-in camera. Both devices are worth your attention as they aim to make Alexa more useful around the home, whether you want to manage connected gadgets, monitor your living room, or keep your daily schedule organized. The new Echo Studio and Echo Show lean on the latest Alexa with natural conversations and the ability to handle complex, multistep requests.

A rainy weekend stuck indoors is the perfect excuse to put your 3D printer to work on the house itself. While it hums along, you can line up new cabinet pulls without eyeballing them, replace that broken clip nobody sells anymore, and finally get the junk drawer under control. None of these projects need a garage full of tools, and by Sunday night something in your home will actually work better than it did on Friday.

My RTX 3080 now spends most of its life switched off, and that’s exactly how I want it. For years, I’ve wanted my mini PC to game like a desktop without bringing back a desktop’s heat, noise, and footprint, and USB4 finally makes that practical. Ugreen’s LinkStation eGPU Dock puts a full-size graphics card on the end of a single cable, and after a few weeks of plugging it in only when it’s time to play, it’s become my favorite PC gaming accessory.

If your favorite green tool is broken or no longer works the way it should, don't toss it out and drop a bunch of cash on a replacement. A cheap spare part might be all you need, and you don't have to scroll through eBay to find it. Did you know Ryobi has a website where you can buy spare parts and accessories?

Adobe Creative Cloud offers some of the best applications for creative jobs. The only drawback? You have to pay up to $70 a month—or about $840 per year—to access them. There are first-year promotions available, but even those add up to about $740 per year. That is a big commitment, especially considering the annual subscriptions come with hefty early termination fees.

There's a common thing that happens with tech enthusiasts where, instead of being a means to an end, the actual technology becomes their hobby.

Most people only ever plug a charger into the USB-C port on their iPhone, but the interface is compatible with so many more devices. These can help you work or play, circumvent limitations, and get more done when you’re away from a “proper” computer.

Motion sensors are popular smart home devices. They're relatively cheap and simple to set up, but often people only use them for basic automations such as turning on the lights when you walk into a room. With the right automations, there's a lot more you can do using motion sensors.

Flathub spent five months refusing AI-generated apps, but sadly gave in to the inevitable reality of vibecoded apps. And while I'm personally not against vibecoding in general (and I've even vibecoded some stuff), I'm still very careful about what I install on my PC—and a lot of lazy slop is going to start flowing into Flathub.

Computers have improved drastically year over year. With these changes, we've also lost some things along the way. Many of them are just legacy connectors and features that we honestly don't have much use for in mainstream PCs in 2026, like bulky parallel ports or floppy disk drives.

Most of us download and install new apps and self-hosted services without a second thought, but if you do anything important on your PC, it can be a significant security risk.

Google rolled out a healthy helping of updates to Android Auto recently, breathing delightfully fresh air into a stale OS. Gemini Intelligence was the highlight of this update, porting agentic AI capabilities over to compatible cars. Gemini can read your messages, emails, and more, give you context in natural language, and basically let you do almost everything you can on your smartphone with Gemini. While Gemini on the go is certainly the star of the show, you might have missed a slightly older announcement from May 2026 that also included plenty of other interesting features.

3D printing can be fun, practical, and all-consuming. It can also be incredibly annoying, both to deal with and on a higher level. Here are some things that really irk me about this hobby, and I bet they annoy you too.

Overpriced home appliances with lackluster smarts are a pet peeve of mine. I’d never upgrade a perfectly functioning fridge or dishwasher just to get access to half-baked smart features, and I’d choose value or performance over features I don’t need, or that might backfire on me down the line.

I’ve always been a Samsung fangirl, so it’s not like I needed convincing to love its phones. But One UI 9 has given me a few more reasons to appreciate them. I love exploring my Galaxy’s settings, and One UI 9 has a few new features that could save me an extra 10 minutes a day to enjoy my evening walk instead of fiddling with my phone. Here are five One UI 9 features that got me excited about Samsung phones all over again.

When smart speakers first burst onto the scene, it felt like this would be the way we would all be controlling our smart homes in the future. That future never really became a reality, as smart speakers haven't really improved much over the years. It's reached the point now where your old phone or a DIY smart speaker can do a better job.

Reboots and revivals have a bit of a reputation for being unnecessary cash grabs, but every now and then, a familiar series gets a second life that proves there's still plenty of value in revisiting an old favorite. Netflix has had its fair share of successful revivals, bringing back beloved franchises for the longtime fans and a new generation. From nostalgic sequels to fresh takes on classic shows, some of these reboots have managed to capture what made the originals so special.