| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I increase an entire column by a percentage?
If your data is in column A, then you could do this with a formula in each
corresponding cell in column B. If B1: =A1*1.05. Then copy the formula down through the entire column. Or you could type the number 1.05 in some empty cell, then copy it (ctrl+C), select all the cells you need to adjust and Edit Paste Special, select multiply and click OK. "KandyKane" wrote: I need to increase an entire column by 5% (price list increase). Can I do this with one individual forula? Do I have to do every row individually? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making Hyperlinks Active In Entire Column | New Users to Excel | |||
| Percentage increase in excel | Excel Discussion (Misc queries) | |||
| match and count words | Excel Worksheet Functions | |||
| Copy one cell to entire column | Excel Discussion (Misc queries) | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Threaded Mode
