Copy 250 array formula(reference in diffrent sheet) from horizontal to vertical

General Excel Questions & Answers

Last Post by Alan Sidman 4 years ago

3 Posts

3 Users

0 Reactions

173 Views

RSS

Yog Pat

(@yogpat)

Posts: 1

New Member

Topic starter

Hi Friends,

I Want to copy 250 array formula(reference in different sheet) from horizontal to vertical without changing reference point.
I want only same formula but in vertical not in horizontal.

I don't want to use Transpose function as i want to retain same array formula.

I have replace "=" with "ZZZ" in all pasted vertically(Transpose) & again changed to "ZZZ" to "=" but since it's array formula every cell i don't want to type Ctrl+Shift+Enter.

Please support. I am using MS Excel 2007

Thanks

Regards
Yog

Posted : 14/09/2021 9:43 am

Mynda Treacy

(@mynda)

Posts: 4762

Member Admin

Hi Yog,

Welcome to our forum!

Maybe you can change it to a multi-cell array formula. That way you select the cells first, then enter the formula and press CTRL+SHIFT+ENTER. You'll no doubt need to change the cells being referenced too. Hard to say much more without an example file.

Mynda

Posted : 14/09/2021 7:59 pm