ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Excel (https://www.excelbanter.com/setting-up-configuration-excel/46549-excel.html)

shazza

Excel
 
How do i update price lists by say 10% without having to type each cell?

Paul B

shazza, here is one way, put 1.10 in a cell, copy the cell, select the cells
you want to add the 10% to, then edit, paste special, select multiply, OK
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"shazza" wrote in message
...
How do i update price lists by say 10% without having to type each cell?





All times are GMT +1. The time now is 07:09 AM.

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