Share
In office 2007 (and 2010) you can immediately collapse the ribbon by pressing CTRL+F1.
Thanks to Loranga for sharing this tip.
Share this tip with your colleagues
Simple, fun and useful emails, once per week.
Learn & be awesome.
Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME. Read my story • FREE Excel tips book
From simple to complex, there is a formula for every occasion. Check out the list now.
Calendars, invoices, trackers and much more. All free, fun and fantastic.
Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.
Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.
Let’s say you have daily data and your boss wants to see the trends by week in month or week in quarter? How do you calculate the week number in a month or quarter? In this article, let me explain the logic and formulas we can use Excel for this.
One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.Â
© All rights reserved.
6 Responses to “Use CTRL+F1 to collapse ribbon [super-mini-quick-tip]”
...or double-click one of the tabs.
Let me know next time you are in Sweden 😉
@Loranga... I am going to be Stockholm from monday to saturday next week to meet a customer. Do you live in stockholm by any chance?
@JJ... Thank you... that is of course part of our double click tricks post as well - http://chandoo.org/wp/2009/06/12/excel-mouse-tricks/
Nope I live in a town called Östersund, it's only 550 kilometers north of Stockholm. 😉 You're welcome, just let me know.
@Loranga... wow.. that is really up north... I dont think I can make it this time. But may be some other time... Thank you so much for the invitation.
Ctrl+F2 = Print preview