LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #11   Report Post  
Junior Member
 
Posts: 25
Default Unhiding the toolbar

Show collapsed ribbon in full view
If the Excel ribbon is minimized so that only tab 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 checkmark next to Collapse the Ribbon in Excel 2019 - 2013 or Minimize the Ribbon in 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 is hidden completely including the tab names, here's how you can restore it:

To unhide the ribbon temporarily, click at the very top of your workbook.

To get the ribbon back permanently, click the Ribbon Display Options button in the top-right corner and choose the Show Tabs and Commands option. This will show the ribbon in the default full view with all the tabs and commands.

Hope this helps,
Jerry.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to prevent short cuts from disappearing from tool tips? Dima Excel Discussion (Misc queries) 0 April 15th 09 08:02 AM
How to prevent short cuts from disappearing from tool tips? Dima Setting up and Configuration of Excel 0 April 15th 09 08:02 AM
Disappearing Tool and menu bars J Streger Excel Discussion (Misc queries) 3 March 8th 06 03:42 AM
Tool Bar Icons Disappearing John Wood Excel Discussion (Misc queries) 5 September 15th 05 01:00 AM
I am missing view tool bar from tool menu. excel New Users to Excel 1 July 4th 05 07:19 PM


All times are GMT +1. The time now is 05:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"