Mac Excel 2008 / 2011+. Quick Reference – The Most. Editing Cells. Ctrl + Arrows. Skip Word(s). Ctrl + Shift +.

It turns out that some of the commands in Mac Excel can’t actually be rebound. For instance, Allison, wants to have these work.

Here is the list and how to get them Mac Excel. For Mac Excel we have a list. Control + page up. This maps to Ctrl-Right which is find the next empty cell. On a Mac laptop there is no Page Up or Page Down keys, they only have arrow keys, so can’t remap these. Need to use an extended 101 keyboard for this to work. The Mac equivalent is Command-F6 and Command-Shift-F6 to go back a worksheet The function keys are gotten by typing FN-F1 since the Mac uses the function keys for other things: F2.

This is so strange, with the Mac, it maps to Ctrl-U and there is no way to get F2 for EDIT and need a shortcut. You can get this with Quickeys F4. This is Command-T on the Mac (“techjive”:The only way to get this to work for Excel is some sort of shortcut.

You can get this with Quickeys to map it. This is the Goto function and it works F9. Recalc which is CMD-W The main issue is that normally Mac Excel makes F9 their own shortcut, so you have to turn off keyboard shortcuts for Expose. Ctrl-R.Copy from the cell on left into this cell.

This works in Mac Excel and is called the Right function Ctrl-D. Copy from the cell above down to here. Not sure what this does but on Mac, Alt keys actually puts in special character Shift+F2.

Insert comment. This works in Mac Excel Alt+E, S, T. Opens the edit menu, then s choose paste specials and then format. You have to get this with Quickeys Control + 1. Format Cells.

Need to change in the Excel Keyboard Shortcuts since it is select object on the Mac and format cells is command-1. Insert Column. Which I actually do as Ctrl-Space and then Ctrl-+, but you need a key remapper to do this. Same thing, but it is actually Ctrl-Shift-Equal Control+P. Works this is File/Print Control+Y. This is redo and is mapped to Command-Y on the Mac, but Control-Y is unassigned, so use Excel to map Control+Tab.

This is next workbook. It works in Mac Excel. Note that Alt-Tab on the PC is Command-Taq on the Mac which you need Quickeys can’t remap Some of my favorites are Ctrl-$ for currency format. Works on Mac Ctrl-% for perfentage. Works on Mac Ctrl-Shift-Arrow. Select to the rigth Ctrl-PgUp navigates through worksheets Ctrl-PgDn navigates through worksheets.

Ctrl-Minus is Delect Ctrl-Shift-Plus is Insert Ctrl-* is fill in Shift-Space selects a row Ctrl-Plus inserts a row Ctrl-Minus deletes a row.

Hi all, I have a document with over 1,000 subtitles for a film (I have it in both Word and Excel versions). Most of the subtitles have 2 lines, which are separated with this character: In Word (Windows or Mac), I can easily replace all the with a line break (^p). How can I do it in Excel for Mac? Is there a way to represent the line break within the Excel “Replace” tool, just like ^p in the Word “Replace” tool? Or is there a way to paste a Word table (which has line breaks within the table cells) into Excel, keeping the line breaks? You need to double-click directly in the cell that you want to put a line-break.

Doing this the old Microsoft way in the top part of the screen (the formula bar) where you can see what’s in the cell. For example, if you enter a formula +c5+d5 in a cell, the cell itself will show you the result of the formula but the formula bar will show the actual formula. You used to be able to put a line break while you’re in the formula bar but with Excel for Mac, you have to be in the cell itself for the Option+Command+Enter to insert a line break.