Forum Discussion
RESOLVED issue: TRANSPOSE function of Excel is not working (try the alternative C+S of the keyboard)
Can you even replicate the arrays
{= B120:G121}
using CSE? A value error will arise if you enter the formula without CSE (ignoring 365 for the moment) because implicit intersection does not return a unique cell for the formula.
It could be that the failure to commit the formula is one of 'finger trouble'.
Are you holding Ctrl+Shift then clicking the Enter key?
Hi Peter,
Nope, I can't replicate {= B120:G121}.
Don't think its a finger trouble. I was holding the C+S keys before I hit E.
Thanks.
- PeterBartholomew1Sep 27, 2020Silver Contributor
- wendy20Sep 27, 2020Copper Contributor
Called for an online repair.
Problem resolved when I tried to hit the other set of CS +E on the keyboard. What a joke.
Thank you so much!!
- SergeiBaklanSep 27, 2020MVP
Just for my interest, what do you mean under another set of Ctrl, Shift and Enter buttons?
- wendy20Sep 27, 2020Copper Contributor
c and s on the left-hand side of the keyboard
- SergeiBaklanSep 28, 2020MVP
If under c and s you mean Ctrl and Shift, they shall work the same if you use left or right side of the keyboard, at least for Ctrl+Shift+Enter
- wendy20Sep 28, 2020Copper Contributor
Nope, the C+S on the other side of the keyboard just wont work SergeiBaklan
- SergeiBaklanSep 28, 2020MVP
Okay, perhaps we have different keyboards