Accelerate copy, move, and paste actions with the right mouse button

- [Instructor] There are numerous methods in Excel…for not only copying data but also for copying formats,…and sometimes you can use the right mouse button…to achieve these effects in a faster way.…In this worksheet called Profits, I'm clicking on cell B4.…I'm applying a different format.…I'll make it be bold, italic.…How about a blue font?…There we are.…Now, at a later time, I'm thinking I want that format…to also exist in a few other cells.…Now, if it's multiple cells,…we might use a different feature called Format Painter,…that's covered elsewhere,…but I want this format here copied…to the other cells in the same row.…

I'll point to the lower right-hand corner,…that's the fill handle.…Hold down the right mouse button.…Drag across these cells here,…Let go of the right mouse button.…There's that menu, Fill Formatting Only.…We're not copying data.…We're copying formats.…Here's another example in the worksheet to the right,…the projected budget for 2019.…I'm changing column E.…I'm thinking that I might actually want…