I have a price sheet that has headings throughout. I want to automatically increase all the prices on the sheet by 10%. How can I do this? If type =1750*&1.1 it will return the result for that cell but I can copy the formula down. It just returns the same result in all the cells below it.

Hi
Enter 1.1 in an empty cell and copy that value
Select the range to be increased - Right click - Paste special - Multiply - OK

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post