We select and review products independently. When you purchase through our links we may earn a commission. Learn more.
The Best Tech Newsletter Anywhere

Join 425,000 subscribers and get a daily digest of news, geek trivia, and our feature articles.

How to Lock Formulas in Microsoft Excel

To avoid getting your formulas messed up, you can lock the cells that contain formulas while keeping all other cells unlocked in your Microsoft Excel spreadsheets. We’ll show you how to do just that.

How to Use the FV Function in Excel

If you use Microsoft Excel for keeping track of your money, you might use it for calculating loan amounts or budgeting your finances. To go along with these, you might track your investments too, which means using the FV func…

How to Delete a PivotTable in Microsoft Excel

If you don’t use a specific PivotTable in your spreadsheet anymore, you have two ways to remove the table in Excel. There’s a keyboard method as well as a ribbon menu option to delete PivotTables. Here’s how to use them….

How to Calculate CAGR in Microsoft Excel

To keep track of an investment such as a mutual fund, you likely want to calculate the CAGR (compound annual growth rate). You can do so in Microsoft Excel using the RRI function and it’s much easier than you might think….

How to Sort by Color in Microsoft Excel

Using Microsoft Excel’s sorting feature, you can sort your cells that are either manually colored or conditionally colored by their color. This works for multiple colors and we’ll show you how to implement it in your spreadsh…
How-To Geek is where you turn when you want experts to explain technology. Since we launched in 2006, our articles have been read more than 1 billion times. Want to know more?