From the course: Excel 2016: Tips and Tricks
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Accelerate Copy/Move/Paste actions with the right mouse button
From the course: Excel 2016: Tips and Tricks
Accelerate Copy/Move/Paste actions with the right mouse button
- [Voiceover] There are some not so well known techniques that use the right mouse button for dragging data in situations where we're copying not just data, but sometimes formats as well. On this worksheet called Profits, In cell B4, I'm going to change the look of this cell. I'd like to have it be dollar sign first of all. I could copy the format from above, but just as easily I could press the dollar sign here in the home tab on the number group. So I wanna add dollar sign. I also wanna add a background color, like a light color here, maybe this blue right there, and maybe I'll make this italics. And I want that to occur for the other cells over here. Now I certainly could've highlighted all those cells and have done the same thing ahead of time, but maybe I was doing this for awhile just to make it stand out on a print out and then later I decided it would look good all the way across the row. I'm going to point to the fill handle here in the lower right hand corner and hold down…
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.