The keyboard shortcuts described here refer to the U. Ctrl+F2 displays the print preview area on the Print tab in the Backstage view. Alt+F8 Open the Microsoft Visual Basic For Applications Editor. Ctrl+Shift+colon : Enter the current date. Ctrl+C Copy the value of field. Moves to the next option or option group in a dialog box. In this case you can just copy and paste the symbols.
Here you will find shortcuts for Outlook, OneNote, and PowerPoint, as well as links to my blog posts about keyboard shortcuts for Microsoft Office programs like Excel and Word. Ctrl+Shift+Plus + Open the Delete dialog box to delete selected cells. Tab Move focus to the next control or element on a page, such as actions, buttons, fields, or list headings. Ctrl+Page Down Move one screen to the right in a worksheet. An optional hyphen tells Word not to use a hyphen, unless the word breaks at the end of a line. However, I have discovered there is a system unique to Word which is ctrl+'+letter or ctrl+'+shift+letter.
Ctrl+2 Bolds all cells in the highlighted section. Scrolls to display the set of tiles above the current tiles in view. If the field is in focus, and you have not selected any text in the field, this will copy the entire value. When a cell reference or range is selected in a formula, F4 cycles through the various combinations of absolute and relative references. Ctrl+Shift+U Cancel an entry in the cell or Formula Bar.
Ctrl+End Select all text in the formula bar from the cursor position to the end. If you wish to do so you could copy this line and paste it into the document. Make sure to press End again before pressing the next arrow key. You can also use the shortcut to turn italics off. Shift+Tab Move focus to the previous control or element on a page, such as actions, buttons, fields, or list headings.
Tab In editable list, move in the same row to the next field to the right. Google Charts This is used to display charts and graphs on articles and the author center. If the bookmark is not in a folder, moves to the next bookmark at the same level. No data is shared unless you engage with this feature. Quick Entry Shortcuts for Fields The following shortcuts pertain to the Quick Entry feature on cards, documents, and list pages. Whether such commands are implemented or not depends on how an actual application program such as an editor is written. The Alt+ Space combination opens the window menu, and the following key selects from the menu.
Moving Around in a Document You can use keyboard shortcuts to easily navigate throughout your document. Ctrl+Shift+F3 Open and close the filter pane. If the cursor is in the formula bar, Ctrl+End moves the cursor to the end of the text. Ctrl+End Cmd+End Close the calendar and delete current the date. Left Arrow Scroll to the left when the page is zoomed in so that it is not entirely in view. Ctrl+Enter Complete a cell entry and select the cell above.
The page inspection pane shows information about the page, like its source table, fields, filters, extensions, and more. Enter Move the cursor to the end of the text when in the formula bar. Ctrl+K Check spelling in the active worksheet or selected range. F11 Creates a chart of the data in the current range in a separate Chart sheet. Now, does anyone expect you to memorize all these keyboard combos? Ctrl+Shift+F3 Creates names by using those of either row or column labels. Shift+F2 Allows the user to edit a cell comment. Alt+M Open the Data tab and connect to, sort, filter, analyze, and work with data.
Ctrl+F1 Open a context menu. Ctrl+E Invoke to automatically recognize patterns in adjacent columns and fill the current column Ctrl+F Displays the Find and Replace dialog box, with the Find tab selected. When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box. Use the arrow keys to move the window, and when finished press Enter, or Esc to cancel. Alt+Spacebar Opens the system menu. Alt+Page Down moves one screen to the right in a worksheet.
Archived from on 9 June 2012. Assignment Leave your browser window open. Alt+F3 Toggle filtering to the selected value. If the Bookmarks window contains folder, bookmarks in folders are skipped. Ctrl+O Opens a previously saved document. You can use the shortcuts to apply formatting to selected text or to whatever you type next if no text is selected. In a data form, it moves to the first field in the next record.
HubPages Google Analytics This is used to provide data on traffic to our website, all personally identifyable data is anonymized. Moves to the next option or option group in a dialog box. This does the same as choosing Filter to this value from a column heading. Opens a selected menu press F10 to activate the menu bar or performs the action for a selected command. As the menu labels and their underlined hotkeys vary with the Windows system language, the hotkeys are different for international versions of Microsoft Windows, and may change if users change their Windows system language preference.