From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using shortcut menus and the Mini toolbar

Using shortcut menus and the Mini toolbar

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Using shortcut menus and the Mini toolbar

- The Excel menu system is extensive and it can be intimidating at times. There's so many commands, not only on the Home tab but the Insert tab, Page Layout tab, all these other tabs, so many choices. You're relatively new with Excel, let's say, and you're trying to figure out how to do something, you're just not quite sure what to do. For example, I want a new row to separate Profits and YTD Profits, make this stand out a little bit better here by having an empty row below it. So I'm not sure what to do. I'm gonna go to row seven here. Now, do I go to the Insert tab up here? I'm looking for a, insert a column, it says column but not row, so you're just not sure what to do. Now, not foolproof but yet very handy is the right mouse button. I'm going to right-click on row seven. Now, I'm not sure what this going to give me, but it shows me some commands. It also activates what's called the Mini toolbar. On the Mini toolbar we see a lot of buttons that are available on the Home tab. And…

Contents