Dear Forum,

I thought I would be able to do this but its prooving a whole lot more difficult than I first thought. Please can you help?

Essentially I have inherited a spreadsheet which is crammed full of complex array formulas.

No problem in itself as I understand array formulas pretty well (or so I think!). My problem is that when i want to ammend some of these, i cannot easily see what range I need to highlight in order to edit them i.e. I obviously cant do a single cell as its part of an array. I hope I have made myself clear?

So my question is this.

When the cursor is sat in a cell that is part of an array formula, how can I easily find out ( ideally by the array formula range being highlighted in (say) red ) what cells are included in the array formula?

Would conditional formating do the job?

I would be grateful for any help given.

Regards,

Pete

I thought I would be able to do this but its prooving a whole lot more difficult than I first thought. Please can you help?

Essentially I have inherited a spreadsheet which is crammed full of complex array formulas.

No problem in itself as I understand array formulas pretty well (or so I think!). My problem is that when i want to ammend some of these, i cannot easily see what range I need to highlight in order to edit them i.e. I obviously cant do a single cell as its part of an array. I hope I have made myself clear?

So my question is this.

When the cursor is sat in a cell that is part of an array formula, how can I easily find out ( ideally by the array formula range being highlighted in (say) red ) what cells are included in the array formula?

Would conditional formating do the job?

I would be grateful for any help given.

Regards,

Pete

## Comment