Keyboard Shortcut

Hi,

Can someone please tell me how to Paste Special - Values - Transpose using a keyboard short? I tried Alt E,S,E which worked well except that it also pasted the formatting of the data that I copied across. Is it possible to paste the data without copying the formatting too?

Thanks

hi andrewc, just add a V before or after the last E.
ALT + E + S + V + E
or
ALT + E + S + E + V

If you're using Excel 2007 or above you can use Alt, h, v, t

I missed the values part Alt+ h, v, s, v, e will also work in 2007 and above.