When it returns to grey, it’s off. If you’re using Windows 8, you can also use the Charms bar to search for “run” and launch the run dialog from there. Pro tip: scroll lock status in Excel. If your keyboard doesn’t have a scroll lock light, or you’re not sure if scroll lock is on, look at Excel’s status bar. I have Excel for Mac 11 and also use Excel 97, Excel 07 and Excel 10 on various Windows machines. Needless to say, there is confusion all over the place with the different menus, shortcuts, ribbons. Shortcuts are different, keyboards are different.
Our company uses Excel 2013 running on Windows, but one of our employees wants to switch to a Mac. If we allow him to do this, will his Mac-based Excel files be compatible with the rest of our office’s Windows users, and are there any specific differences between Excel for Mac and Excel for Windows?
Generally speaking, Excel versions for Mac and Windows are reasonably compatible. The below summarizes the primary functional differences between the Mac and Windows editions of Excel.
To overcome those differences, some Mac owners run Excel for Windows through a virtual machine solution called Parallels Desktop 10 ($79.99), which then allows users to purchase and run Windows (starting at $99.99) on their Macs. Similar virtual machine solutions include Apple’s Boot Camp Windows (free); and VMWare Fusion 7 ($69.99).
The content area in the Excel workbook is generally small. The ribbon area occupies the top portion of excel containing tool icons and text descriptions for each menu tabs.
When you have a larger excel sheets, you should get rid of the ribbon area to get convenient space. It also makes sense to show or hide that ribbon when you needed. In this article let us discuss how to show or hide ribbon in Excel on Windows and MacBook.
![Excel Excel](/uploads/1/2/5/3/125379457/211020898.jpg)
Though we have explained with Excel, all these tricks will work on all Microsoft Office applications like Excel, Word and PowerPoint. Related: Show or Hide Ribbon in Windows 1. Use Arrow Button The easiest way is to click the small up arrow shown at the right end of the ribbon.
This will hide the ribbon showing all the menu items, thus allowing to have some visible area for cells. No Collapse Ribbon Option Here comes the use of handy. Simply press “Ctrl + F1” keys to toggle the ribbon on or off. This means you can hide and show the ribbon by pressing these shortcut keys.
We recommend to use this shortcut keys instead of using the arrow or right click to hide ribbon. This should also work on Word, PowerPoint and all Microsoft applications. Auto Hide Ribbon You can also automatically hide the ribbon and show only when you click on the top bar. Click on the arrow button showing next to minimize icon. Choose “Auto-hide Ribbon” option. Show Ribbon Again For permanently enabling it back, click on the arrow button again and choose either “Show Tabs” or “Show Tabs and Commands” option. Pin the Ribbon The last option is to pin your ribbon.
Follow the below steps to pin the ribbon on excel:. Press “Control + F1” to hide the ribbon first. Click on any of the menu items to view the ribbon again.
Now you will see a small pin icon at the lower right corner of the ribbon. Click on it and the ribbon. This will ensure the ribbon is always there when you work on that spreadsheet. Customize Ribbon in Excel There are two drop-downs in the right pane, “Choose commands from” and “Customize the Ribbon”. Choose the required items and move to the needed tabs. You can also enable, disable, reorder and regroup the tabs. If something goes wrong click “Reset all customizations” from the “Customizations” dropdown to set the ribbon back to initial settings.
![Excel in mac Excel in mac](/uploads/1/2/5/3/125379457/310781760.png)
Related: Control Ribbon Appearance on Excel Mac Similar to Windows, you can use shortcuts and customize the ribbon appearance in Mac also. Toggle Ribbon in Excel Mac with Shortcut Keys Simply press ‘Command + Option + R’ to toggle the ribbon on Excel. This means ribbon will show when you press the shortcut keys first time and then will be hidden if you press second time. Use Arrow to Hide or Show Ribbon Another easiest way in Mac is to click on the arrow nearer to right corner. This arrow will show up when the ribbon is visible and show down when the ribbon is hidden. Click on it to show or hide the ribbon as you need. Excel Preferences in MacBook On the Ribbon dialog box, uncheck “Turn on the ribbon” box.
Also remember “Command + Option + R” shortcut keys will work on Mac Excel, only if you have turned on Ribbon in preferences. Hide Ribbon When Workbook Opens Another option is to hide the ribbon whenever a new workbook is opened.
For enabling this option, go to Excel Ribbon preferences and uncheck the option ‘Expand ribbon when workbook opens’. After opening the workbook, you can toggle the ribbon appearance either using the arrow or with shortcut keys.
You can also click on the gear icon and go to ribbon preferences directly.