#Remap keyboard excel spread sheet Pc
#Remap keyboard excel spread sheet mac

With the active cell inside the table, go to the Table Tools Design tab. With a bit of help from a third-party program, though, you can achieve the same end result-make F2 edit the current cell in Excel (2004 or 2008) on the Mac. Go to the Insert tab and press the Table button in the Tables section, or use the keyboard shortcut Ctrl + T. Unfortunately, you won’t find the “edit this cell” command listed in Excel’s keyboard customization section, so there’s no apparent way to change the shortcut.

#Remap keyboard excel spread sheet Pc

You’ll probably find quite a few that you didn’t know about.) After many years of using a PC in my prior job, I found the Control-U shortcut not only hard to remember, but harder to type. Screenshot of Windows control panel for Ease of Access keyboard options. For most cases the following 5 steps will work. In my case I put the Template file in a SharePoint Document Library and I put the resulting Excel files in a different library. The next step is to create a copy of the Excel template file to create our unique Excel spreadsheet. (If you’d like to see all of Excel’s keyboard shortcuts, open Help -> Excel Help, then type keyboard shortcuts in the search box, and then select Excel Keyboard Shortcuts in the results box. Sticky Keys enables the user to enter key combinations by pressing keys in. Copy an Excel template file to a new Excel file. Using the View -> Customize Toolbars & Menus menu item (in Excel 2008 View -> Toolbars -> Customize Toolbars/Menus in Excel 2004), you can. On the Mac, the equivalent keyboard shortcut is Control-U, as F2 is assigned to cut the contents of the current cell.

On the PC, you can edit the current cell in place by simply pressing F2.

(You could do it the other way around, of course, setting your PC up to match your Mac.) This works well for most shortcuts, but there’s one in particular that I use all the time that’s immune to this solution: the keyboard shortcut for ‘edit this cell.’

#Remap keyboard excel spread sheet mac

Using the View -> Customize Toolbars & Menus menu item (in Excel 2008 View -> Toolbars -> Customize Toolbars/Menus in Excel 2004), you can change the shortcuts on your Mac to match those on your PC. If you use Excel on both the Mac and the PC, you’re probably aware that there are numerous differences between the two platforms’ keyboard shortcuts.