Adding 1 to every value in the selection

  • Thread starter Thread starter jayhawk1919
  • Start date Start date
J

jayhawk1919

How would I go about adding 1 to every value in the selected cells. For
example I have the numbers 228, 72, 56, and 45 in 4 consecutive cells.
How would I go about selecting them all and then adding one to each,
all at the same time?
 
Use the Paste Special command...

1. type a 1 in any blank cell

2. Copy the cell containing the 1

3. Select the four cells containing the numbers you wish to add 1 to

4. Click Edit-->Paste Special

5. Click "Add" in the Operation section of the dialog

6. (Optionally) Click Values in the Paste section to prevent formats from
being overwritten in pasted cells

7. Click OK
 
Enter 1 in a cell. Copy. Select your range of numbers and Paste
Special>Add>OK>Esc.

Clear contents of cell with 1.

Gord Dibben XL2002
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to determine the values? 1
How to determine the value from a list? 3
Adding every sixth value 8
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
MACRO PASTE CELL to COLUMN, SKIP ROWS 1
MACRO COLUMNS, SKIP ROWS 6
Add the actual value in a cell that contains a formula 3
adding the sum of a series of cells 2

Back
Top