Data in an Excel spreadsheet is usually unorganized, unsorted, and hard to read. There are many techniques to make the data easier to read, such as using filters and sorting […]
How to Add Bullet Points in Excel
Many users are unaware that it is possible to add bullet points in Excel. While Excel does not provide a built-in functionality to do this, there are four workarounds that […]
How to Insert Bullet Points in Google Sheets
While Google Docs makes it easy to add bullets with a menu option, there is no such option to insert bullet points in Google Sheets. Instead, you will need to […]
How to Color Alternate Rows in Excel
To make your data easier to read, you may want to color alternate rows in Excel. Excel provides built in functionality to do this and even alternatively colors newly added […]
How to Color Alternate Rows in Google Sheets
A lot of people choose to color alternate rows of a spreadsheet to make it more readable. Previously color alternating rows in Google Sheets was a lengthy process, however Google […]
How to Fix #REF! Error in Google Sheets
The #REF! error is one of the most annoying formula parse errors in Google Sheets. The error is usually caused by a missing/invalid reference or circular dependency in your formula. […]
How to Fix #DIV/0! Error in Google Sheets
A common error in Google Sheets is #DIV/0!. In this article we will be taking a look at what this error is, what causes the error and how you can […]
How to Freeze Rows in Excel
In Excel, quite often you will want to compare data in completely different areas of your worksheet. Instead of scrolling back and forth between these two areas, you can simply […]
How to Freeze Rows and Columns in Google Sheets
When working with large datasets it becomes difficult to keep track of what each row and column represents as you start scrolling down or rightwards. Luckily you can easily solve […]
How to Remove Editing Restrictions in Word Without Password
Editing restrictions are usually used to prevent unwanted changes to a Word document as they allow people to view the contents of the document but not make any changes. If […]