I just purchased Excel 2024 and noticed that I can't completely hide the ribbon at the top of Excel. In Excel 2019, there was a box in the top right with and up arrow that you could click and the Auto hide the tope ribbon. In Excel 2024 it is gone and the only thing I see is "Collapse the ribbon but there still is a good inch of stuff at the top (like the Excel logo, save button). see attached photo. I just want to see what I did in Excel 2019 and that is the letters at the top of each column. Is this possible in Excel 2024?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Auto Hide Ribbon Gone in Excel 2024
- Thread starter mskli
- Start date
Posting so I can follow and learn something. I've never seen this done without using code. Minimize yes, but not hide. How would you get it back?
Are you sure you're not thinking of the option to hide the QAT?
Are you sure you're not thinking of the option to hide the QAT?
Upvote
0
In excel 2019, there is a button in the top right that allows you to auto hide the entire ribbon and you could also show just tabs or show tabs and commands . In really early versions of Excel, you could do View-Fullpage. However, in Excel 2024 they only allow you to collapse the ribbon - so some it still shown. I managed to get rid of this by using the following simple macros:
Sub GoFullScreen()
Application.DisplayFullScreen = True
End Sub
Sub ExitFullScreen()
Application.DisplayFullScreen = False
End Sub
Unless I'm missing something??
Sub GoFullScreen()
Application.DisplayFullScreen = True
End Sub
Sub ExitFullScreen()
Application.DisplayFullScreen = False
End Sub
Unless I'm missing something??
Upvote
0
I think - mission accomplished!
Upvote
0
Similar threads
- Question
- Solved
- Question
