Inside Microsoft Office

Transpose your worksheet’s rows and columns easily: There’s no need to retype

Inside Microsoft Office

by Julie Duncan

Figure A:
Article figure image

If you’ve already entered all your data into a worksheet when you finally decide you’d like to switch the rows and columns, doing so may seem like a daunting task. Fortunately, Excel provides two built-in methods for accomplishing feats similar
to what we see in Figure A. We’ll step you through the two different approaches, and along the way we’ll show you how the
method you end[…]


Subscribe to Inside Microsoft Office

(get full access to archives and more)