{"id":873,"date":"2018-06-30T18:44:56","date_gmt":"2018-06-30T18:44:56","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=873"},"modified":"2024-03-29T13:43:49","modified_gmt":"2024-03-29T13:43:49","slug":"highlight-duplicate-rows","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/highlight-duplicate-rows\/","title":{"rendered":"Highlight Duplicate Rows in Excel"},"content":{"rendered":"\n
Depending on the data you have in your worksheet you may use one of the following ways to highlight duplicate rows.<\/p>\n\n\n\n
The first one is the most basic. Here, we have only one column, so when we highlight a single cell, we also highlight a single row.<\/p>\n\n\n\n