Microsoft Excel Shortcut Mac vs Windows -- Part 1 (Function Keys)

Action	Windows	Mac
Undo	ctrl + z	F1 / Command + z
Cut text from the active cell	ctrl + x	F2 / Command + c
Edit a cell comment	SHIFT + F2	Shift + F2
Copy text from the active cell	ctrl + c	F3
Open the Formula Builder	SHIFT + F3	Shift + F3
Paste text into the active cell	ctrl + v	F4
Repeat the last Find (Find Next)		Shift + F4
Close the window	ctrl + F4	Command + q / Command + F4
Display the "Go To" dialog box	F5	F5
Display the "Find" dialog box	ctrl + f	Command + f / Shift + F5
Restore the window size.	ctrl + F5	Command + F5
Move to the next pane in a workbook that has been split	F6	F6
Move to the previous pane in a workbook that has been split	SHIFT + F6	Shift + F6
Move to the next workbook window	ctrl + F6	command + F6
Move to the previous workbook window	ctrl + Shift + F6	comand + Shift + F6
Check spelling	F7	F7
Turn on extend selection mode	F8	F8
Add to the selection	Shift+ F8	Shift+ F8
Display the "Macro" dialog box	Alt + F8	Option + F8
Calculate all sheets in all open workbooks	F9	F9
Calculate the active sheet.	Shift + F9	SHIFT + F9
Display a contextual(right-click) menu.	Shift + F10	SHIFT + F10
Maximize or restore the workbook window	Ctrl + F10	Command + F10
Make the first button on a floating toolbar active		OPTION + F10
Insert a new chart sheet.	F11	F11
Insert a new sheet.	Shift + F11	Shift + F11
Insert an Excel 4.0 macro sheet		Command + F11
Display the "Save As" dialog box	F12	F12
Display the "Open" dialog box		Command + F12
Display the "Print" dialog box		CONTROL + SHIFT + F12

MS Excel: Freeze Panes in Excel 2011 for Mac

In the "Layout Ribbon" , on the left-hand side, in "Window" click the panes icon like the following:

My Mac Keyboard Function Key Shortcut Doesn't Work

The keyboard shortcut conflicts with a default Mac OS X key assignment.

Turn off the Mac OS  keyboard shortcut.

For OS X 10.8 (Mountain Lion)

1. Click "system preferences".
2. Under Hardware, click Keyboard
3. Tick "Use all F1, F2, etc. keys as standard function keys.

Change Landscape to Portrait in Excel or Word in Mac

Word
In the layout tab, click orientation

Then, you will see the selection of "Portrait" and "Landscape"

Excel