ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I change all the figures on a worksheet by a set %, witho. (https://www.excelbanter.com/excel-discussion-misc-queries/4267-how-can-i-change-all-figures-worksheet-set-%25-witho.html)

magsgoode

How can I change all the figures on a worksheet by a set %, witho.
 


JulieD

Hi

taking a guess here as your question was truncated (always best to have a
short subject and put the details in the message) - type the percentage that
you want to increase your figures by (i.e. 110% to raise them by 10%) in a
cell somewhere and copy it, then select all the cells to increase and choose
edit / paste special / multiply and click ok

hope this helps
Cheers
JulieD

"magsgoode" wrote in message
...





All times are GMT +1. The time now is 08:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com