Small Business..

  • Thread starter Small business needs help.
  • Start date
S

Small business needs help.

I have a formatted excell sheet with 3 columbs of #s I want to increase all
by 10% without doing individual cell.
 
P

Pete_UK

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
 
Top