Excel 2013 Lessons

See the FREE ebook in the previous post. There you can find what you are looking for much easier. Soon I will be creating another ebook called Vol. 2 it will be all about Macros or VBA. Enjoy the free book. It’s up to you, but I wouldn’t go to all of the Excel classes posted on Facebook, mainly because they are not free. Your choice though. Have a blessed day.

Try this:
In column A starting in cell A1, or whatever column you want to start in create a set of numbers, in for example, use 10 Rows. Use 1-10. Later you can increase the numbers to meet your needs.
In cell B1 or next to your first numbered cell write this:

=REPT(“I”,A1)

Next click on the little dot in the lower right hand corner of cell B1 and drag down to the last numbered cell that’s on the left, or double click it to add formula to all cells below in column B.

Now in cell B10 if the number to the left is a 10 you will get 10 entries of whatever you have put in the parentheses, for this example I put a capital I. It should look like below:

I
II
III
IIII
IIIII
IIIIII
IIIIIII
IIIIIIII
IIIIIIIII
IIIIIIIIII

Basically you create a simple to edit bar graph. The word REPT is for repetition making your letter, number or word repeat as many times as the number in the reference cell.

Have fun with this by formatting any way you want. 😉

Volume 1 is getting there. 29 Lessons I have created.