Thread: how do i square all items in a colums w/out doinf it one-by-one?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default how do i square all items in a colums w/out doinf it one-by-one?
Hi!

Select the range of numbers.

Goto EditCopy

EditPaste SpecialMultiplyOK

Biff

"excellent person" <excellent wrote in
message ...
I used the random number generator to generate 1000 numbers. Now I want to
square all 1000 items but obviously I dont want to do it one-by-one. How
can
I do this instantly?


Reply With QuoteReply With Quote