View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default mutliply a worksheet by a constant

Right click the sheet tabMove or copyCheck create a copy To book select
'new book' and click OK./

If you want multiply the cel values by say (2) enter 2 in a ununsed cell.
copy the cell. Keeping the copy ; select the range of cells you would want to
multiply. Right click PasteSpecialMultiply OK.

Now save your workbook..


If this post helps click Yes
---------------
Jacob Skaria


"Eduardo" wrote:

I need to multiply the contents of a spreadsheet by a constant and save the
results on a different spreadsheet. How can I do this?

Thanks for your help