Click the right mouse button and immediately get a pop-up menu of a few choices. The list does vary, based on where the mouse was pointed when you clicked.
- [Instructor] Excel's menu system is extensive, and there are lots of commands there. It is difficult to find them at times, and you're not always sure what you're looking for. There's a great feature called the shortcut menu, and it's accessible by using the right mouse button. And many times it is accompanied by something called the mini toolbar, particularly when we're talking about formatting capabilities. On this worksheet here, I simply want to put in a new row, for example, between rows six and seven. I want this row right here to have some empty space above it. I don't even know what the command's going to be.
I could spend a lot of time looking around. Now the word insert catches my eye. I might go there, and I will not find anything here about putting in a new row. Back on the home tab, maybe off to the right. There's another word, it's the same word actually, but in a different location, insert. So here's a command here I could be using. But who has the time to do that? And based on where you highlight data and when you want to use a command, for example, if I wanna use this for the entire row here, I'll click row seven and then use that right mouse button.
Click, and what do we see? An abbreviated list of some of the many commands available in the ribbon menu system. There's no guarantee that you will always find the command you want, but here's insert, we think that's the right one. Let's try it, and that's it, so that's really helpful. If you right-click in different portions of the screen though, the popup menu tips that you get are gonna be different. So for example, if I want to add a new sheet, or delete a sheet, or do some other action regarding sheet tabs at the bottom, I'll right-click, as I'm about to do now, on the current sheet.
It's called Profits, right-click and we'll see some choices here. Maybe I wanna change the tab color. There's some other choices as well too. These are completely different than the choices we saw up above. And when we're in the worksheet here, if we want to apply, for example, a color. I want this row here to stand out a little bit differently. That may or may not be a great idea, but I've highlighted the data, I'll right-click, and what do we see above the popup choices that appear here? That's called the mini toolbar. So we get an abbreviated set, although quite a few choices here, based on choices we get on the home tab.
So if we want to apply color here, maybe yellow, fine, we'll do it right there. So it's at our fingertips, and if we right-click, you might have seen this in an earlier movie, if we right-click any of the icons in the ribbon tab, for example, wrap text, we can add this to the quick access toolbar. So right-clicking has that universal meaning of shortcut menu, and when we use it with cells, as we saw on the worksheet here, we also see that mini toolbar. Both features are extremely helpful in getting us to the commands that we need quickly.
- Navigating Excel tabs and menus
- Entering data
- Creating formulas and functions
- Formatting rows, columns, cells, and data
- Working with alignment and text wrap
- Adjusting rows and columns
- Finding and replacing data
- Printing and sharing worksheets
- Creating charts and PivotTables
- Inserting and deleting sheets
- Using power functions such as IF and VLOOKUP
- Password-protecting worksheets and workbooks
- Sorting data
- Analyzing data with Goal Seek and Solver
- Creating and running macros