Mac Excel Shortcuts

Here is the official list from Microsoft

The strange things are they are different. For instance F4 is paste whereas in Windows Excel is it change relative to absolute. And F2 is edit cell whereas it is cut text. And again, there is this strangeness that you use the Option key where you use the Ctrl key in windows even though there is a Ctrl key on new Mac keyboards.

Equivalent of Windows Excel F4 key in Excel 2008 for the Mac

Navigating in Excel
Switch between Worksheets fn-CTRL-PageUp/fn-CTRL-PageDown
Switch between Workbooks fn-`
Select entire worksheet Cmd+A
Move to the beginning of the line. fn+left arrow(home)
Go To fn + F5
Move a Sheet/Copy a Sheet Alt-E-M
Change Zoom Sizing Alt-V-Z

Entering and editing data
Complete a cell entry and select…
Delete cell and then get inside the cell DELETE
Delete cell/selection. fn+DELETE
Edit inside a cell (edit cell mode) CTRL+U
Once inside edit cell mode (F2)…
…Start a new line in the same cell. OPTION+CMD+ENTER
…Delete the preceding character. DELETE
…Delete the character to the right of the insertion fn + DELETE
Spell Check. fn + F7
Insert a comment. fn+SHIFT+ F2
Undo the last action. cmd+z
Redo the last action. cmd + y

Selecting, grouping, inserting, and deleting cell
Ungroup Rows or Columns SHIFT+ALT+LEFT ARROW KEY
Clear the contents of the selected cells. DELETE
Delete the selected cells. CTRL+MINUS SIGN SAME
Insert blank cells. CTRL+SHIFT+PLUS SIGN SAME

Copying and Pasting Shortcut
Copy, then Paste Special Formats Alt-E+S+T
Copy, then Paste Special Formulas Alt-E+S+F

Formatting Data Shortcut Example
Display the Style dialog box. CMD+SHIFT+L
Display the Format Cells dialog box. CMD+1
CTRL+SHIFT+! 1,254.34
Currency format: 2 decimal places (negative numbers in parentheses): CTRL+SHIFT+$ $1,254.34
Percentage format with no decimal places. CTRL+SHIFT+% 125434%
Exponential number format with two decimal places. CTRL+SHIFT+^ 1.25E+03
Boldface CMD+B
Italicize CMD+I
Underline CMD+U
Strikethrough CMD+SHIFT+_
Apply the outline border to the selected cells. CMD+Option+Arrow Key
Remove the outline border from the selected cells. CMD+Option+Arrow Key

Enter and calculate formulas Shortcut Example
Start a formula. = (equal sign) =F45*G12
In a formula, display the Insert Function dialog box. fn+SHIFT + F3
Recalculate all worksheets in all open workbooks. F9
Anchoring “Fixing” Cells F4 – must be in edit cell mode (CTRL+U) =$F$4*G125
Go to precedent cell(s) CTRL-[

Naming cells, Hyperlinks, inserting time and dat
Name a cell. fn+CMD+F3
Display a drop-down list of the values in the current cALT+DOWN ARROW

MacBook Air Disk problems and how to Remote Bookt

Well, when my machine was freezing, I was used to Windows so my first thought was, uh oh, the hard disk is crashing. Ran Disk Utility and it asked me to Repair the disk with the installation Mac OS X. First note, you should always have this DVD with you whereever you go (I didn’t), since it does things that the operating system can’t do.

Second, pray your SuperDrive doesn’t get erratic and won’t turn on. Mine did this exactly.

Third, you can actually “remote boot”: from any Windows machine if you have that magic OS X installation DVD. it is a little arcane, but as “Apple”: lays out you:

# you basically find another Mac or Windows machine.
# On a Mac, you then run _/Applications/Utilities/Remote Install Mac OS X_
# On a Windows machine, you insert the Mac OS X Install Disc 1 and choose _Remote Install Mac OS X from the Install Assistant
# Click continue twice and then choose the network connection, either AirPort for wifi or Ethernet if you are using the USB Ethernet Adapter on your MBA
# Restart start your MBA and hold the Option key during start up.
# From here you can run Disk Utility from your remote install disk.