Results 1 to 2 of 2

Thread: ...might be a stupid question, but...

  1. #1

    ...might be a stupid question, but...



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hey guys,

    I have a workbook that I'm working on and would like some help... I would like to assign a formula to a number of different cells on a specific worksheet. But rather than picking ech individual cell (Ctrl + click, click, click, click...etc). Is there a way to select cells by identifying them through picking the columns/rows that they intersect in? (ie: I don't want the whole D column, just the cells in D column that intersect rows 2,3,7,14...etc). I hope this makes sense to you all, thanks in advance

    K-DAWG

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    885
    Articles
    0
    Excel Version
    Excel 2013

    Enter formula to multiple cells at once

    Quote Originally Posted by 19karlos76 View Post
    picking ech individual cell (Ctrl + click, click, click, click...etc).......... (ie: I don't want the whole D column, just the cells in D column that intersect rows 2,3,7,14...etc)..
    If I understood you, I have one question.

    How to know Excel, in which the selected cells you want to enter a formula?

    Method 1:
    You need to select specific cells (by CTRL + click D2 + click D3 + click D7 + click D14...) and enter the formula on way => Item 5 and 6 bellow

    Method 2:
    1. On Home tab
    2. Find&Select
    3. GoTo dialog box => in Reference field enter D2,D3,D7,D14 => OK
    4. Now you have selected specific cells
    5. Enter formula in to Formula Bar
    6. Press CTRL hold down and press Enter key

    Method 3:
    Use a VBA macro with multiple selecting specified cell
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

Posting Permissions

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