A menu bar can be the built-in menu bar or a custom menu bar.), or close an open menu and submenu at the same time. Select the menu bar (menu bar: The horizontal bar below the title bar that contains the names of menus.
Move to the top or bottom of the selected gallery list Scroll up or down in the selected gallery list When a menu or submenu is visible, select the first or last command on the menu or submenu To display a shortcut menu, right-click an item or press SHIFT+F10.) open a drop-down menu for the selected gallery item Open a shortcut menu (shortcut menu: A menu that shows a list of commands relevant to a particular item. Open the selected menu, or perform the action assigned to the selected button Move among choices in a selected submenu move among certain options in a group of options
MICROSOFT EXCEL KEYBOARD SHORTCUTS CHEAT SHEET FULL
When a task pane is active, select the next or previous option in the task paneĭisplay the full set of commands on the task pane menu (You may need to press CTRL+TAB more than once.) To display a toolbar, press ALT and then SHIFT+F10.) is active, move to a task pane. When a menu or toolbar (toolbar: A bar with buttons and options that you use to carry out commands. (You may need to press F6 more than once.) Its location and small size allow you to use these commands while still working on your files.) from another pane in the program window. Move to a task pane (task pane: A window within an Office application that provides commonly used commands. Perform the action for the selected item in a smart tag menu. Select the previous item in a smart tag menu. Select the next item in a smart tag menu. If more than one smart tag is present, switch to the next smart tag and display its menu or message. Maximize or restore the selected workbook window.Ĭopy a picture of the screen to the Clipboard.Ĭopy a picture of the selected window to the Clipboard.ĭisplay the menu or message for a smart tag. Use the arrow keys to resize the window, and when finished press ENTER. When a workbook window is not maximized, perform the Size command (on the Control menu for the workbook window). Use the arrow keys to move the window, and when finished press ESC. When a workbook window is not maximized, perform the Move command (on the Control menu for the workbook window). When more than one workbook window is open, switch to the next workbook window. Switch to the previous pane in a worksheet that has been split. Switch to the next pane in a worksheet that has been split (Window menu, Split command). Restore the window size of the selected workbook window. Alternatively, press Control + Option + V or Command + Option + V.Microsoft Excel 2003 Keyboard Shortcuts - printable cheatsheet Microsoft Excel 2003 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, 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 column 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)
