Skip to main content

Ctrl+F1 Excel Shortcut Key To Minimize / Restore Back Ribbon Bar In Workbook | Exceltip2day

Hello again everyone. I'm Michael. In this article, I'm going to talk about what is the Excel shortcut: "Ctrl+F1" been proceeding for.

Tip Quiz


What is an Excel shortcut to open a dialog box menu?

On every Excel worksheet has the "Order Functions" on a ribbon. They lay on the "Tabs Menu Bar".

The ribbon bar is containing and displaying the Excel order functions. The ribbon size is around two centimeters. It always takes some space in the spreadsheet area while it has been opening.

Today we are going to seek for the how-to unfold it, ribbon bar, when it is not accessory at a time to show Excel ribbon bar.

Therefore, you will have more space wider in your Excel worksheet to operate your contents in.

See and do repeat steps as below:
  • Pressing the "Ctrl" and keep freeze.
  • Another press onto the "F1"
  • Release both buttons.
That's done.


Shortcut: To minimize or restore the Excel ribbon bar.

Windows shortcut


CtrlF1

Figure no.1 Shows the Excel worksheet with the ribbon bar.


Figure no.2 Shows the Excel worksheet with none ribbon bar.

Once, considering to restore back the ribbon to show up again as it is used to be. Do the same as the ribbon hide method. Just re-do it by pressing both shortcut key buttons again, [Ctrl] + [F1].

Tip Answer

 a. It's both of [Ctrl] + [-].

 b. It's both of [Ctrl] + [A].

 c. It's both of [Ctrl] + [Y].


Source Excel shortcut open dialog box function.

Link recommended👉 : Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'

Link recommended👉 : English Numbers In Words 1 to 1000000

Does it help?

If you love it, please share with your friends.

Thanks and goodbye,

Posted by: Michael Leng



I've known, then I've grown.
See more articles:

Comments

Popular posts from this blog

5 Alternative Shortcut Ways Minimize Your Excel Workbook, Read It Now! | ExcelTip2Day

Do you use Microsoft Excel? If yes, stay with me—I’ll show you how to manage your Excel workbook effortlessly. Hello, I’m Michael Leng. Today, I’m excited to share  five ways to minimize an Excel workbook to an icon . Tip Quiz What to do if your monitor screen upside down? These methods apply to   Excel 2013   (the version I use) and are for   Windows   operating systems. I’ve discovered and tested  five different techniques , which I’ll explain below. 5 methods minimize Excel workbook. ⟴ Use shortcut keys  "Ctrl" and "F9" ⟴   Use shortcut keys  " ALT",  "Spacebar" and "F9" ⟴   Click on the "Minimize workbook" square box. ⟴   Clicking on the "Minimize" command in the "Quick Access Toolbar" ⟴   Use shortcut keys "Window Logo" and "M" To make you more ease seeing all the four pictures clearly, I have made the construction of all the methods for you to follow any of...

[Solved] Turn Off / Turn On Scroll Lock Excel Tip To Lock and Unlock On Keyboard | Exceltip2day Blog

Hello friends. I'm Michael. Welcome everyone to in my blog "Exceltip2day" ,  The tip for today is: " How to unlock the Scroll Lock" Tip Quiz Do you know what is the shortcut key(s) to Redo Last Action (Multiple Levels) in an Excel spreadsheet? Check the way [Turn Off] / [Turn On] - Scroll Lock down here. Excel worksheet, you may touch it accidentally a [Scroll Lock] button. This would lock cursor stuck on the current cell. To undo it, do one of the following: i] Press the Scroll Lock / ScrLk key on your keyboard. Alternatively, if some keyboard does not have a Scroll Lock key, such as Notebook, Tablet and some other kind of PC. Just follow the step by step. ii] (Window 7) Go to -Start, -All Programs, -Accessories, -Ease of Access, -Then, just click on the " On-Screen Keyboard " line. When the "On-Screen Keyboard" appears on your screen, click the ScrLK  button as shown on ( In red round rectangle ) the image be...

Page Down Excel Keyboard Key Button For Moving Down Page Screen One By One | Exceltip2day

Hello there. I'm Michael, welcome you to my blog. Today I'm going to talk about: The 2 ways of moving Excel's screen down. My article consists of how to move the screen of the current spreadsheet you are working on it with the keyboard. Instead of using a scroll down with a mouse, using the button "PAGE DOWN"  keyboard seems more comfortable way. Tab:  Learn Pure Thai FB Tab:  E n  Numbers In Words By the way, you can choose which one is fit for you. Ctrl+0(Zero) Excel Shortcut Key To Hide The Selected Column | ExcelTip2Day Tip Quiz What is the shortcut to close your an Excel workbook instantly? Let's come to the point. Just in case wanting to move the active Excel spreadsheet goes down the page by page. There are two ways to manage it. 👉  1st method:  Using the scroll wheel On your mouse to scroll the worksheet up and down. To roll back or roll into users, the page will move up. On the other hand, to...