Locking cells in a Microsoft Excel spreadsheet is among the most commonly used functions. Here’s a guide on how to lock cells in Excel.

You might need to clear all the cells' formats so that they can be interpreted as plain text. Here we tell you how to quickly clear any batch of cells depending on your needs. How to clear formatting ...

This how-to guide will let you know how to freeze cells in Excel, so you can see your headings no matter how big the file is.

Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.