The Touch Bar of your MacBook Pro changes to show the function keys for you to select, and then it returns to its previous state when you release the Function key.

For some apps, you can make the function keys display permanently in Touch Bar:

1. In System Preferences, choose Keyboard.
2. Click Shortcuts.
3. From the left sidebar, select Function Keys.
4. Click the “+” symbol, then navigate to the app and select it.

Now when you open or switch to this app, Touch Bar always displays the function keys.

You can also use an on-screen keyboard to access function keys:

Oct 21, 2015 - Excel 2016 for Mac brings lots of welcome improvements to the workhorse spreadsheet but also leaves out useful tools.ProsMoving to the. This forum is for general questions and feedback related to Office 2016 for Mac as they pertain to the IT Pro community. 0 1 Question text/html 4/26/2018 6:47:51 PM mzjms 0. To install Analysis toolpak in Excel for Mac, follow below steps. Goto tools or Insert menu. Locate Add-Ins and Click on it. You’ll be prompted to choose from available add-ins. Select Analysis Toolpak. Analysis Toolpak is added. In the rightmost corner. A clear list of over 200 Excel shortcuts for both Windows and Mac, side-by-side. Windows shortcuts in dark gray on the left, Mac shortcuts in white on the right. To recover Excel files that not saved or deleted, even lost on Mac, here we collect 7 ways to retrieve them all, including AutoRecover Excel on mac, free ways to recover Excel files, even best Excel recovery software for mac. Supports Excel for Mac 2016. Also available: Excel Basic (PC). In 24 engaging lessons you will learn how to use math, statistical, logic and text functions, organize data by sorting and filtering, effectively present your data in several chart formats and more. Whether you use Excel for work or study, these tutorials will start you on your.

1. From System Preferences, select Keyboard.
2. Check “Show Keyboard, Emoji and symbol viewers in menu bar”.
3. Choose the viewer icon in the menu bar, then choose Show Keyboard Viewer.
   

An on-screen keyboard appears with function keys that you can click.

Using function keys in Windows

When you use Boot Camp to run Windows on your MacBook Pro, the function keys work the same as they do in macOS. Hold down the Function key on your keyboard, and the function keys appear.

You can also use the Windows on-screen keyboard to access function keys:

1. From the Windows menu, select the Windows Ease of Access menu item.
2. Click On-Screen Keyboard.
3. Click the fn key. The function keys appear in the on-screen keyboard.

You can also make the function keys appear continuously in the Touch Bar while using Windows, without having to hold down the Function key:

1. In the Windows System Tray, click the up arrow to show additional icons.
   
2. Click on the dark grey diamond-shaped Boot Camp icon.
3. Select Boot Camp Control Panel from the menu that appears.
4. Click Yes to allow the Control Panel to run.
5. Click the Keyboard tab.
6. Select 'Use all F1, F2, etc. keys as standard function keys' to make the function keys appear continuously in the Touch Bar all the time. Deselect the checkbox to return the function keys to standard behavior.

Hi

Apple has 'Pages' and 'Numbers' which are able to work with, respectively, Word and Excel files. You can purchase and download both from the App Store in your Dock. Both have the ability to export files as Word and Excel if you need to send files to other people who don't have Macs. Each is $20.

Or, you can purchase Microsoft Office for Mac 2011, which contains both Word and Excel. You can purchase and download it from the Microsoft website. It's $120 per computer, or $150 for three computers.

Matt

Excel For A Mac

Oct 8, 2012 7:27 AM