Select the range of cells in which you want to enter the same data. Type the data. The entry appears in the first selected cell. Press "Ctrl-Enter" on the keyboard. Excel fills the other cells in ...

For these purposes, Excel has the "multi-click" feature, which means you can take advantage of highlighting multiple rows in the same process it would take to highlight a single one.

Learn how to highlight cells with negative values in Excel. Make negative numbers stand out in Red using Conditional or Custom Formatting.

How to highlight values Excel has a built-in conditional rule that highlights unique values. You don’t have to come up with a special formula—you just run though a few clicks.

If you want duplicate values to stand out in an Excel spreadsheet, you can choose between two conditional formatting rules.

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.