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

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

Enter formula to multiple cells at once

19karlos76 said:

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)..

Click to expand...

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