RESOLVED issue: TRANSPOSE function of Excel is not working (try the alternative C+S of the keyboard)

wendy20 

Okay, perhaps we have different keyboards

Nope, the C+S on the other side of the keyboard just wont work SergeiBaklan 

wendy20 

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

SergeiBaklan 

wendy20 

Just for my interest, what do you mean under another set of Ctrl, Shift and Enter buttons?

PeterBartholomew1 

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!!

wendy20 

Please do not feel insulted by my suggestion.

Perhaps an Office repair is called for?

PeterBartholomew1 

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.

wendy20 

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?

Thanks for the help so far! Riny_van_Eekelen