Inside Microsoft Excel


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

Inside Microsoft Excel

by Julie Duncan

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 up choosing will depend on[…]

 

Subscribe to Inside Microsoft Excel

(get full access to archives and more)