Karl, If I correctly understand your objective, try these steps:
1. Enter the desired multiplier in any cell (e.g., 1.05 for a 5% increase). 2. Select that cell and copy to the clipboard (i.e., Edit > Copy). 3. Select all the cells you want to modify (e.g., click on the first cell and Shift-Click on the last cell). 4. Select Edit > Paste Special... 5. Click on the "Multiply" selection under "Operations". 6. Make sure "Numbers" is selected in the "Selection" choices, or simply select "Paste all". 7. Click on "OK". If you don't like the result, you can select Edit > Undo: Copy to restore the previous values. (Don't ask me why it's "Undo: *Copy*" when you just did a *Paste*. ;-) Note that the "Multiply" selection in the Paste Special dialog is retained, so you will need to be careful if you next want to use Paste Special for a different behavior. Chuck On Tue, Mar 29, 2022 at 9:27 AM stmo <s...@cruzio.com> wrote: > I am trying to increase a number in a column by a percentage but I want > to increase the entire column. > [snip] > > > On Mon, Mar 28, 2022 at 11:40 AM stmo <s...@cruzio.com> wrote: > > > >> I have spent an entire week trying to find an answer to this. > >> > >> I need the formula and exactly where to put it in order to increase a > >> percentage amount in a spread sheet with numerous entry's Could not > >> find in FAQs We use windows 10 and OO 4.4.5 > >> > >> Thanks > >> Karl G > [snip]
