Monday, May 27, 2013

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 "Finddialog 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.

Tuesday, May 14, 2013

Change Landscape to Portrait in Excel or Word in Mac

In the layout tab, click orientation

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