Change cell values without creating a new column -- possible?

T

Tim

Hello all,

Often in excel I find myself changing data in a column (say add 10 to
all items in column A). How I do this is to create a column to the
right, put =A1+10 in the cell to the right and drag down.

Then I select this column and Paste Special-->Values in the original
column.

After doing this again and again, I am sure there is a better way that
some of you have figured out.

Any thoughts?

Tim
 
J

JE McGimpsey

One way:

Put 10 in an empty cell. Copy the cell. Select the cells to be
incremented. Choose Edit/Paste Special, selecting the Values and Add
radio buttons.
 
T

Tim

One way:

Put 10 in an empty cell. Copy the cell. Select the cells to be
incremented. Choose Edit/Paste Special, selecting the Values and Add
radio buttons.
Click to expand...
Excellent! This is the right direction. Quick question on
implementation:

Open new worksheet.

A1 = 1
A2 = 2
A3 = 3

C2 = 10 and i cut this

Then I select the Range A1:A3.

Edit->Paste Special is disabled!!

Any idea why this is -- in the past I keep cutting, etc to work around
this.

Best,

Tim
 
R

RagDyeR

*DON'T* cut ... As J.E said ... *COPY*

When you're finished, you'll have to go back to C2 and clear it, manually.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


One way:

Put 10 in an empty cell. Copy the cell. Select the cells to be
incremented. Choose Edit/Paste Special, selecting the Values and Add
radio buttons.
Click to expand...
Excellent! This is the right direction. Quick question on
implementation:

Open new worksheet.

A1 = 1
A2 = 2
A3 = 3

C2 = 10 and i cut this

Then I select the Range A1:A3.

Edit->Paste Special is disabled!!

Any idea why this is -- in the past I keep cutting, etc to work around
this.

Best,

Tim
 
Top