In Microsoft's popular Excel application, if you want to access those slightly more complex editing options, you need to access the toolbar at the top, also officially known as the ribbon.
Despite this, on certain occasions and teams, as also happens with Microsoft PowerPoint, or even with the well-known word processor Microsoft Word, it is possible that instead of finding you the options bar what you find are only the tabs at the top (Home, Insert…), And that only when you press these options are displayed, something that may be slightly uncomfortable when working, depending on your personal tastes.
Table of Contents
What to do if the toolbar is not displayed in Microsoft Excel
For this tutorial, the method varies depending on your version of Microsoft Office, since if you have the one from 2010 or earlier, you must follow the steps indicated below. Also say that this only applies to computers with Windows operating system and not to macOS.
Latest versions of Microsoft Office
If you have one of the latest versions of Microsoft's Office suite, you will have a little easier. In the top bar, right next to where the buttons to close and minimize the application appear, you will also find a button shaped like a window, known as "Presentation options". You just have to click on it and the different configurations to choose from will appear. Specific, if you choose "Show tabs and commands" you will get the standard Excel view.
If the button doesn't appear or you have an older version of Microsoft Office
On the other hand, it is possible that for whatever reason the button in question that we mentioned above does not appear, or that you have a version of Microsoft Office from 2010 or earlier, in which the procedure in question was a little different. For these cases, There is no definitive solution, because as we mentioned it is different in each version, but it is always easy to find.
What you should look for is a button that allows you to display the Excel options bar, or that allows you to set it. In both cases they must be found in the Right upper corner, and sometimes appears with an icon of a Arrow down, and in others what appears is, by accessing one of the tabs at the top, when the ribbon of options appears temporarily, a small kind of thumbtack to anchor the bar. You just have to locate said button and, as soon as you press it, it will stay fixed at the top without problems.