 To create a progress bar in Excel, let's use the repeat formula. Type equal sign R-E-P-T, then inside a closed parentheses type the vertical line symbol between quotation marks followed by a comma. Now click the cell with the number signifying how many times the symbol will be repeated. The clicked will connect that number to the repeat formula. Then press enter. Now let's style it by changing the font to the stencil font and also let's change the font color. Finally, drag the formula to the rows you want to apply the progress bar to and that's it. Increase your personal productivity by subscribing to our burned and earned channel.