![]() Show tabs shows only the ribbon tabs, so you see more of your document, and you can still quickly switch among the tabs.Īuto-Hide ribbon hides the ribbon for the best view of your document, and only shows the ribbon when you select More, or press the ALT key.ĭouble-click any of the ribbon tabs or press CTRL+F1 to collapse the ribbon if you need to see more of your document. Show Tabs and Commands keeps all the tabs and commands on the ribbon visible all the time. To keep the ribbon displayed, select a different state from the Ribbon Display Options menu.Īt the top-right corner, select the Ribbon Display Options icon. When you return to the document, the ribbon will be hidden again. This will temporarily restore the ribbon. Select More at the top right of the screen. If the ribbon isn’t visible at all (no tabs are showing), then you probably have the state set to Full-screen mode. Right-click Ribbon display options in the lower right of the ribbon, and then select Collapse the ribbon. If the ribbon is expanded, collapse it by doing do one of the following: Right-click any of the ribbon tabs, and then select Collapse the ribbon. ![]() ![]() If the ribbon is collapsed, expand it by doing do one of the following: You can toggle between having the ribbon expanded or collapsed in multiple ways. Show tabs only shows only the ribbon tabs, so you see more of your document, and you can still quickly switch among the tabs.Īlways show Ribbon keeps all the tabs and commands on the ribbon visible all the time. When the ribbon is visible, in the lower-right corner of the ribbon, click the Ribbon Display Options icon.įull-screen mode hides the ribbon for the best view of your document, and only shows the ribbon when you select More, or press the ALT key. Interested in learning more about what Microsoft Excel can do? Make sure to subscribe to our Sheetaki newsletter to be the first to know about the latest guides and tutorials from us.The ribbon is a set of toolbars at the top of the window in Office programs designed to help you quickly find the commands that you need to complete a task. With so many other Excel features available, you can surely find one that solves your issues. This guide is just one of many useful Excel tutorials that you can follow to help with your workbook issues. This guide has shown how to handle unavailable menu items in various situations, including working with protected sheets and workbooks. These methods should be all you need to remember to unlock grayed out menus in Excel. To unlock these options, you must convert the file to the latest Excel file format. For example, some features may not be applicable when opening a Microsoft 2003 file in compatibility mode. Some menu choices will be grayed out to indicate that the feature is not compatible with the file type. Why are some options grayed out when opening a file in compatibility mode?Ĭompatibility mode allows you to open older files in the latest version of Microsoft Excel.The link attached below is an example of an Excel workbook with a protected worksheet. Another reason the menu options are unavailable is that the user is working on a protected worksheet. The solution for this example is to hit the Enter key to escape the Edit mode. The user cannot currently make edits to the current cell such as applying new formatting. In the example below, we have a spreadsheet where the menu options in the Home tab are grayed out. Let’s take a look at a real example of a spreadsheet with grayed out menu items. In the next section, we’ll take a look at how a grayed out menu looks like on an actual sample spreadsheet.Ī Real Example of Unlocking Grayed Out Menus in Excel This guide will explore the most common reasons why editing cells is not possible and how you can unlock them. This situation is just one possible reason why your menus are grayed out. In order to edit the sheet yourself, you will have to unlock the sheet using a valid password. When a user protects a worksheet, Excel will lock all cells from editing. The file you have just received may contain a protected worksheet. You also observe that the menus in the top ribbon have also been grayed out. You find out that you can’t make any edits to any cells in the sheet. Suppose you have received an Excel worksheet from another user. Let’s take a look at a quick example of a scenario where you may encounter grayed out menus in Excel. How to Unlock Grayed Out Menus in Excel.A Real Example of Unlocking Grayed Out Menus in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |