Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Sep 2006
    Location
    New Jersey, USA
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question Update columns of numbers in spreadsheets

    Hi all,

    I am trying to update a number of columns in a spreadsheet by a certain percentage.
    4 to 5 columns of 200 to 300 cells with different amounts in each cell, all need to be updated by the same percentage.



    I vaguely remember there was a way to do this, but for the life of me I can not remember what it was!

    Any help will sincerely be greatly appreciated!

    Cindy

  2. #2
    Star Lounger
    Join Date
    Oct 2012
    Posts
    55
    Thanks
    1
    Thanked 10 Times in 10 Posts
    Hi cutie_pyie

    If you put your percentage in a cell say 50% plus 1 = 1.5. Copy, select the columns/rows/cells,, paste special, multiply.

  3. The Following User Says Thank You to Kevin@Radstock For This Useful Post:

    Maudibe (2013-01-14)

  4. #3
    New Lounger
    Join Date
    Apr 2010
    Location
    Halifax, Canada
    Posts
    19
    Thanks
    0
    Thanked 2 Times in 2 Posts
    >Copy, select the columns/rows/cells,, paste special [ICON], multiply

    The above instructions were not quite clear to me, initially (WHEN STARTING FROM A RIGHT-CLICK).

    There are actually two (2) paste special options that [may] need to be selected (in sequence) - always go to bottom most (last) item of each drop down list to obtain a selection box with multiply button option.
    Last edited by vopthis; 2013-01-14 at 11:21. Reason: situational clarification

  5. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,631
    Thanks
    115
    Thanked 645 Times in 589 Posts
    Kevin,
    Have long forgotten that technique. If I remember right,however, I think it only works for constants. Thanks for the refresher.
    Last edited by Maudibe; 2013-01-14 at 21:54. Reason: spelling

  6. #5
    Star Lounger
    Join Date
    Oct 2012
    Posts
    55
    Thanks
    1
    Thanked 10 Times in 10 Posts
    Thank you Maudibe

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •