How to Sort Alphabetically in Google Sheets

Sort Alphabetically in Google Sheets

Once a spreadsheet contains numerous lines of data, it becomes difficult to find what you are looking for. It then becomes important to properly sort the data to ensure it can be read easily. A sorting scheme from A to Z, highest to lowest or vice versa can help make the data easier to interpret. … Read more

How to Sort Multiple Columns Alphabetically in Excel

Sort Multiple Columns Alphabetically in Excel

Reading thousands of lines in an Excel spreadsheet can be an annoying process, especially when the data is unorganized. Luckily, it is very easy to sort multiple columns alphabetically in Excel, allowing you to turn an unorganized spreadsheet into an easily readable one. Sort Multiple Columns Alphabetically in Excel While sorting a single column alphabetically … Read more

How to Sort Alphabetically in Excel

Sort Alphabetically in Excel

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 the data, however one of the best ones is sorting data alphabetically. Luckily, there is a very easy function to sort alphabetically in Excel, while … Read more

How to Add Bullet Points in Excel

Insert 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 enable bulleted lists in an Excel spreadsheet. Add Bullet Points in Excel There are four different methods to add bullet points in Excel: Using a … Read more

How to Insert Bullet Points in Google Sheets

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 make use of some workarounds to get a bulleted list in your spreadsheet. Insert Bullet Points in Google Sheets You can make use of three … Read more

How to Color Alternate Rows in Excel

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 rows. Color Alternate Rows in Excel To use the built in Excel feature, you first need to format your data as a table. 1. Select … Read more

How to Color Alternate Rows in Google Sheets

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 has introduced a new built-in feature that makes the task relatively easy. Color Alternate Rows in Google Sheets We will be changing a plain dataset … Read more

How to Fix #REF! Error in Google Sheets

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. We will take a closer look at exactly what this looks like and how to fix it. Fix #REF! Error in Google Sheets There are … Read more