From the course: Excel 2016: Tips and Tricks
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Display Paste Special options instantly
From the course: Excel 2016: Tips and Tricks
Display Paste Special options instantly
- [Voiceover] Excel's paste special dialog box offers a number of different options after you copy data. Here's one example, and certainly wouldn't be so obvious for starters. I've got some data here laid out on this worksheet called "Profits" that goes across the screen, and eventually I might want to add the remaining six months of the year. It occurs to me as I look at this, that maybe this would have been better had the months been down column A, or some other column, and sales, expenses, profits, across the top. So, we can take this data and copy it, perhaps CTRL + C or right click and copy. And out here in cell K2, I'm going to go to paste special. You can certainly get there by right clicking. Go to paste special and if you slide over some of the various options out here, you will come to one called transpose, click it and there's the data. It's been transposed, we flipped it on its corner so to speak, pivoted it. And we got our months down a column and the sales, expenses…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.