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.
Okay, perhaps we have different keyboards
Nope, the C+S on the other side of the keyboard just wont work SergeiBaklan
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
c and s on the left-hand side of the keyboard
Just for my interest, what do you mean under another set of Ctrl, Shift and Enter buttons?
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!!
