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. 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. 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. Use the keyboard to work with the ribbon. Use a keyboard to customize the Quick Access Toolbar. Keyboard shortcuts for SmartArt graphics in Microsoft 365 for Windows. There are also some macbook shortcuts for Excel that will be completely different from those on Windows and you need to learn them to save time working. Keyboard shortcuts for the File menu in Microsoft 365 for Windows. On the Mac, the equivalent keyboard shortcut is Control-U, as F2 is assigned to cut the contents of the current cell. For example: On Excel for Windows you press Ctrl + N to create a new workbook, in Excel on Mac you press Command + N to create a new workbook. 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. Shift + F2 (or FN + Shift + F2 on a Mac) adds or edits a comment attached to your selection.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. Command-V : Paste the contents of the Clipboard into the current document or app. Command-C : Copy the selected item to the Clipboard. Command-X : Cut the selected item and copy it to the Clipboard. However, there's a keyboard shortcut available too simply press F2 with the desired cell selected to start editing immediately - on a Mac, you'll need to hit ^ + U. Cut, copy, paste, and other common shortcuts. Once you've found the cell you're looking to work on, you can of course double-click it to start making edits. On a Mac, the command is ^ + an arrow key. For example, to use Command-C (copy), press and hold the Command key, then the C key, then release both keys. Instead, it will take you to the edge of your data in the stipulated direction, which makes it a handy way of finding the last row or column in a particular table. On a blank document, pressing CTRL + an arrow key will simply take you to its outer limits, but on a populated spreadsheet it's much more useful. If you find yourself losing the active cell, worry not - you can navigate to it instantly by pressing CTRL + BACKSPACE on a PC or COMMAND + DEL on a Mac. Learn these shortcuts by heart, and you'll be whipping around your spreadsheet at a mile a minute. You can download a printable PDF version of the list below. Navigation Shortcuts With these shortcuts, you can easily explore your spreadsheet and locate specific cells without wasting time scrolling with the mouse. This page contains a list of over 270 Excel shortcuts for both the keyboard & mouse, including shortcuts for the Windows, Mac, and Web versions of Excel. + E Flash Fill One of Excels greatest tools for auto-completing data based on examples from adjacent cells. Let’s dive into the basics of these essential shortcuts. When you're working with a large Excel document, it can sometimes be a fiddly and time-consuming process just to navigate to the data you need. In this section, you will learn about Excel Mac shortcuts which will help you navigate, select, edit, and format efficiently.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |