Multiplie a column by 2

  • Thread starter Thread starter Kush
  • Start date Start date
K

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
 
Hi
- put the '2' in an empty cell and ocpy this cell
- select I6:I2237
- goto 'Edit - Paste Special' and choose 'Multiply'
 
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
 
Back
Top