Welcome toExcel2007.Tips.Net
ExcelTips (menu) Tips
Health Tips
Legal Tips
Pet Tips
Controlling How Excel Adjusts Capital Letters
Numbers Mysteriously Divided by 100
Displaying Comment Boxes where You Want Them
Turning the Formula Bar On and Off
You probably know the feeling—you start creating a worksheet, get a good way into it, and realize that you should have made your columns into rows and your rows into columns. In other words, you want to turn your data by 90 degrees and continue working with the sheet.
Fortunately, Excel provides an easy way to accomplish this very task. In Excel's terminology, this process is known as transposing data. To transpose your data, follow these steps:
Related Tips:
Take Control! Master the real power behind Word! Successfully master the secrets of powerful formatting and create documents that stand out from the rest. Best of all, you can create documents that are easy to maintain and quick to change. Check out Word 2007 Styles and Templates today!