Excel Guides

Highlighting the Rows of Selected Cells in Excel

When you select cells in Excel, the rows of those cells are automatically highlighted. This makes it easy to see which cells you have selected and helps to prevent accidental deletion or modification of your data. However, if you have a lot of data in your spreadsheet, the highlighting can become distracting. Fortunately, there is a way to turn off row highlighting for selected cells.

To do this, first select the cells that you want to highlight. Then, go to the Home tab and click on the Conditional Formatting button. In the drop-down menu, select Highlight Cell Rules and then choose Duplicate Values. In the Duplicate Values dialog box, make sure that only the formatting is selected and click OK.

Now, when you select cells in your spreadsheet, the rows will no longer be highlighted. This can be a useful setting if you find yourself frequently selecting large groups of cells and want to avoid the distraction of row highlighting.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.