I AM TRYING TO ADD 30000 TO A CELL BUT I DON'T KNOW HOW OR WHAT FORMULA TO
ENTER I TRIED = $765,130.00+30000, WHICH GAVE ME WHAT I NEEDED FOR THAT CELL
BUT IS THERE A FORMULA I CAN USE SO I DON'T HAVE TO DO THIS IN EVERY CELL
THAT I NEED TO ADD 30000 TO?

Enter 30000 in a cell
Select the cells you want to add 30000
Choose Edit-Paste Special-Add

"CONFUSED" wrote:

I AM TRYING TO ADD 30000 TO A CELL BUT I DON'T KNOW HOW OR WHAT FORMULA TO
ENTER I TRIED = $765,130.00+30000, WHICH GAVE ME WHAT I NEEDED FOR THAT CELL
BUT IS THERE A FORMULA I CAN USE SO I DON'T HAVE TO DO THIS IN EVERY CELL
THAT I NEED TO ADD 30000 TO?

THAT DIDN'T DO WHAT I NEEDED IT TO DO EITHER, THANKS THOUGH THE OTHER CELLS
THAT I AM TRYING TO ADD 30000 TO HAVE DIFFERENT NUMBERS IN THEM THAT I NEED
TO ADD 30000 TO. THANKS THOUGH

"Sheeloo" wrote:


Enter 30000 in a cell
Select the cells you want to add 30000
Choose Edit-Paste Special-Add

"CONFUSED" wrote:

I AM TRYING TO ADD 30000 TO A CELL BUT I DON'T KNOW HOW OR WHAT FORMULA TO
ENTER I TRIED = $765,130.00+30000, WHICH GAVE ME WHAT I NEEDED FOR THAT CELL
BUT IS THERE A FORMULA I CAN USE SO I DON'T HAVE TO DO THIS IN EVERY CELL
THAT I NEED TO ADD 30000 TO?

Try it like this:

Enter 30000 in an empty cell
With that cell still selected, copy that cell: EditCopy
Select the range of cells you want to add the 30000 to
Then: EditPaste SpecialAddOK
Delete the cell with 30000

--
Biff
Microsoft Excel MVP


"CONFUSED" wrote in message
...
THAT DIDN'T DO WHAT I NEEDED IT TO DO EITHER, THANKS THOUGH THE OTHER
CELLS
THAT I AM TRYING TO ADD 30000 TO HAVE DIFFERENT NUMBERS IN THEM THAT I
NEED
TO ADD 30000 TO. THANKS THOUGH

"Sheeloo" wrote:


Enter 30000 in a cell
Select the cells you want to add 30000
Choose Edit-Paste Special-Add

"CONFUSED" wrote:

I AM TRYING TO ADD 30000 TO A CELL BUT I DON'T KNOW HOW OR WHAT FORMULA
TO
ENTER I TRIED = $765,130.00+30000, WHICH GAVE ME WHAT I NEEDED FOR THAT
CELL
BUT IS THERE A FORMULA I CAN USE SO I DON'T HAVE TO DO THIS IN EVERY
CELL
THAT I NEED TO ADD 30000 TO?

NOW I COME BACK WITH AN #REF ERROR?

"T. Valko" wrote:

Try it like this:

Enter 30000 in an empty cell
With that cell still selected, copy that cell: EditCopy
Select the range of cells you want to add the 30000 to
Then: EditPaste SpecialAddOK
Delete the cell with 30000

--
Biff
Microsoft Excel MVP


"CONFUSED" wrote in message
...
THAT DIDN'T DO WHAT I NEEDED IT TO DO EITHER, THANKS THOUGH THE OTHER
CELLS
THAT I AM TRYING TO ADD 30000 TO HAVE DIFFERENT NUMBERS IN THEM THAT I
NEED
TO ADD 30000 TO. THANKS THOUGH

"Sheeloo" wrote:


Enter 30000 in a cell
Select the cells you want to add 30000
Choose Edit-Paste Special-Add

"CONFUSED" wrote:

I AM TRYING TO ADD 30000 TO A CELL BUT I DON'T KNOW HOW OR WHAT FORMULA
TO
ENTER I TRIED = $765,130.00+30000, WHICH GAVE ME WHAT I NEEDED FOR THAT
CELL
BUT IS THERE A FORMULA I CAN USE SO I DON'T HAVE TO DO THIS IN EVERY
CELL
THAT I NEED TO ADD 30000 TO?

I amsorry I forgot to tell you to copy the cell containing 30000 before
PASTE SPECIAL...

As also suggested by Valko you should get what you want (adding 30,000 to
the cells you want)

I have tested it and it works...

Do you have any cells with formula in the range you are pasting?...
If your cells are not adjacent to each other then use CTRL-Click to select
one by one...

"CONFUSED" wrote:

NOW I COME BACK WITH AN #REF ERROR?

"T. Valko" wrote:

Try it like this:

Enter 30000 in an empty cell
With that cell still selected, copy that cell: EditCopy
Select the range of cells you want to add the 30000 to
Then: EditPaste SpecialAddOK
Delete the cell with 30000

--
Biff
Microsoft Excel MVP


"CONFUSED" wrote in message
...
THAT DIDN'T DO WHAT I NEEDED IT TO DO EITHER, THANKS THOUGH THE OTHER
CELLS
THAT I AM TRYING TO ADD 30000 TO HAVE DIFFERENT NUMBERS IN THEM THAT I
NEED
TO ADD 30000 TO. THANKS THOUGH

"Sheeloo" wrote:


Enter 30000 in a cell
Select the cells you want to add 30000
Choose Edit-Paste Special-Add

"CONFUSED" wrote:

I AM TRYING TO ADD 30000 TO A CELL BUT I DON'T KNOW HOW OR WHAT FORMULA
TO
ENTER I TRIED = $765,130.00+30000, WHICH GAVE ME WHAT I NEEDED FOR THAT
CELL
BUT IS THERE A FORMULA I CAN USE SO I DON'T HAVE TO DO THIS IN EVERY
CELL
THAT I NEED TO ADD 30000 TO?

See this (includes video instructions):

http://contextures.com/xlDataEntry04.html

--
Biff
Microsoft Excel MVP


"CONFUSED" wrote in message
...
NOW I COME BACK WITH AN #REF ERROR?

"T. Valko" wrote:

Try it like this:

Enter 30000 in an empty cell
With that cell still selected, copy that cell: EditCopy
Select the range of cells you want to add the 30000 to
Then: EditPaste SpecialAddOK
Delete the cell with 30000

--
Biff
Microsoft Excel MVP


"CONFUSED" wrote in message
...
THAT DIDN'T DO WHAT I NEEDED IT TO DO EITHER, THANKS THOUGH THE OTHER
CELLS
THAT I AM TRYING TO ADD 30000 TO HAVE DIFFERENT NUMBERS IN THEM THAT I
NEED
TO ADD 30000 TO. THANKS THOUGH

"Sheeloo" wrote:


Enter 30000 in a cell
Select the cells you want to add 30000
Choose Edit-Paste Special-Add

"CONFUSED" wrote:

I AM TRYING TO ADD 30000 TO A CELL BUT I DON'T KNOW HOW OR WHAT
FORMULA
TO
ENTER I TRIED = $765,130.00+30000, WHICH GAVE ME WHAT I NEEDED FOR
THAT
CELL
BUT IS THERE A FORMULA I CAN USE SO I DON'T HAVE TO DO THIS IN EVERY
CELL
THAT I NEED TO ADD 30000 TO?