Instead of manually entering in numbers, you can generate random numbers in Excel to automate the process. Excel has two built-in functions, RAND and RANDBETWEEN, which populate cells with randomly […]
Excel
How to Unprotect Excel Sheet Without Password
Excel sheets and workbooks are usually protected to prevent unwanted changes to the document. The sheet protection feature allows people to view the sheet, but not make changes to it […]
How to 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 […]
How to 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 […]
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 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 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 Disable Read Only in Excel
In order to protect the data contained within Excel documents, a lot of people make the document read only. When trying to edit a read only Excel worksheet you will […]
How to Delete Blank Rows in Excel
Some people prefer having a dataset with blank spaces, but others absolutely detest it. Instead of manually finding and deleting each blank row, you can have Excel do the hard […]