Working with messy and huge data is problematic as has to focus on active cell being active cell is not so visible in congested data. Highlighting active cell trick is time and energy saver and decreases chances of mistakes while working with huge amount of data.

For more awesome and useful ms excel and ms word relating tutorials please visit and subscribe out channel "Microsoft Office Tutorials" at
   / microsoftofficetutorials  

Also follow us on our Facebook pages as below,

Excel Expert
  / excelxpert  

MS Word Basic to Advance Level
  / mswordbasictoadvance  

Microsoft Office Tutorials
  / msofficetutorials  

Here are some links to awesome ms excel tutorials

Highlight Duplicate Rows in Excel (Compare Data in Excel)
   • Highlight Duplicate Rows in Excel (Co...  

How to find Duplicates in excel (2 Methods)
   • How to find Duplicates in excel (2 Me...  

SUM, SUMIF and SUMIFs Excel (Tutorial and Comparison of Functions)
   • SUM, SUMIF and SUMIFs Excel (Tutorial...