where to find the quick analysis tool in excel 2016

If you're working in a workbook you've saved in OneDrive or SharePoint, you'll see a new button on the Ribbon, just to the right of the Share button. You can change Excel's green title bar to gray, black or white: In the 'Personalize your copy of Microsoft Office' section, click the down arrow next to Office Theme and pick a color. To make the title bar green again, instead choose the 'Colorful' option from the drop-down list. In the 'Personalize your copy of Microsoft Office' section, click the down arrow next to Office Theme, and select Dark Gray, Black or White from the drop-down menu. To do it, select File > Options > General. To make it appear again, press Ctrl-F1 and it comes back.Īnd if for some reason that nice green color on the title bar is just too much for you, you can turn it white, gray or black. Just as in previous versions of Excel, if you want the Ribbon to go away, press Ctrl-F1. Also see the nifty new Tell Me feature described below. To find out which commands reside on which tabs on the Ribbon, download our Excel 2016 Ribbon quick reference. The Ribbon hasn't changed a great deal from Excel 2013.

But it still works in the same way and you'll find most of the commands in the same locations as in Excel 2013. The 2016 Ribbon is smaller than it was in Excel 2013, the title bar now is now solid green rather than the previous white, and the menu text for the Ribbon (File, Home, Insert and so on) is now a mix of upper- and lowercase rather than all caps. If you need a refresher, see our Excel 2010 cheat sheet.Īs in Excel 2013, the Ribbon in Excel 2016 has a flattened look that's cleaner and less cluttered than in Excel 20. Since the Ribbon has been included in Office suite applications since Office 2007, we assume that by now you're familiar with how it works. The Ribbon interface that you came to know and love (or perhaps hate) in earlier versions of Excel hasn't changed much in Excel 2016. But that doesn't matter all the tips here apply to whatever version of Excel 2016 you're using. Your copy of Excel 2016 may have been purchased as standalone software or as part of an Office 365 subscription. But although you may have upgraded to the latest version, you might be missing out on some worthwhile features introduced in Excel 2016 - that's what we'll look at in this story. The current version is Excel 2016, released in late 2015 when the entire Office suite was upgraded. And if you use spreadsheets, that generally means Excel. Microsoft Windows may get all the press coverage, but when you want to get real work done, you turn your attention to the applications that run on it. Share this story: IT folks, we hope you'll pass this guide on to your users to help them learn the Excel 2016 ropes.

Where to find the quick analysis tool in excel 2016