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
If I understood you, I have one question.Originally Posted by 19karlos76
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
Reply With Quote
Bookmarks