The Formulas tab has commands to use when creating Formulas. The Page Layout tab has commands to adjust page such as margins, orientation and themes. The Insert tab allows you to insert a variety of items into a workbook from pictures, clip art, and headers and footers. The Home Tab also includes basic spreadsheet formatting elements such as text wrap, merging cells and cell style. The Home is the most used tab it incorporates all text and cell formatting features such as font and paragraph changes.
The ribbon holds all the information in previous versions of Microsoft Office in a more visual stream line manner through a series of tabs that include an immense variety of program features. Understanding the Ribbon is a great way to help understand what can be done in Excel, especially if you are making the shift between Office 2003 to Office 2010. With that in mind, the Ribbon was developed allowing for better usability. The menus and toolbars have expanded over the years making it difficult for users to find the commands they needed quickly and easily. The Ribbon was designed to help make the Office applications easier to work with, and help users discover the rich features and capabilities of Office. Insert a New Line within Cell Alt + Enter Here are a few that are commonly used to get you up to speed. There are a bunch of keyboard shortcuts you can use to get around faster. In doing this you can add common editing options that you use creating an even easier environment for you to work. You can also add a dialog box launcher to any group on a Ribbon. When these are clicked a dialog box will open providing more options for editing and formatting the spreadsheet.
It provides an easy way to create, open, save, print, share, and close files find recently used files view and update workbook properties set permissions set program options get help and exit the program.įor additional formatting, there are dialog box launchers located at the bottom of the ribbon that are indicated by small arrows in the righthand corners. The Backstage view contains all the commands related to managing the spreadsheets and customizing the program. We will discuss the different tabs in the Ribbon in a later chapter. In addition, you can display the Developer tab, and you might see an Add-Ins tab but we won’t bother with that right now. In Excel, seven tabs display by default: Home, Insert, Page Layout, Formulas, Data, Review and View. If you want to bring everything back (the tabs and commands) click Show Tabs and Commands in the If you want to just bring back the tabs, click on Show Tabs in the Ribbon Display Options. Step 1: Click the Ribbon Display Options tool.
You can specify if you want it blank, the tabs to show, or tabs and commands to show. One of the biggest differences between old-fashioned toolbars and the new-fashioned Ribbon is that the Ribbon is divided into tabs.Īuto Hide allows you to hide the Ribbon from your screen. The Ribbon contains all the commands related to managing and working with spreadsheets. The Ribbon has replaced the toolbar and is the biggest change from Excel 2003 to 2010.
We will address how to customize the Quick Access Toolbar in a later chapter. The Quick Access Toolbar is also customizable so you can add commands that you use most frequently. It is displayed independently of what tab you are currently working in, so you can always see those popular commands and always have them ready for use. It is found in the top left hand corner of the application window. The Quick Access Toolbar displays a small selection of the more commonly used commands in Excel. The switch to Excel 2016 should be relatively seamless as there are only minor changes which we will go over in this guide. The interface of Excel 2016 hasn’t changed dramatically as compared to the 2010 to 2013 transition. It has been designed to help you quickly find the commands and tools that you need to complete many tasks within Excel. The Excel 2016 program window is easy to navigate and simple to use. Whether you’re producing financial reports or managing personal expenses, Excel gives you more efficiency and flexibility to accomplish your goals. You can even upload your files to the Web and work simultaneously with others online. New analysis and visualization tools help you track and highlight important data trends. Microsoft Excel 2016 makes it possible to analyze, manage, and share information in more ways than ever before, helping you make better, smarter decisions.