Category: Troubleshooting

Google Sheets can be used to highlight duplicates in a spreadsheet. How the repeats are displayed is fully customizable in the formatting style options. This can be used to represent specific reasons for why a duplicate was highlighted so it makes sense to anyone looking at the data. For instance, you can highlight the entire row of a given column containing any duplicates. Or, alternatively, it can also be formatted to simply highlight any cell with a value that appears more than once in the spreadsheet. Continue reading →

Are you getting the following error when trying to login to the MySQL root on an Ubuntu system? We’ll show you how to clear it up in a matter of seconds.
Continue reading →

Cloning a MySQL table involves two separate commands. One command will duplicate the columns and structure to a new table, and the other command will copy over the data and indexes.
Continue reading →

If you’ve ever had your internet disconnect in the middle of streaming your screen or game on Discord, there’s a simple option buried in Discord’s settings that may solve your problem. For some reason, a setting where Discord admits “some routers or internet service providers may misbehave when this is set” is enabled by default. In this guide, we’ll show you how to turn it off.
Continue reading →

The touchpad on your laptop tends to just get in the way once you have a mouse plugged in. If you keep hitting it accidentally while using your keyboard, there is a way to counter the annoyance by disabling the trackpad.
Continue reading →

The windows key on your keyboard is easy to hit accidentally when playing a full screen game. If you are sick of unintentionally minimizing your game, there’s a simple fix you can apply to disable your windows key.
Continue reading →