View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Sum Formula for cell range

hi
put your multiplier in a cell then copy it.
high light the cells you wish to multiply.
editpaste specialmultiplyok

regards
FSt1

"Shopgirl" wrote:

How do I multiply a number in a range of cells by a number?
EX Cell 200 Multiply by 2.25