To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.
You can remove duplicates in Excel in a few steps. Duplicates can create problems when you're dealing with data.
While INFO tells you about your Excel environment, CELL digs into individual cells and returns details about their formatting ...