How to Transpose in 20 seconds ⤵️ #excel

In this video, you will learn how to transpose a table in Excel!

Step 1. Select all rows (Ctrl + Shift + ⬇️)
Step 2. Select all columns (Ctrl + Shift + ➡️)
Step 3. Copy (Ctrl + C)
Step 4. Paste Special (Ctrl + Alt + V). Choose ‘Transpose’. Press ‘OK’.

Don't waste time spending countless hours on manual, repetitive tasks in Excel 🚫

Join Miss Excel's FREE Masterclass to learn all of her favorite tips & tricks. In this fun power-packed 1 hour session, you'll learn her secret hacks for optimizing your data visualization skills to save you hours each week!

Limited spots available! Register at our link on channel page! 🎉

#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials