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.

Microsoft Excel’s RANK.EQ () function ranks a set of values, but in a busy sheet, the top-ranking items might get lost. You can combine RANK.EQ () with a conditional formatting rule to highlight ...

Spreadsheet apps like Microsoft Excel and Google Sheets aren't just for tabulating data — they're also designed to make that data and its accompanying labels neat and orderly. While the ...

Do you want to keep important labels and data in view as you scroll through your Excel worksheets? Here are the steps to freezing those columns and rows.