![]() Find the keyboard shortcut you want to turn off, then clear the check box.Under Hardware, click Keyboard, then click the Keyboard Shortcuts tab.On the Apple menu, select System Preferences.To use a keyboard shortcut that’s the same as a default Mac OS X keyboard shortcut, you must first turn off that Mac OS X keyboard shortcut. Kind of handy when adjusting headings for a data table. will do the trick and Command+Shift+, will take the font size down one level. Step 3: In the On-Screen Keyboard window, click the Ctrl key, followed by the A key to use the Ctrl + A shortcut, and check if Excel selects all the cells. I learned that to increase the font size one size larger, the shortcut Command+Shift+. But that left me thinking, “Is Repeat and Redo the same?” (Something for another day.)Īnyway, you can peruse the different menu items and look for shortcuts, or the lack of, in this Customize Keyboard dialog box. Ctrl + Shift + ‘+’: Insert a new row above chosen row. For diagonal movement, use Ctrl+Arrow Key. Press Enter or Shift+Enter to move vertically. I tried to add another shortcut key, Command+Y, but the currently assigned key was Repeat. Below are some of the most popular shortcuts in Excel to move rows: Shift + Space: Select the entire row. For speedy navigation between cells in an Excel worksheet, use the Tab and Shift+Tab keys Follow these simple steps: Open a worksheet. Underneath the shortcut key box you see some text that shows the Currently assigned key. I added a shortcut key for Redo by clicking in the box Press new shortcut key, which activated the Add button, then pressed the keyboard combination Control+Y, then clicked Add. (Now I know why F1 doesn’t work for bringing up the Help system.)Ĭhecking for a Redo shortcut (in the picture below) shows none listed. The Current keys assigned to the Undo action are shown as Control+Z, F1, Command+Z. In the picture above I’ve selected the Edit menu and Undo is selected in the right-pane. You’ll notice the Categories correspond to the Menu, and the right-hand pane shows the items within the selected category. If worked, then save the file as Excel Workbook. To see shortcuts in Excel 2011 go to the Tools menu and select Customize Keyboard. According to KeyRocket, use Ctrl + Alt + to trace precedents in Excel 2013. Why that’s important is that in Excel 2011 they left the old menu with the new Ribbon, and this creates a common reference between the Windows and Mac versions of Excel. ![]() In looking for something else, I discovered you can change the keyboard shortcuts in Excel 2011, but the benefit for me is that every shortcut is listed by menu function. This keyboard shortcut opens the Task Manager. Sorry if I get transfixed by shortcuts in Excel 2011, but they are a vital part of how I use Excel and so much different than Excel for Windows, so anything that helps the learning curve is worth the effort. Ctrl+Alt+Delete: Force an unresponsive or frozen program to quit.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |