Why I am getting problem in Excel?
When a worksheet is opened in Excel, I am not able to see toolbars. Why is this happening?
How can I get it back on ? Is there any process to make it work again or I have to install again.
Please help.
When a worksheet is opened in Excel, I am not able to see toolbars. Why is this happening?
How can I get it back on ? Is there any process to make it work again or I have to install again.
Please help.
Well, I guess you probably hide ribbon and you don't know how to unhide it. Don't worry, you don't need to install it again, of course.
It's simple to put it back. All you have to do is just click the (up) down arrow in the upper right corner of the Excel application and the toolbars will show again. (You can see it on the pictures (examples) below this text)
You can also use CTRL + F1 keyboard shortcut to show/hide the ribbon, that is maybe even simpler and faster.
Hope I helped you. Ask if you need anything else.
Tool bars and ribbon can be shown or hidden in an excel sheet as follows.
First I will assume that the ribbon is hidden when you open an excel work book.
Right click on the blank space which is in after the View or Developer menu .Then removes the tick on the “Minimize the ribbon option”.
Then the ribbon will be shown as follows.
After go to the view tab and tick on the check boxes of the options for Formula bar and Headings. Then the formula bar and the Heading will be shown as follows.
This is the way that you can see the tool bars and ribbon on an excel sheet. However if you are unable to view them by using these method there could be a problem with your excel installation. In case of such problem you will have to install Microsoft office again properly.