| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Applying a formula to multiple cells
I have numerical data in many cells and am needing to multiply all cells by
10%. Is there a way to apply a formula to many cells at once? Rather than entering *.10 into every single cell? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Applying a formula to multiple cells
Put 10% in cell A1
formula then =sum(b1*$A$1) copy as needed "Lindsay" wrote: I have numerical data in many cells and am needing to multiply all cells by 10%. Is there a way to apply a formula to many cells at once? Rather than entering *.10 into every single cell? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Applying a formula to multiple cells
Put .10 in an empty cell
edit|copy that cell Select the range to adjust edit|paste special|values and multiply clean up that cell. Lindsay wrote: I have numerical data in many cells and am needing to multiply all cells by 10%. Is there a way to apply a formula to many cells at once? Rather than entering *.10 into every single cell? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Applying multiple distinct conditional formatting rules | Excel Discussion (Misc queries) | |||
| Applying Conditional Formatting to Multiple Worksheets - Excel 200 | Excel Discussion (Misc queries) | |||
| Applying single comment to multiple cells | Excel Worksheet Functions | |||
| Applying Protection To Multiple Sheets | New Users to Excel | |||
| Applying formula to only NON-EMPTY cells in range | Excel Discussion (Misc queries) | |||
Linear Mode
