If you start an Excel workbook by grouping data into the same cell and later decide to ungroup it, Excel has several easy functions that can split one spreadsheet column into two. Here’s how to use both “Text to Columns” and “Flash Fill.” How to Use “Text to Columns” in Excel Select the cells you want to split by clicking the first cell and dragging down to the last cell in the column....
You may have installed the Google Drive desktop application on your Windows or macOS computer and realize that you don’t use it and no longer need it. You can uninstall it in a few steps on both platforms. If you change your mind down the road, not to worry. You can simply download and reinstall it from the Google Drive Desktop website as you did initially. Uninstall Google Drive on Windows Uninstalling Google Drive on Windows is a three-step process....
How to Update Your Apple Watch Using iPhone Apple Watch updates are linked to the iPhone. For example, to update to watchOS 6 on your Apple Watch, you need to first update your iPhone to iOS 13. First, open the “Settings” app on your iPhone and go to the “General” section. Now tap on the “Software Update” option. Here, if you’re not running the latest version of iOS, tap on “Download and Install....
If you’ve had enough of loading up an entire power strip with cellphone, tablet, and gadget chargers, we’ve got a space saving solution for you. Read on as we take the tiny-but-power-pushing Bolt for a spin and keep our devices charged up without the clutter. What Is The Bolt? For most of us, it has been a long time since the only portable electronic device we needed to charge was a flip-phone that could go a week on a single charge....
Anyone with a power hungry gadget, let alone a bag bursting with them, can tell you how much energy it takes to keep a modern arsenal of gadgets up and running. Read on as we review the Waka Waka, a combination battery pack and solar charger that ensures you’ll have ample and free power wherever you roam. What Is The Waka Waka? The Waka Waka is a combination battery pack, solar charger, and emergency/task light designed for use both in urban/suburban settings as well as off the grid to provide power solar power for small to mid-size devices as well as a portable source of light....
There is no doubt that valid Product Keys are a valuable commodity and need to be carefully guarded from theft. With that in mind, why is the Product ID so visible to one and all? Does this put your Product Key at risk? Today’s SuperUser Q&A post has the answers to a worried reader’s questions. Today’s Question & Answer session comes to us courtesy of SuperUser—a subdivision of Stack Exchange, a community-driven grouping of Q&A web sites....
Have you ever wished you could get the “Windows Recovery Console” running for that one maintenance procedure or program you want to use, without having to remember where you’ve forgotten the CD? HTG explains how to boot WinPE from PXE. Photo Credit: Alfred Hermida via Compfight cc Windows Pre-execution environment (WinPE) is the version of windows that most people know as the one that boots off of the install CD....
But cord-cutting has increased dramatically in recent years, with people ditching their cable bills in favor of a select lineup of streaming subscriptions. Physical media is also becoming scarcer, and more geared toward collectors and cinephiles. If you want to keep up with movies and TV now, you need to subscribe to one or more streaming services. No single streaming service can offer every popular movie and TV show. Still, the best services offer a mix of popular, high-profile exclusives and familiar content from existing movie and TV libraries....
Studio Ghibli has created some of the best animated movies, and now, they’re finally available on HBO Max. The studio’s adorable films transport you to unique worlds. These are 10 of its best you can stream on the service right now. My Neighbor Totoro Play Video My Neighbor Totoro follows Satsuki and Mei after they move in with their father, who lives in the country. Little do they know that tucked away in the nearby woods is a place full of strange, yet wonderful, creatures....
Every piece of hardware on your local network has a MAC address in addition to the IP address assigned to it by the local router or server. What exactly is that MAC address for? Today’s Question & Answer session comes to us courtesy of SuperUser—a subdivision of Stack Exchange, a community-driven grouping of Q&A web sites. The Question SuperUser reader Vishnu Vivek is curious about MAC addresses and their function:...
Ubuntu provides four different software repositories, all of them official — Main, Restricted, Universe, and Multiverse. Main and Restricted are fully supported by Canonical, while Universe and Multiverse don’t receive the support you might expect. On older versions of Ubuntu, only the Main and Restricted repositories were enabled by default. Ubuntu desktop systems now come with all four repositories enabled by default. Main – Officially Supported, Open-Source Software RELATED: How Software Installation & Package Managers Work On Linux...
It has now been over a year since Windows 8 was released. A lot has happened — we’re now on Windows 8.1 and new devices running Intel’s Haswell and Bay Trail chips are coming out every day. Touch-enabled laptops, convertibles, and Windows tablets are getting cheaper and more common. Head to the store to buy a new laptop or tablet and you’ll see a wide variety of new touch-enabled laptops and tablets running Windows....
If you want to master the Bash shell on Linux, macOS, or another UNIX-like system, special characters (like ~, *, |, and >) are critical. We’ll help you unravel these cryptic Linux command sequences and become a hero of hieroglyphics. What Are Special Characters? There are a set of characters the Bash shell treats in two different ways. When you type them at the shell, they act as instructions or commands and tell the shell to perform a certain function....
The Enhanced Mitigation Experience Toolkit is Microsoft’s best-kept security secret. It’s easy to install EMET and quickly secure many popular applications, but there’s a lot more you can do with EMET. EMET won’t pop up and ask you questions, so it’s a set-it-and-forget-it solution once you set it up. Here’s how to secure more applications with EMET and fix them if they break. Know If EMET is Breaking an Application RELATED: Quickly Secure Your Computer With Microsoft’s Enhanced Mitigation Experience Toolkit (EMET)...
SteamOS, Valve’s living room PC gaming operating system, is basically just a new Linux distribution. It’s based on Debian and provides easy access to a standard Linux desktop complete with a package manager. Google’s Chrome OS is based on Linux but can’t run Linux desktop applications without enabling developer mode. Valve’s SteamOS is much closer to the traditional Linux desktop Linux geeks have used for years. We don’t recommend attempting to install SteamOS just yet....
The Windows Subsystem for Android is a feature in Windows 11 for running Android applications and games on your PC. Microsoft has rolled out many improvements since launch, and now another update is in the works. Microsoft has released an update to the Windows Subsystem for Android to everyone in the Windows Insider program. There aren’t any significant new features this time around, like the update from Android 11 to 12....
There are lots of tools that can be used to automate various tasks on your computer, and we have looked at how the likes of Wappwolf and IFTTT can help to automate your online life. AutomateIt brings very much the same idea to Android, making it possible to automate your phone or tablet in a variety of ways. AutomateIt can be used to simplify tasks you perform every day, help to save battery, speed up common activities, and generally make life easier....
Hard Drives: every computer running Windows has them and none can function without them. They house all our data, so we should set them up correctly. Read on to learn more about how to use RAID to protect your data. Be sure to check out the other articles in the series (so far) Introducing How-To Geek School Upgrades and Migrations Configuring Devices MBR vs GPT Ever since I can remember computers have been using disks formatted with the MBR (Master Boot Record) layout, but recently larger disks have started to implement a newer format called GPT (GUID Partition Table)....
A few weeks ago, The Geek showed you how you can use the command prompt to find when your computer was started up last. In this last installation of Geek School for PowerShell, we are going to write a reusable PowerShell command to do the same thing. Be sure to read the previous articles in the series: Learn How to Automate Windows with PowerShell Learning to Use Cmdlets in PowerShell Learning How to Use Objects in PowerShell Learning Formatting, Filtering and Comparing in PowerShell Learn to Use Remoting in PowerShell Using PowerShell to Get Computer Information Working with Collections in PowerShell Learn How to Use Jobs in PowerShell Learn How to Extend PowerShell Learning PowerShell Variables, Input and Output...
Recently we took a look at how you can take Gmail further by enabling some of the extra features that are available in the experimental Labs section. If you use Google Calendar to manage your schedule, there are numerous tools and options that can be added through the use of Calendar-specific Labs. Today, we will take a look to see just what’s available. Just as with Gmail, Google Calendar Labs can be accessed through Settings....
