Thread: Multiplying A Whole Column By 2 ??? Help
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Cutter
 
Posts: n/a
Default Multiplying A Whole Column By 2 ??? Help

You can type the number 2 in any empty cell
Then copy that cell
Now select all the cells in column B that you want to double
Now right click on any cell in that selection and choose Paste Special
Choose Multiply and then OK


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=497180

Reply With QuoteReply With Quote