From the course: Excel 2010 Essential Training

Unlock the full course today

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

Setting Excel options

Setting Excel options - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

Setting Excel options

In addition to customizing the Ribbon bar and Quick Access toolbar on top of the Ribbon, Excel gives you a lot of control over the way it behaves. I want to show you few of its settings. Before we do, there's one other thing I need to show you. As you may have noticed, if you have something selected in a cell like this, you have this little ghosted out toolbar here, and it's called the Mini toolbar. So, if you have something selected like this, you can very quickly make it bold or italic or change the color of it without having to go all the way up to the Ribbon bar. Now, some people like it, some people don't, and one of the first items in Excel's Options is to turn that Mini toolbar off. So, I just want you to keep that in mind. So, let's go up to the File tab to get into Backstage view, and down here towards the bottom click Options. So, over here on the left we have all these categories. And the General category is selected there by default. So here it is, Show Mini toolbar on…

Contents