richardker.com
Everything Technology.
How to Highlight Duplicate Values in Excel 2007
14 Nov 2009Microsoft Office 2007 provides a lot of new functions to analyse data in a spreadsheet. One particular useful function is that you can quickly find and highlight duplicate values in a column.
1. Highlight the column on which you would like to find duplicate values.
2. Go to the Home tab and select Conditional Formatting.
3. Click Highlight Cells Rules > Duplicate Values. Duplicate values will be highlighted immediately.
- Tags: Excel 2007
Comment Form
About this site
RichardKer.com is a China based IT Solutions Provider that specialises on Web 2.0 development using WordPress, technology consulting, technical support and other IT related solutions for small, medium and large enterprises.
Photostream
Categories
- Automotive (1)
- Call Centre (3)
- China News (9)
- Computing (7)
- Gadgets (10)
- Apple iPod (1)
- Helpdesk (17)
- IT Services (21)
- Microsoft Office (5)
- Outsourcing (1)
- Pinnacle Gradebook (1)
- Practical Solutions (24)
- Recruitment (2)
- Repairs (1)
- WordPress (4)
- admin: I'm using Symantec Endpoint Protection and it seems OK See what other people say: http://www.mywot. [...]
- Chris Crook: I tried to install it, but COMODO firewall flags it as malware. [...]
- Seo Silvershine Company: check WordPress is developed using open source with a strong development base resource [...]
- Paul: Thanks a lot! [...]
- austinannie: Thank you!!!!!!!!!!!!! [...]
- How to Extract Embedded Images in Word 2007 with 6 Clicks
- Email Attachments in Body instead of in Attachment Line
- Pinnacle Grade: Easy Way to Default Homeroom Class as the First Tab
- How to Add Footnote in Word 2007
- WordPress and Blog Address Fix
- How to Open ASUS Essentio CS5111 Casing
- Free VPN Service
- How to Combine and Merge Multiple Documents in Microsoft Office Word 2007
- Gmail: How to Insert Images into Email Body
- Viewing Beijing’s Vehicle Traffic via Google Maps