If Excel is not highlighting cells in the formula, enable 'Allow editing directly in cells' and 'Enable fill handle and cell drag-and-drop' in Excel options.

If you cannot insert, add or create new cells in worksheets in Microsoft Excel, remove cell protection and unmerge the Rows to begin with.

1. How to highlight blank cells in Excel Blank cells are easy to miss if you’re working with a lot of data, so you might want to highlight them. The best way to do so is with a conditional format.

Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don't want to change the cell references.

However, Excel's random number functions are volatile, meaning they change constantly. In this article, I'll show you how to generate and fix random numbers and remove duplicates.

In this guide, you’ll learn how to stop Excel from calculating blank cells as zeros by creating efficient, reusable solutions that differentiate between actual zeros and blank cells.