(Closed) help! those familiar with excel…

posted 8 years ago in Technology
Post # 3
Member
6394 posts
Bee Keeper
  • Wedding: September 2011

You can just type “1,” “2,” “3” and then highlight those three. Click on the lower right side of the highlighted area and it should give you a + sign, then just click and drag as far down as you want it.

Post # 4
Member
289 posts
Helper bee
  • Wedding: December 2010

There are 2 easy ways to do this!

1. Fill Down – enter 1, 2, 3, in the first three rows, highlight, then put your cursor at the bottom right corner of the bottom cell (it should look like a plus) and drag down.  Or, alternatively, highlight the cells with the 1, 2, 3, and all the ones you want to fill in below and choose Edit > Fill > Down.

2. Formulas – add one to each. (i.e. enter “1” in cell A1, the “=A1+1” in B1, then “B1+1” in in C1, etc…)

Hope that helps!

Post # 6
Member
559 posts
Busy bee
  • Wedding: September 2010

And you might have to right click on the plus sign and choose “fill series” to make sure the numbers are going up

Post # 7
Member
6394 posts
Bee Keeper
  • Wedding: September 2011

@stephanie63087: Any time! I’m really, really familiar with Excel so if you ever need super quick help, feel free to PM me and the notification will go to my cell phone so I can answer pretty quickly. I adore Excel, so I should be able to help with most things! 🙂

Post # 9
Member
6394 posts
Bee Keeper
  • Wedding: September 2011

In a box below the colum, write =SUM( and then highlight everything you want added, and then close the parenthesis. It should look something like =SUM(B1:B9).

The topic ‘help! those familiar with excel…’ is closed to new replies.

Find Amazing Vendors