Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a number to multiple cells at once
Hi, I've got a problem that I just don't really know how to word right to
search for a solution to: I've got a large spreadsheet with lots of number, not formulas, in the cells. I need to multiply every number in the sheets by 5, but I have no idea how to apply that to cells. How would I go about adding/multiplying numbers in a range of cells? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a number to multiple cells at once
Enter 5 into any blank cell
Copy that cell Select your range of numbers to multiply From the Edit Menu, select "Paste Special..." Check "Multiply" option Click OK Delete the 5 you entered originally HTH, Elkar "SeveranceD" wrote: Hi, I've got a problem that I just don't really know how to word right to search for a solution to: I've got a large spreadsheet with lots of number, not formulas, in the cells. I need to multiply every number in the sheets by 5, but I have no idea how to apply that to cells. How would I go about adding/multiplying numbers in a range of cells? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a number to multiple cells at once
One way:
Enter 5 in an empty cell. Copy the cell. Select the values to be increased. Choose Edit/Paste Special, selecting the Values and Multiply radio buttons. Click OK. In article , SeveranceD wrote: Hi, I've got a problem that I just don't really know how to word right to search for a solution to: I've got a large spreadsheet with lots of number, not formulas, in the cells. I need to multiply every number in the sheets by 5, but I have no idea how to apply that to cells. How would I go about adding/multiplying numbers in a range of cells? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a number to multiple cells at once
Thanks a ton for the easy straightforward answer.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding multiple cells together | Excel Discussion (Misc queries) | |||
Adding up multiple cells | Excel Worksheet Functions | |||
adding and divideing by a the number of cells! | Excel Worksheet Functions | |||
adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
Adding cells, using text as number | Excel Discussion (Misc queries) |