Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Increase whole column by same percentage

How do I increase a whole column of figures by the same percentage. The only
way I know is to multiply the first figure by what I want and copy and paste
the rest of the way down.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,574
Default Increase whole column by same percentage

Assume you want to increase all the numbers by 10%. Enter 1.1 in a blank
cell. Copy it. Then select the entire range in question. Select Paste
Special--Multiply and click OK.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"jonilyn" wrote:

How do I increase a whole column of figures by the same percentage. The only
way I know is to multiply the first figure by what I want and copy and paste
the rest of the way down.

  #3   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Increase whole column by same percentage

One way ..

Suppose you want to increase by 10%.
Enter 1.1 in any empty cell. Copy the cell.
Then right-click on the col of numbers, choose Paste Special Mulitply OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"jonilyn" wrote:
How do I increase a whole column of figures by the same percentage. The only
way I know is to multiply the first figure by what I want and copy and paste
the rest of the way down.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Increase whole column by same percentage

Thank you - I knew there must be an easy way. I'll need to run the numbers
using different percentages so this will work great. Thanks again!

"jonilyn" wrote:

How do I increase a whole column of figures by the same percentage. The only
way I know is to multiply the first figure by what I want and copy and paste
the rest of the way down.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to increase the value of a whole column of cells by a percentage? [email protected] Excel Discussion (Misc queries) 2 October 16th 06 10:08 AM
How to increase the value of a whole column of cells by a percentage? [email protected] Excel Discussion (Misc queries) 1 October 15th 06 10:51 PM
How do I increase a column of numbers by a percentage-same cell dcasdos Excel Discussion (Misc queries) 3 June 4th 06 10:21 PM
Can I increase an entire column by a percentage? KandyKane Excel Discussion (Misc queries) 4 January 25th 06 05:02 PM
increase all values in a column by a percentage BayComp Excel Worksheet Functions 3 April 10th 05 01:59 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"