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.

melonhead

Thread Starter
Joined
May 6, 2002
Messages
882
In an Excel spreadsheet, I want all the numbers to be increased by 1. Can anyone please help with a formula?

Thanks so much in advance!
 
Joined
Aug 17, 2003
Messages
17,584
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.
 
Joined
Sep 9, 2003
Messages
13
. 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
 
Joined
Sep 26, 2003
Messages
10
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.
 
Joined
May 4, 2002
Messages
743
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!
Ruin your weekend!
:eek:
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,746
:D
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
 
Joined
May 4, 2002
Messages
743
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!



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

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,746
How about the smoking lamp? NOT THAT ONE!!! I KNOW WHERE YOUR HEAD'S AT!!! But SOME of us don't drink...
 
Joined
May 4, 2002
Messages
743
alright then....
an adirondack chair, a pale autumn breeze and a fine cigar...
- "rolled on the thighs of island women!" (y)
 

melonhead

Thread Starter
Joined
May 6, 2002
Messages
882
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.
 
Joined
Sep 26, 2003
Messages
10
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
Joined
Feb 14, 1999
Messages
11,746
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.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Members online

Top