How do I multiply ALL CELL in spreadsheet at once by .5 ?
in [Functions]
|
From: ariel on 10 Feb 2010 10:46 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,
From: Ms-Exl-Learner on 10 Feb 2010 11:01 Have a look in the below link for solution http://www.j-walk.com/ss/excel/usertips/tip059.htm http://www.exceladvisor.net/sub/1_copypaste.htm Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "ariel" wrote: > 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, >
From: Fred Smith on 10 Feb 2010 13:08 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 "ariel" <ariel(a)discussions.microsoft.com> wrote in message news:BA9F3983-B3EB-4402-8B0D-1A302F279437(a)microsoft.com... >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, >
|
Pages: 1 Prev: TransferSpreadsheet to colored fields Next: Custom views in Excel |