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.
#MICROSOFT EXCEL MAC SHORTCUT 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. (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. 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.’ 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. Alternatively, press Control + Option + V or Command + Option + V.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. If you often paste special elements in your workbook, use the Control + Command + V shortcut to quickly access the Paste Special dialog box. The “Paste Special” feature comes in handy in situations where the standard canopy-paste functionality isn’t appropriate. Think of “Control + Z” as taking the trash out (of your worksheet) and Control + Y as bringing it back in. That will “redo” a recently-reversed action. To reapply the last action or formula you undid in Excel, press Command + Y or Ctrl + Y. Undo Changesĭid you enter invalid or incorrect data in your worksheet? Or, do you simply want to reverse a recently-executed action? Whack Command + Z or Ctrl + Z on your Mac’s keyboard to undo the most recent action applied to the worksheet. That explains why they’re on this list as some of the best Excel keyboard shortcuts.
You probably already use them every day, and they sure help you get things done faster. Some hotkeys in this section are system-wide keyboard shortcuts that work in every app on your Mac. Press Command + 1 to open the dialog box.
Say you want to change Excel’s date format or currency format, you do so in the Format Cells dialog box. In the Format Cells dialog box, you get access to extensive formatting options for numbers, alignment, fonts, etc. You can also use these shortcuts to undo or remove the respective formatting you applied to a cell. Command + I and Command + U will apply the “italic” and “underline” formatting to the selected column, rows, or cells. Select the cell(s) you want to modify and press Command + B to apply the bold formatting. These are commonly used text formatting attributes in Excel and other Microsoft tools. Select the cells, rows, or columns whose font sizes you want to reduce and press Shift + Command + < (the Left angle bracket key). This is equally as easy as increasing font sizes. Simply select the cell, row, or column and press Shift + Command + >. You can also increase the font size of a specific cell, row, or column.
0 kommentar(er)
