Move to the Tell me or Search field on the Ribbon and type a search term for assistance or Help content. Alt+Q, then enter the search term. Open the File page and use Backstage view. Open the Home tab and format text and numbers and use the Find tool. Open the Insert tab and insert PivotTables, charts, add-ins, Sparklines, pictures, shapes. Backstage View in Excel 2013. If you want to display the backstage view in Excel 2013, you need to click the FILE tab. After you do this the backstage view will appear. On the left side, you will find a green area with menu items. If you click one of them, options that are related to the selected category will appear on the right side of the.
Lesson 1: Getting Started with Excel
Introduction
Excel is a spreadsheet program that allows you to store, organize, and analyzeinformation. While you may believe Excel is only used by certain people to process complicated data, anyone can learn how to take advantage of the program's powerfulfeatures. Whether you're keeping a budget, organizing a training log, or creating an invoice, Excel makes it easy to work with different types of data.
Watch the video below to learn more about Excel.
Excel For Mac 2016 How To Get To The Backstage Area In Minecraft
Getting to know Excel
If you've previously used Excel 2010 or Excel 2013, then Excel 2016 should feel familiar. If you are new to Excel or have more experience with older versions, you should first take some time to become familiar with the Excel interface.
The Excel interface
When you open Excel 2016 for the first time, the Excel Start Screen will appear. From here, you'll be able to create a new workbook, choose a template, and access your recentlyeditedworkbooks.
- From the Excel Start Screen, locate and select Blank workbook to access the Excel interface.
Click the buttons in theelow to become familiar with the Excel interface.
Working with the Excel environment
The Ribbon and Quick Access Toolbar are where you will find the commands to perform common tasks in Excel. The Backstage view gives you various options for saving, opening a file, printing, and sharing your document.
The Ribbon
Excel 2016 uses a tabbed Ribbon system instead of traditional menus. The Ribbon contains multiple tabs, each with several groupsof commands. You will use these tabs to perform the most common tasks in Excel.
- Each tab will have one or more groups.
- Some groups will have an arrow you can click for more options.
- Click a tab to see more commands.
- You can adjust how the Ribbon is displayed with the Ribbon Display Options.
Certain programs, such as Adobe Acrobat Reader, may install additional tabs to the Ribbon. These tabs are called add-ins.
To change the Ribbon Display Options:
The Ribbon is designed to respond to your current task, but you can choose to minimize it if you find that it takes up too much screen space. Click the Ribbon Display Options arrow in the upper-right corner of the Ribbon to display the drop-down menu.
There are three modes in the Ribbon Display Options menu:
- Auto-hide Ribbon: Auto-hide displays your workbook in full-screen mode and completely hides the Ribbon. To show the Ribbon, click the Expand Ribbon command at the top of screen.
- Show Tabs: This option hides all command groups when they're not in use, but tabs will remain visible. To show the Ribbon, simply click a tab.
- Show Tabs and Commands: This option maximizes the Ribbon. All of the tabs and commands will be visible. This option is selected by default when you open Excel for the first time.
The Quick Access Toolbar
Located just above the Ribbon, the Quick Access Toolbar lets you access common commands no matter which tab is selected. By default, it includes the Save, Undo, and Repeat commands. You can add other commands depending on your preference.
To add commands to the Quick Access Toolbar:
- Click the drop-down arrow to the right of the Quick Access Toolbar.
- Select the command you want to add from the drop-down menu. To choose from more commands, select More Commands.
- The command will be added to the Quick Access Toolbar.
How to use Tell me:
The Tell me box works like a search bar to help you quickly find tools or commands you want to use.
- Type in your own words what you want to do.
- The results will give you a few relevant options. To use one, click it like you would a command on the Ribbon.
Worksheet views
Excel 2016 has a variety of viewing options that change how your workbook is displayed. These views can be useful for various tasks, especially if you're planning to print the spreadsheet. To change worksheet views, locate the commands in the bottom-right corner of the Excel window and select Normal view, Page Layout view, or Page Break view.
- Normal view is the default view for all worksheets in Excel.
- Page Layout view displays how your worksheets will appear when printed. You can also add headers and footers in this view.
- Page Break view allows you to change the location of page breaks, which is especially helpful when printing a lot of data from Excel.
Backstage view
Backstage view gives you various options for saving, opening a file, printing, and sharing your workbooks.
To access Backstage view:
- Click the File tab on the Ribbon. Backstage view will appear.
Click the buttons in the interactive below to learn more about using Backstage view.
Challenge!
- Open Excel 2016.
- Click Blank Workbook to open a new spreadsheet.
- Change the Ribbon Display Options to Show Tabs.
- Using the Customize Quick Access Toolbar, click to add New, Quick Print, and Spelling.
- In the Tell me bar, type the word Color. Hover over Fill Color and choose a yellow. This will fill a cell with the color yellow.
- Change the worksheet view to the Page Layout option.
- When you're finished, your screen should look like this:
- Change the Ribbon Display Options back to Show Tabs and Commands.
- Close Excel and Don't Save changes.
/en/excel2016/understanding-onedrive/content/
Want to remove security warnings message bar which is frequently appearing on your Excel spreadsheet but don’t know how to disable security warnings in Excel.
Even if you don’t know such things. Don’t get worried…!
You can fix this issue on your own just by making few changes in the setting. To know what changes, you need to perform go down to this post.
As the post covers complete information about, three most commonly encountering security warnings in Excel. Moreover, it also acknowledges you about how to disables Excel security warning messages.
About Security Warning Message Bar In Microsoft Excel
Security Warning Message Bar mainly encountered in three situations.
- When you have Excel read-only file which you want to edit. To do so you need to enable the editing option.
- At the time of opening a workbook, Excel gives warning you’re your workbook is having macros. So, the application takes your confirmation whether you want to enable them.
- when excel spreadsheet contains potentially unsafe active content like ActiveX controls in the excel file you are trying to open.
In these cases, security warning message bar appears yellow, red along with the shield icon. These warning messages are just to alert you about the potential problems.
To stop these warning messages pop-up on your Excel screen you have to disable the message bar. We will discuss about steps to disable each of these Excel warning messages one by one. So, go through it…!
Fix “ActiveX Controls Has Been Disabled” Security Warning In Excel
This particular excel security warning message appears when you open a file containing ActiveX controls. You will see a message “Activex control has been disabled” along with a shield icon and Enabled Content button. All these are packed within a yellow box.
After being completely confirmed that the controls are from trusted source, follow up the instructions:
- from the appearing Message Bar, tap to the Enable Content this will open file and it is a trusted document.
Below shown image, displays the Message Bar when ActiveX controls are present in your Excel file.
Enable ActiveX controls in the Backstage view
Alternatively, you can enable ActiveX controls in Excel file through the Microsoft Office Backstage view. Well this backstage view appears after clicking on File tab, at the time of appearance of the yellow Message Bar. For here is the complete step to perform this procedure. Follow this carefully.
- Hit on the File
- Now in Security Warning message area, hit Enable Content
- Within Enable All Content, tap to the Always enable this document’s active content
After doing this step the file is counted as a trusted document.
Fix “Macro Has Been Disabled” Security Warning In Excel
In Excel macro is used to automate repetitive task. So, whenever you need to perform that task you just have to run the macro. Here is this section we will learn about how to fix “Macro Has Been Disabled” Security Warning in Excel.
Change macro settings in the Trust Center
Well this issue can be fixed by changing the Macro settings located in trusted center. If you are working in the organization, then chances are also that system administrator have changed macro default settings. Usually this is done to prevent third person from making any changes in the settings.
Important:
Changing macro settings from Trust Center, only applicable for currently using MS Office program not for all office programs.
- Hit on the File
- Tap to the Options.
- Now hit on the Trust Center, after then tap to the Trust Center Settings.
- From the Trust Center, tap to the Macro Settings.
- Select anyone out of these options. Use the information in the following section to learn more about macro settings.
- Disable all macros without notification:
Choosing this option will disable the macros and security alerts regarding macros
- Disable all macros with notification:
This option will disable only the Macros not the security alerts.
- Disable all macros except digitally signed macros
In this case also Macros is only disabled but not the security alerts. If the available macro in you excel spreadsheet is digitally signed by any trusted publisher then it will run. Otherwise, notification starts coming for enabling the signed macro and trust the publisher.
- Enable all macros (not recommended, potentially dangerous code can run):
Through this option all type of macros will run. Choosing this setting will makes your PC susceptible to potentially unsafe code.
- After making selection tap to the OK
How To Disable “Protected View” In MS Excel
Excel triggers some specific “protected view” settings by default. This is just to prevent any user from downloading or opening any potentially infected file. Either coming from internet or sent by anyone from Email etc.
WARNING — it’s highly recommended to disable “Protected View” settings in MS Excel setting only if the file is a trusted one.
Excel For Mac 2016 How To Get To The Backstage Area In Animal Crossing
Steps To Disable Protected View
- First of all, open the Excel application. After then select the “File”menu option.
- Choose the “Options”
- Now select the “Trust Center” option and tap to the “Trust Center Settings”
- Now it’s time to select the “Protected View” from left sidebar. Read the three options carefully and un-check the desired options.
After making such changes now you can enjoy opening any of your Excel files without any “Protected View” security warning.
Enable Or Disable Security Alerts On The Message Bar For All MS Office Applications
The steps mentioned in this section is applicable for all MS office application. So, you don’t have to go through each application and make such changes.
- In the Office program, tap to the File
- Hit the Options.
- Select the Trust Center. On the same opened page, you will see the option Trust Center Settings, tap on it.
- Now tap to the Message Bar. This will open the dialog box ”Message Bar Settings for all Office Applications”. Here you will see two options:
- “Show the Message Bar in all applications when document content is blocked.”
It is a default option. The security warning Message Bar appears when any potentially malicious content has been disabled.
- Never show information about blocked content
If you choose this option then it will disable the security warning Message Bar. After then no alerts regarding security issue will appear on your Excel spreadsheet.
Conclusion:
Hopefully you have got enough idea on how to remove excel securing warning message bar. So, from now onwards don’t get annoyed with such, just follow down the steps and turn it off.
Apart from this, we advise you to don’t make any security settings in trust center. As this may leads to loss of data, data theft, security vulnerabilities on your PC.
Excel For Mac 2016 How To Get To The Backstage Area In The World
Margret
Margret Arthur is an entrepreneur & content marketing expert. She writes tech blogs and expertise on MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in easy to understand language is very impressive. When not writing, she loves unplanned travels.