+ Reply to Thread
Results 1 to 3 of 3

How to multiply values of all numbers in spreadsheet rows and columns?

  1. #1
    Registered User
    Join Date
    08-06-2014
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    2

    Question How to multiply values of all numbers in spreadsheet rows and columns?

    Hi Guys,

    I am new to excel and have a large spreadsheet with single value figures which I need to transform into multiple values.
    On my first row I need to times all numbers by 15. x15
    On my second it is x10 and so on.
    If this is possible I would really appreciate the help with this as it would save me a huge amount of time.

  2. #2
    Forum Contributor
    Join Date
    10-07-2011
    Location
    India, Mumbai
    MS-Off Ver
    Excel 2007
    Posts
    212

    Re: How to multiply values of all numbers in spreadsheet rows and columns?

    Type 15 in one cell in different excel sheet or in blank cell
    Copy that cell of 15 and
    Select where you want to multiply and Do paste special values and Multiply
    Shortcut
    Right click S V M
    or whatever you can do like .addition , subtraction

    Regards,
    Suhas

  3. #3
    Registered User
    Join Date
    08-06-2014
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    2

    Smile Re: How to multiply values of all numbers in spreadsheet rows and columns?

    Hi Suhas,

    Thank you very much that has saved me a lot of time!!!

    I really appreciate it!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 11
    Last Post: 06-27-2014, 08:11 AM
  2. Replies: 1
    Last Post: 01-24-2014, 06:20 PM
  3. [SOLVED] Multiply top numbers in 2 columns and sum
    By shadyshawn in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-29-2012, 10:29 AM
  4. [SOLVED] For each Cell<> Empty in a range, multiply the values in the corresponding 2 rows
    By caniwritecode? in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 08-20-2012, 08:00 AM
  5. [SOLVED] how do i multiply entire columns of numbers by a %
    By stgaw53 in forum Excel General
    Replies: 1
    Last Post: 10-26-2005, 02:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1