fokibuster.blogg.se

1. #MICROSOFT EXCEL MAC SHORTCUT FOR MAC#
2. #MICROSOFT EXCEL MAC SHORTCUT PC#
3. #MICROSOFT EXCEL MAC SHORTCUT SERIES#

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. For home For business Get Microsoft 365 apps for Mac Start quickly with the most recent versions of Word, Excel, PowerPoint, Outlook, OneNote, and OneDrivecombining the familiarity of Microsoft 365 and the unique Mac features you love. 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. NOTE: Many basic Windows shortcuts, like CTRL+V for paste or CTRL+O to open a worksheet, can be executed on a Mac by pressing (command) instead of CTRL. 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. To move to the beginning or end of a column. Just remember D for down, R for right.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. Press Command + Left Arrow to move to the beginning of a row or Command + Right Arrow to move to the end of a row. Then, press Command + D to copy the contents to the cells below or Command + R to copy the contents to the cells on the right. Highlight the specific cell you want to copy, along with the other cells you need to copy the contents to. Command + semicolon ( ) inserts the current time, while Control + semicolon ( ) inserts the current date.įor a faster way to copy the contents of a cell into perpendicular cells, Command + D or Command + R can do the trick. The actions in the macro can be executed from.

Go to the cell where you want to insert the AutoSum formula, then press the shortcut.Ĭommand + Semicolon ( ) and Control + Semicolon ( )Īdding a date and timestamp to your worksheet is easy with these shortcuts. The macros can also be linked to different trigger types like keyboard shortcuts, a command button or a graphic. Use keyboard shortcuts to deliver PowerPoint presentations. But on a Swedish keyboard, + is the default action on the key, and holding shift turns it into a, causing Excel to open the help panel instead. Use keyboard shortcuts to create PowerPoint presentations. The default Mac answer is to use cmd + shift + +.

#MICROSOFT EXCEL MAC SHORTCUT SERIES#

If you have a series of numbers you want to get the sum of, use Shift + Command + T. Here you'll find links to most keyboard shortcut articles for Microsoft 365 apps. Excel will automatically format the rows and columns into a table. Need to make a table out of the data you already have? Select the appropriate cells and hit Command + T or Control + T.