# Formula for excel

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

#### kiwiguy

Not really enough info, but:

put 1 in a spare cell. Click on that cell and Edit - Copy.

Then highlight all the numbers you want incremented by 1, and Edit - Paste Special - Add

You can delete the contents of the cell that you stored the 1 in, its not referenced.
Be careful though as this will increment all numbers including adding 1 to any formula.

#### wout

A B C D
1 25
2 =(A1+1)
3
4
5
COPY PASTE THE FORMULA TO A3 A4 A5 ETC

#### wout

. A B C D
1 25
2 =(A1+1)
3
4
5

COPY PASTRE THE FORMULA TO A3 , A4 ETC OR B2, B3 B4 ETC

#### itsmeagain

Highlight the start of the series along with the blank cells you wish to fill (in a row or column), then go to Edit, Fill, Series and complete in the appropriate data - linear type and step value of 1 in this case, but it can be non-linear using trend and Excel will intelligently (?) work out the sequence. You can also do dates.

#### CastleHeart

I still don't understand the question

- C

#### Anne Troy

Anne
Keep comin' back, CH.

#### CastleHeart

bu...bu....but I really don't understand it, Dreamboat annie!

I mean that Q could mean a lot of things! I was merely cajoling!
Now I patiently wait for clarity!

- C

If you pick on me I'll send you more rain!

#### Anne Troy

Anne

Ah figger it lak thayus:
He wounce ta ayther hayev a noombered column, jest lak ther row noombers, ower he wounce ta hayev eggzistin noombers ta git a wown aydded ta it
Ayther why, hay's coovered bah ther ansers hay alraydy gawt

#### CastleHeart

You're right!.... to hell with clarity!

The weekend is upon us - I hear the beach calling my name.
Clarity can wait for Monday morning's coffee.

gentleman.... the drinking lamp is lit!

Castleheart
PS: I'm actually from down Texas way. Why that stuff in your there answer ......that ain't no accent atall !

#### Anne Troy

Anne
How about the smoking lamp? NOT THAT ONE!!! I KNOW WHERE YOUR HEAD'S AT!!! But SOME of us don't drink...

#### CastleHeart

alright then....
an adirondack chair, a pale autumn breeze and a fine cigar...
- "rolled on the thighs of island women!"

Sorry it took so long to get back. I had a cllent that's system went completely down so was swamped.

I tried Kiwi guy's first and it worked perfectly. Thanks, Kiwi.

CH the question was this. In Excel if I have a column with values:

10
12
15
18

but wanted all records to be one increment:

11
13
16
18

What would I need to do?

Sorry I wasn't clear.

Thanks,everyone for all your help. This site is so great.

#### itsmeagain

Add a column to the right of the one you want to change, and add a formula (cell to the left) + 1, then copy it down the rest of the column - you can then hide the original column if you wish

#### Anne Troy

Anne
itsmeagain:

He's already used kiwi's answer, which was best and easiest for his purposes.

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

As Seen On