Strange Excel Query?

[stewyb]

Hi Guys,

First time poster, long time user

Ok so the question is: Is there a simple way to just simply double every number on a spreadsheet? litterally A1x2, B1x2, C1x2, D1x2

There has to be an easy way.

Any help would be greatly appreciated

Cheers

Stew

 

[p45cal]

put a 2 in a cell on another sheet, copy it (Ctrl+c)
Select all the cells on the sheet you want to double, then
Edit|Paste Special|Multiply
OK

 

[Hermanito]

Create a range of the same size as the one you want multiplied by 2.
Fill that range with the value 2 (select the range, type 2, then ctrl+enter)
Then select the original range, press ctrl+C
Then click the first cell in the range with 2-values, rightclick, choose Paste Special, and in the Paste Special dialog choose Multiply...

Then copy/paste that new range back to the old to overwrite it...

EDIT: p45cal's way is much more elegant and easier... forget mine

 

[stewyb]

Brilliant!!!!

Thanks loads, thats amazing!

 

[Sektor]

put a 2 in a cell on another sheet, copy it (Ctrl+c)

I wonder why on "another" sheet?

 

[p45cal]

in case all the cells were used on the sheet that needed doubling (I know, unlikely)

 

[Sektor]

I see...

 

[mirabeau]

Hi Guys,

First time poster, long time user

Ok so the question is: Is there a simple way to just simply double every number on a spreadsheet? litterally A1x2, B1x2, C1x2, D1x2

There has to be an easy way.

Any help would be greatly appreciated

Cheers

Stew

If you don't want to use another sheet, and not bother with selecting ranges etc., you could just run a simple VBA macro

Sub dubblit()
With ActiveSheet.UsedRange
    .Cells = Evaluate(.Address & "*2")
End With
End Sub