In the dialog enter the name as AverageandSum and leave it stored in This Workbook. (If you don't have data to populate this sheet, you can enter =RandBetween(10,1000) in all the cells to create dummy data.) Next, click on Developer in the Ribbon. Then fill out your sales data for the day. Your sheet should match the screenshot above.Īdd a new tab, and copy your template into it.

I used 24-hour time, but you can use AM/PM notation if you prefer. Then in the first column put a break down of hourly totals from 8-5. Across the top add Monday through Friday. Using this first blank as a template to copy into a new tab each day could save you some time. If you work in retail or other sales position, this is a helpful sheet to track revenue. Your macro is going to add a daily sales total, and then add an average in the last column of each hourly period. Click on your macro name and click Run to run your recorded actions.Įxample 1: Daily Sales Total and Hourly Averageįor an example macro, you are going to run through a daily sales sheet, with the sales broken down by hourly totals. Clicking macros will bring up the saved macros in your workbook. Once you record your actions, they are available on this same tab. The Personal Macro Workbook is in your user profile and lets you use your macros between your files. You can scope your macro to the Current Workbook, a New Workbook, or in your Personal Macro Workbook. Click this, and a dialog pops up allowing you to name your macro and set a keyboard shortcut. For example, you could un-assign F9 from Mission Control so that F9 can be available in other applications.You're looking for the third option in the Ribbon, Record Macro.

You can change the keyboard shortcuts that are assigned to function keys in the Keyboard Shortcuts pane. This is because it's nice to be able to access the Mac dashboard, brightness, and volume without having to press Fn at the same time. In general, unless you are using Excel all day on a Mac, you will probably find it more convenient to leave the default behavior alone and learn to use the Fn key for certain shortcuts in Excel.

If you check the checkbox, F1 - F12 will behave standard function keys, and you will need to press Fn in order to perform the actions indicated by special icons. When unchecked, function keys will perform as described in #1 above. keys as standard function keys unchecked'. The setting is a checkbox labeled 'Use all F1, F2, etc. Changing default behaviorĪ setting in System Preferences, in the Keyboard pane, controls default behavior for function keys. For example, Fn-F10 will perform the action assigned to the F10 key instead of toggling mute on or off. If you want to instead use F1 - F12 as standard function keys, hold the Fn key while pressing the function key. For example, the function key F10 has a small picture of a speaker, and pressing this key mutes and un-mutes the system volume. The default behavior of Mac function keys is to perform the action indicated by the icon printed on the key. In this case, the action performed will vary depending on (a) the application you are currently using or (b) the keyboard shortcuts listed in the Keyboard & Mouse pane of System Preferences. (1) to perform special actions that correspond to the icon printed on the key, such as dimming or brightening the screen, showing the Dashboard, increasing or decreasing speaker volume, and so on. On a Mac, function keys can be used in two ways: These keys (F1 - F12) are called function keys. Modern Mac computers using an Apple keyboard have icons printed on some of the keys on the top row of the keyboard. This is especially important with Excel, which uses a number of function keys for shortcuts. If you want to master Excel keyboard shortcuts on a Mac, you need to take a moment to understand how the Mac keyboard is arranged, and how it can be configured through system preferences.

Excel for mac how to