How to Unhide the Formula Bar in Excel 2010
There are many different elements that make up the layout of a Microsoft Excel 2010 worksheet, but some people prefer not to use all of them. In some instances these elements can be hidden from view if the person working on the file deems them to be distracting or unnecessary. These settings often remain associated with the Excel 2010 program, which means that someone else who was previously using Excel may have hidden something and never unhidden it, causing it to be hidden when you open the program.
While you can still create formulas by directly entering them into a cell, some people prefer using the formula bar instead. But others find it to be an unnecessary waste of screen space, or they might be confused by its’ functionality. In some cases, they elect to hide the formula bar rather than ignore it. If you find yourself working on an Excel file and you do not see the formula bar above your spreadsheet, then you can follow a few simple steps to unhide it.
Show the Formula Bar in Excel 2010
These steps will show you how to display the formula bar above your spreadsheet if it has been hidden. The display of the formula bar is a setting that will carry over between different spreadsheets, regardless of the setting that is applied to that specific file. For example, if you hide the formula bar on one spreadsheet, it will also be hidden on the next spreadsheet that you open.
Step 1: Open your spreadsheet in Excel 2010.
Step 2: Click theViewtab at the top of the window.
Step 2: Check the box to the left ofFormula Barin theShowsection of the navigational ribbon.
The formula bar should now be visible above your spreadsheet, as in the image below.
Is Excel 2010 displaying formulas in your cells instead of the answers? This article will show you how to change that behavior to show the formula results instead.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.
Show or hide the ribbon in Office
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.
Show Ribbon options
At the top-right corner, select the Ribbon Display Options icon.
Choose an option for the ribbon:
Show Tabs and Commands keeps all the tabs and commands on the ribbon visible all the time.
Show tabs shows only the ribbon tabs, so you see more of your document, and you can still quickly switch among the tabs.
Auto-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.
Collapse the ribbon or expand it again
Double-click any of the ribbon tabs or press CTRL+F1 to collapse the ribbon if you need to see more of your document.
To see the ribbon again, just double-click any ribbon tab, or press CTRL+F1.
If the ribbon isn’t visible at all
If the ribbon isn’t visible at all (no tabs are showing), then you probably have it set to Auto-hide. Select Moreat the top right of the screen. This will temporarily restore the ribbon.
When you return to the document, the ribbon will be hidden again. To keep the ribbon displayed, select one of the Show options above.
Minimize the ribbon
You can minimize the ribbon if you need to see more of the document you are creating. To collapse the ribbon, select the Minimize the Ribbon arrow at the top right.
To see the ribbon again, select the arrow again.
How to show, hide and restore missing ribbon in Excel
In this short tutorial, you will find 5 quick and easy ways to restore Excel ribbon in case it is missing and learn how to hide the ribbon to get more room for your worksheet.
Ribbon is the central point of whatever you do in Excel and the area where most of features and commands available to you reside. Do you feel the ribbon takes up too much of your screen space? No problem, one click of your mouse, and it is hidden. Want it back? Just another click!
How to show ribbon in Excel
If the ribbon has disappeared from your Excel UI, don’t panic! You can quickly get it back by using one of the following techniques.
Show collapsed ribbon in full view
If the Excel ribbon is minimized so that onlytab names are visible, do one of the following to get it back to a normal full display:
- Press the ribbon shortcut Ctrl + F1 .
- Double-click on any ribbon tab to make the entire ribbon visible again.
- Right-click any ribbon tab and clear the check mark next toCollapse the Ribbonin Excel 2019 – 2013 orMinimize the Ribbonin Excel 2010 and 2007.
- Pin the ribbon. For this, click on any tab to temporarily view the ribbon. A small pin icon will appear at the lower right corner in Excel 2016 and 2019 (the arrow in Excel 2013), and you click on it to always show the ribbon.
Unhide ribbon in Excel
If the ribbon ishidden completelyincluding the tab names, here’s how you can restore it:
- To unhide the ribbontemporarily, click at the very top of your workbook.
- To get the ribbon backpermanently, click theRibbon Display Optionsbutton in the top-right corner and choose theShow Tabs and Commandsoption. This will show the ribbon in the default full view with all the tabs and commands.
Similar methods can be used to hide ribbon in Excel, and the next section explains the details.
How to hide ribbon in Excel
If the ribbon takes up too much space at the top of your worksheet, especially on a small screen laptop, you can collapse it to show only the tab names or hide the ribbon altogether.
Minimize the ribbon
To see only the tab names without commands like in the screenshot below, use any of the following techniques:
- Ribbon shortcut. The fastest way to hide Excel ribbon is to press Ctrl + F1 .
- Double-click a tab. The ribbon can also be collapsed by double-clicking anactivetab.
- Arrow button. Another quick way to hide the ribbon in Excel is to click the up arrow in the lower-right corner of the ribbon.
- Pop-up menu. In Excel 2013, 2016, and 2019, right-click anywhere on the ribbon and selectCollapse the Ribbonfrom the context menu. In Excel 2010 and 2007, this option is calledMinimize the Ribbon.
- Ribbon Display Options.Click theRibbon Display Optionsicon at the top-right corner and chooseShow Tabs.
Hide ribbon completely
If you aim to have the largest amount of screen space for a workbook area, use the Auto-hide option to get Excel in kind of full screen mode:
- Click theRibbon Display Optionsicon on the top-right corner of the Excel window, to the left of theMinimizeicon.
- ClickAuto-hide Ribbon.
This will totally hide the ribbon, including all tabs and commands.
Excel ribbon missing – how to restore it
If all of a sudden the ribbon disappears from your Excel, it’s most likely to be one of the following cases.
Tabs show up but commands disappeared
Perhaps you have inadvertently hidden the ribbon with an errant keystroke or mouse click. To show all the commands again, click Ctrl + F1 or double-click any ribbon tab.
Whole ribbon missing
Most probably your Excel somehow got into a "full screen" mode. To restore the ribbon, click theRibbon Display Optionsbuttonat the top-right corner, and then clickShow Tabs and Commands. This will lock the ribbon at the top of the Excel window where it belongs. For the detailed instructions, please see How to unhide ribbon in Excel.
Contextual tabs disappeared
If theTool Tabsspecific to a particular object (such as a chart, image, or PivotTable) are missing, that object has lost focus. For the contextual tabs to appear again, simply select the object.
Add-in’s tab missing
You’ve been using some Excel add-in (e.g. our Ultimate Suite) for a while, and now the add-in’s ribbon is gone. Chances are the add-in was disabled by Excel.
To fix this, clickFile>Excel Options>Add-ins>Disabled Items>Go. If the add-in is in the list, select it and click theEnablebutton.
That’s how you hide and show ribbon in Excel. I thank you for reading and hope to see you on our blog next week!
Hide/Minimize Ribbon In Office 2010 For Distraction-Free Working
Forget 3rd party distraction-free writers, Microsoft has introduced an option to hide the ribbon in Word 2010, Excel 2010, PowerPoint 2010, Outlook 2010, and all other products in Office 2010 suite. Sounds great, right?
Indeed this is one of the many reasons why we love Microsoft Office team more and more with every release. With one click the complete Ribbon can be minimized, showing nothing except the tabs. Check the screenshots below to see how Word, Excel, PowerPoint, and Outlook look like without the Ribbon.
Without the Ribbon, Word 2010 is more like a minimalist stripped down text editor.
Word 2010 without Ribbon
Word 2010 with Ribbon
So how do you minimize the ribbon? Simply click the small Minimize/Expand Ribbon icon(Arrow) on the upper-right corner, before the ‘?’ help icon.
Once the Ribbon is minimized, you can click any tab to bring it back but it will only show temporarily. The ribbon will vanish again when you click anywhere else or start writing. Kudos to Microsoft Office team for implementing this small but brilliant feature in Office 2010.
SUBSCRIBE TO OUR
Thank you…the was a huge help for me! I like having the ribbon open as I do a lot of formatting in Word. I must have accidentally hit the arrow because I lost the ribbon for about a week and it was driving me crazy! Thanks for making me sane again!!
hey, what about Change To Classic Menu without UBitMenu?…
While this is cool and I had discovered it just today while I was working on converting my A2003 apps, I need to be able to use my A2003 menus in the 10 or so applications I have developed these past 15 years. I’d like to have the ribbon not appear in my applications if that’s possible, because some of my users are not going to be able to even do this, sorry.
Aight guys, this is not a place to hate on Microsoft. This was a useful tip, and MS has boosted productivity by a lot – they’re still ahead of the competition holistically, and that’s why you’re using Office.
Maybe in the future, especially after Windows 8, it will be more intuitive. Until then, stick with the damn tip.
We’re using MSOffice because our company bought into the Marketing Machine that is Microsoft. Given a choice, I can think of several products I prefer that do not come from Microsoft. And at home, it is Open Office all the way. Having said that, I am getting used to the interface, but I will never like it as my’ tool of choice.’
Thank you so much! …
oh Sweet Jesus! It’s wonderful to find a group of like-minded users. Although I’ve never liked Word, after 8 years I’d gotten fairly good at it. Now? It takes 10X the amount of time to do what it took me to do intuitively and in a flash. If anything, “Help” has been a godsend (although frankly, I don’t like its new format, either), as I use it constantly to do the simplist of functions. I agree with Le – the idiots that thought this up should be fired.
I have taken great heart from these posts. I have been a heavy Microsoft user for around 15 years and would consider myself pretty proficient in Word, Excel and Ppt. All this has changed with the transfer to Windows 2010 – I now feel like a total novice. A simple task that I used to be able to do in seconds with a single click may now take 30 mins+ as I try to figure out how to do it in the latest version. This is a ridiculous waste of my time and my productivity levels have fallen off a cliff. A simple task such as getting the ribbon to stay on the screen led me to this article, which answered my query by default – no, it’s in no way helpful to get rid of the ribbon, why would anyone want to?? After 9 months use, I still find Windows 2010 counter-intuitive and rue the day it was launched (btw, Powerpoint is by far the worst of the three).
“Kudos to Microsoft Office team for implementing this small but brilliant feature in Office 2010.” – Kudos? For adding a button to make Office work almost as well as it used to before the stupid ribbon was invented?
I am an IT manager and I have used Excel and the rest of Office for 15 years. I agree with some of the others below – “Kudos” and “Brilliant” are not adjectives that remotely apply to the marketing drones who hatched this horrible “Ribbon” paradigm. “Fired” would be better. Even after two years of using it every day, I am still having to stop and think while finding many features – features that were once one or two clicks on a menu. At least in Office 2007 they had not yet dumbed down Outlook. Now in 2010 that’s a struggle too. I will definitely try the recommended UBIT menu.
I came to this page because I was trying for 10 minutes to get the ribbon back. In the old days they put view options on the …. options page or the … view menu. Or even on the “customize ribbon” page. Now it’s a semi-visible squiggly. Ruler display in Word has been made similarly obscure. Displaying a useful document properties screen was easy in Word 2003 but was a parody in Word 2007. “Kudos” for making it easy again in 2010.
Kudos also for a first-time improvement – putting the “paste special” choices on the right click menu. I am gradually learning to recognize the icons so I don’t have to mouse over all the choices to find the right one.
MS Office marketeers, I have a flash for you: Millions and millions of your customers spent their childhood learning to read and write so they wouldn’t have to use pictures to communicate. Over thousands of years, language has developed breadth and nuances of meaning impossible to convey in pictograms that changes with every release. I’m sorry that you have to publish your software in 50 languages, but I would think that the vast market for Office would support more time spent on efficiency for your customers. So please, give us the option to use words.
To generalize my point, it is only with 2010 that I can copy a worksheet with cells longer than 256 characters. It would have been “brilliant” if it was fixed in Excel 97. Fixing it in 2010 is dimly perceptive at best.
Hey, I’m a Microsoft shareholder. Take my dividend this year and give me an Office suite worthy of the second decade of the 21st century before someone else does it for free. If you have to dumb it down so new users aren’t afraid of it, then add a “dumb off” switch for the rest of us. You want us to scream bloody murder instead of snicker when the bean counters threaten to take Office away. Thank You.
Brilliant is designing a user interface that is intuitive and not this horrible one.
How to Find Excel Tool Bar in Excel 2010
In this topic we will learn about how wecan hide toolbars in Excel 2010.
You can Hide Ribbon, Show Tabs and Show tabs with Commands from the bottom top icon of the spreadsheet through the Ribbon Display Option. In Excel this option is available in the top right corner.
- When youclick on Auto-hide Ribbon, then tabs and commands will disappear from the spreadsheet. When you are working on the sheet, the ribbon will be hidden.
To display the hidden ribbon click on the Ribbon Display Options button again and select Show tabs. This will display only the main tabs. If you want the commands in the tab to be visible, you need to click on the specific tab.
- To display all the tabs and its commands click on the Ribbon Display Options button and then
select Show tabs and Commands.
There is another way to show and hide the commands, just double click on the main tab from the ribbon.
The above is the menu which appears when you open the excel file.
So now double click on the “Home” tab as an example and you will that the commands in each tab will disappear.
Now if you double click on the “Home” tab again, you will be able to see the menu commands.