Multiplie a column by 2

[Kush]

Hey,

Got a column I wanne multiplie by 2.
It goes from I6 to I2237 so it takes some time if
I gotta do it manual. Each cell gotta be multiplie by 2.
Hope this made any sense.

Thanks

 

[Frank Kabel]

Hi
- put the '2' in an empty cell and ocpy this cell
- select I6:I2237
- goto 'Edit - Paste Special' and choose 'Multiply'

 

[Nikos Yannacopoulos]

Kush,

Enter the value 2 in an empty cell and copy. Then select the column to be
multiplied, right-click and select Paste Special; select option Multiply and
click OK. The job is done, and you can now delete the temporary 2 in the
previously empty cell.

HTH,
Nikos