How do I multiply ALL CELL in spreadsheet at once by .5 ?

  • Thread starter Thread starter ariel
  • Start date Start date
A

ariel

I am trying to multiply all the cells in my spreadsheet by .5 . each cell has
a differant value but need to multiply by .5 to update. Can I do the whole
sheet, or row, or column at once without having to do each cell
individually??? Please help... would take time off my busy schedule.
Thank you,
 
Enter .5 in an empty cell.
Copy that cell.
Highlight the cells you want to change.
Right-click, choose Paste Special...>Multiply
OK out.

Regards
Fred
 
you cant multiply you jerk
I am trying to multiply all the cells in my spreadsheet by .5 . each cell has
a differant value but need to multiply by .5 to update. Can I do the whole
sheet, or row, or column at once without having to do each cell
individually??? Please help... would take time off my busy schedule.
Thank you,
Click to expand...
 
you cant multiply you jerk
I am trying to multiply all the cells in my spreadsheet by .5 . each cell has
a differant value but need to multiply by .5 to update. Can I do the whole
sheet, or row, or column at once without having to do each cell
individually??? Please help... would take time off my busy schedule.
Thank you,
Click to expand...
 
Back
Top