Results 1 to 6 of 6

Quick Question

This is a discussion on Quick Question within the Excel Questions forums, part of the Question Forums category; If I have 5 numbers in a row and want to multiply them all by the same number in cell ...

  1. #1
    New Member
    Join Date
    Mar 2004
    Posts
    12

    Default Quick Question

    If I have 5 numbers in a row and want to multiply them all by the same number in cell XYZ, what is the keystroke to make a global formula insert?
    Thanks in advance - Jonathan.

  2. #2
    DRJ
    DRJ is offline
    MrExcel MVP DRJ's Avatar
    Join Date
    Feb 2002
    Location
    California
    Posts
    3,856

    Default

    Copy the cell in XYZ

    Highlight the cells you want to multiply by the number.

    Edit | PasteSpecial | Multiply

  3. #3
    Board Regular
    Join Date
    Aug 2003
    Location
    England
    Posts
    4,644

    Default Re: Quick Question

    Hello,

    Is this an example of your scenario

    A1 = 1
    A2 = 2
    A3 = 3
    A4 = 4
    A5 = 5

    A7 = 6

    in B1 you want A1*A7
    in B2 you want B1*A7

    Enter the formula for B2 = A1*$A$7, put the cursor in the bottom right hand corner, until you get a black cross, and double click the mouse button.

    Is this what you require or are you adamant to use keystrokes,

    Put the cursor in the cell below the one with the data in and press CTRL and D together, this will only fill in the one cell though.
    -------------------------
    Hope this is helpful.
    -------------------------
    only a drafter,
    but broadening my Excel knowledge.

  4. #4
    Board Regular
    Join Date
    Feb 2004
    Location
    Andover, MA
    Posts
    188

    Default Re: Quick Question

    If you are trying to take the formula in XYZ and multiply it against all the cells in a range, make sure the cell references in the formula in XYZ are absolute (use $), copy cell XYZ, then highlight the range of cells you want multiplied then paste special>formulas>multiply

    If you want the cells in the range to know have *XYZ added to them, then in a different cell, put =XYZ with absolute references, then copy that cell, highlight the range of cells you want multiplied then paste special>formulas>multiply
    Once you can accept the universe as matter expanding into nothing that is something, wearing stripes with plaid comes easy.
    --Albert Einstein

  5. #5
    New Member
    Join Date
    Mar 2004
    Posts
    12

    Default Re: Quick Question

    Aloha / DRJ - Exactly what I was looking for - Thanks.

  6. #6
    DRJ
    DRJ is offline
    MrExcel MVP DRJ's Avatar
    Join Date
    Feb 2002
    Location
    California
    Posts
    3,856

    Default

    Your very welcome

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com