tag:blogger.com,1999:blog-7826720847639113939.post4823939996981853947..comments2024-03-24T14:34:25.522-07:00Comments on Excel Spreadsheets Help: How do I highlight duplicate rows in Excel without deleting them?Nickhttp://www.blogger.com/profile/15585454339530843458noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-7826720847639113939.post-2222869078866226572013-04-23T09:23:19.827-07:002013-04-23T09:23:19.827-07:00What a great tip!What a great tip!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7826720847639113939.post-92071497806596137602013-01-26T02:22:59.939-08:002013-01-26T02:22:59.939-08:00This is really very nice information you share her...This is really very nice information you share here. Delete duplicate function is really good to used for all excel users to highlight all duplicate data in excel spreadsheet without delete them. This function works really good and makes easy way to delete all duplicate data in excel spreadsheet. <br /><br /><a href="http://www.creativementor.com.au/microsoft-excel-training.html" rel="nofollow">excel training</a>in melbourneAnonymoushttps://www.blogger.com/profile/00802221952263854704noreply@blogger.comtag:blogger.com,1999:blog-7826720847639113939.post-1307087908236302922013-01-21T09:09:30.955-08:002013-01-21T09:09:30.955-08:00This is exactly what I was needing to do. And whe...This is exactly what I was needing to do. And when I was done I just did a control Z to remove the highlights. Thanks so much Vira Av for this easy alternate method.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7826720847639113939.post-75557724297142467032012-10-24T17:42:28.716-07:002012-10-24T17:42:28.716-07:00Is there a way to undo the Conditional formatting ...Is there a way to undo the Conditional formatting when you are done?<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7826720847639113939.post-1598871536439946952012-07-25T17:29:35.843-07:002012-07-25T17:29:35.843-07:00No problem! Glad I could help. Sign up for our ema...No problem! Glad I could help. Sign up for our email newsletter for more tips.Nickhttps://www.blogger.com/profile/15585454339530843458noreply@blogger.comtag:blogger.com,1999:blog-7826720847639113939.post-18502099734654881212012-07-25T17:27:12.009-07:002012-07-25T17:27:12.009-07:00This is great! Thanks!!!This is great! Thanks!!!Dissociated Mindhttps://www.blogger.com/profile/05124441624279749086noreply@blogger.comtag:blogger.com,1999:blog-7826720847639113939.post-43887044368418199192012-04-19T10:21:36.446-07:002012-04-19T10:21:36.446-07:00Yay! thank you!Yay! thank you!DuCharrishttps://www.blogger.com/profile/10572731219091422601noreply@blogger.comtag:blogger.com,1999:blog-7826720847639113939.post-35268507407594744762012-03-19T08:22:17.063-07:002012-03-19T08:22:17.063-07:00The problem with this is that it will only highlig...The problem with this is that it will only highlight the duplicate cells, not the entire rowDanMcQhttps://www.blogger.com/profile/05720852290379689817noreply@blogger.comtag:blogger.com,1999:blog-7826720847639113939.post-73123371393768913412012-03-13T20:37:02.471-07:002012-03-13T20:37:02.471-07:00no you don't have to use macro. first block th...no you don't have to use macro. first block the cells where you want to find out the duplicate values. and then from column Styles in "Home", you select Conditional Formatting, then choose Highlight Cells Rules --> Duplicate values. there you go :)Vira Avhttps://www.blogger.com/profile/12886670335071843048noreply@blogger.comtag:blogger.com,1999:blog-7826720847639113939.post-26813255977234539062011-10-27T18:53:51.106-07:002011-10-27T18:53:51.106-07:00Why not? Are you getting an error message?Why not? Are you getting an error message?Nickhttps://www.blogger.com/profile/15585454339530843458noreply@blogger.comtag:blogger.com,1999:blog-7826720847639113939.post-20184116697061063782011-10-26T10:28:19.206-07:002011-10-26T10:28:19.206-07:00Sorry...didn't work for me.Sorry...didn't work for me.Jocelynhttps://www.blogger.com/profile/13644394300503862218noreply@blogger.com