Useful Hacks, Reviews, Tips and Tricks of anything under the moon and the sun.

How To Add Progress Bars In Excel

Progress bars are great graphical representation of project statuses. I use it on my spreadsheet to quickly show to my user the current progress of the tasks/projects at hand. In Excel, adding progress bar is as easy as 1-2-3. Here's how:

1. On the cell where you want to put the progress bar, enter a numeric value. For example, 95 which is equivalent to 95% out of 100%.

2. Click on the Conditional Formatting > Data Bars > More Rules as shown below.

How To Add Progress Bars In Excel

3. Under New Formatting Rule, select "Format all cells based on their values". Choose "Data Bar" as the format style and Select Number as type of the shortest and longest bar. Lastly select the bar color and click Ok.

This should give you a nice looking progress bar :)