Forum Discussion
wendy20
Sep 27, 2020Copper Contributor
RESOLVED issue: TRANSPOSE function of Excel is not working (try the alternative C+S of the keyboard)
Hi there, I have encountered an issue with an excel array function using a Windows computer. I am sure the formula and items in the function are all used correctly. I can replicate the same o...
wendy20
Sep 27, 2020Copper Contributor
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.
PeterBartholomew1
Sep 27, 2020Silver Contributor
- SergeiBaklanSep 28, 2020MVP
Okay, perhaps we have different keyboards
- wendy20Sep 28, 2020Copper Contributor
Nope, the C+S on the other side of the keyboard just wont work SergeiBaklan
- 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 27, 2020Copper Contributor
c and s on the left-hand side of the keyboard
- SergeiBaklanSep 27, 2020MVP
Just for my interest, what do you mean under another set of Ctrl, Shift and Enter buttons?
- 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!!