| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you formulate an entire column?
I need to multiply all the numbers in a column by 8.25%. How do you do that?
-- SW |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do you formulate an entire column?
If you want to keep the original data and have the results in a
new column, just insert a new column and use the formula =A1*0.0825 and copy down as far as you need to go. Change the 'A1' to your first cell. If you want to replace the existing data, enter 0.0825 in some empty cell, copy that cell, select your numbers, then go to the Edit menu, choose Paste Special, select the Multiply option, and click OK. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "SWcoord" wrote in message ... I need to multiply all the numbers in a column by 8.25%. How do you do that? -- SW |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| How can I sort one column and have the entire row sort. (binding) | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Copy one cell to entire column | Excel Discussion (Misc queries) | |||
Hybrid Mode
