This is an easy and oftentimes necessary task a worker needs to do while using Microsoft Excel. You were handed a spreadsheet with a bunch of information typed up in rows, but actually need them to be in columns.
It is so simple to get that data switched without going crazy having to re-type it all. All you have to do is copy the data that you want to be transposed (press Ctrl+C or Command+C), select an empty section of your spreadsheet to paste data, right-click on the cell of the new section, go down to “Paste Special” and click “Transpose.” Voila! Your data is automatically switched to columns for you.
This can also go vice versa, columns become rows and rows become columns. Give it a try to make your next spreadsheet experience less of a nightmare. There are so many cool tips to working with Excel. Continue to check back into our TechTips section to learn more.
Did You Know?
Did you know Nuvera’s Technology Solutions Specialists are here to make technology easy? If you ever have any questions on your computer, smartphone, application or any sort of technology, you can get your questions answered for as little as $15. Nuvera TechTrends $15 for 15 minutes of tech support is an inexpensive way to get more comfortable with your technology.