To highlight entire rows with conditional formatting when a value meets specific criteria. To highlight intersecting row(s) and column(s) with conditional formatting based on exact matching, you can use a simple formula based on mixed references and the OR function. Download 200+ Excel Shortcuts. Get over 200 Excel shortcuts for Windows.
![Word Word](https://searchenginewatch.com/wp-content/uploads/2018/10/add-delete-rows-6-sm-370x229.gif)
![Excel shortcut for highlighting row in word Excel shortcut for highlighting row in word](/uploads/1/2/5/4/125489891/334577308.png)
Selecting Column(s) or Row(s) Using Keyboard Shortcuts in Microsoft Excel While preparing reports and dashboard in MS Excel keyboard shortcuts, its time-consuming to select the entire column using the mouse. These excel shortcuts is useful to save time and help you do your work faster using the keyboard shortcut keys. How to select row with the Excel shortcut?