Mac Users of Excel, Unite!

Even though you are now 10% of the Excel population, you are derided and despised by Windows/Excel users. Help me put together a set of hints for sophisticated Excel users of the Mac persuasion. Send me your hints and suggestions, and if I include them in this page, you’ll get name/email credit.

Go to my other sites:

· Simon Benninga’s home page

· Introduction to Finance with Excel--course

Keyboard shortcuts in Windows and on the Mac

Windows	What does it do in Windows?	Mac equivalent	Reference
F2	Edits the cell	Control + U	http://excelsemipro.com/2011/02/f2-in-excel-for-mac/
Delete		Fn + backspace: deletes cell contents but doesn’t put you in the cell Backspace: deletes cell contents and leaves you in the cell
F4 within a formula	Toggles the dollar signs to make cell references absolute	Command+T	https://discussions.apple.com/thread/2810263?start=0&tstart=0
F4	Repeats last command	Fn + F4 in Mac is the paste command (like Ctrl+V). BUT the key can be reassigned to parallel the usage in Windows. See http://excelsemipro.com/2011/01/fixing-the-f4-button-in-excel-for-mac/
Alt + F11	Opens VBA editor	Alt + Fn + F11	Used for Getformula. See PFE, Chapter 1 PPT
Ctrl + Z	Undo	Ctrl + Z