Small Business..
I have a formatted excell sheet with 3 columbs of #s I want to increase all
by 10% without doing individual cell. |
Small Business..
Choose a blank cell somewhere and enter 1.1 in that cell (equivalent
to 110%). Select the cell and <copy, then highlight the three columns of numbers and Edit | Paste Special | Values (check) | Multiply (check) | OK then <Esc. You can delete the 1.1 from the first cell. Hope this helps. Pete On Oct 24, 11:35 pm, Small business needs help. m wrote: I have a formatted excell sheet with 3 columbs of #s I want to increase all by 10% without doing individual cell. |
All times are GMT +1. The time now is 07:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com