From the course: Excel: Tips and Tricks (2023)
Join today to access over 24,600 courses taught by industry experts.
Accelerate formatting with the right mouse button
From the course: Excel: Tips and Tricks (2023)
Accelerate formatting with the right mouse button
- [Instructor] In Excel, we use the right mouse button primarily for shortcut menus. But we can also use it in a different way, by dragging data. On this worksheet called Profits, I'm going to change the format in cell B3. What I want to do here is make it bold. I'll make it italic too, and also apply a font color, that's going to be different: blue. So let's imagine that I like that. I want to copy it to the other cells. Now, I certainly could have highlighted all those to begin with, and done it all at once, but maybe I did this, or maybe I just opened this and happened to see it. We can copy a format, by dragging the fill handle with the right mouse button. Now I'm not copying the data here. I'm dragging to the right, using the right mouse button. As I release the right mouse button, fill formatting only. So we didn't change the content we simply changed the format. There's certainly other ways to do that too. We…
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.