By submitting this content request, I have legitimate interest in the content and agree that MyExcelOnline. In a worksheet that has been split View menu, Manage This Window, Freeze Panes, Split Window command , F6 includes the split panes when switching between panes and the Ribbon area. Ctrl+B or Ctrl+2 Underline text or remove underline. Note: If an action that you use often does not have a shortcut key, you can to create one. Simply click on the button below and we'll send a quick note to your primary email address confirming this request. Ctrl+I Applies or removes italic formatting. Ctrl+Alt+5, then the Tab key repeatedly Exit the floating shape navigation and return to the normal navigation.
Ctrl+X Cuts the selected cells. In those cases, you can usually enable the shortcut by modifying the language bar hotkey settings and changing the setting e. Alt+Shift+F10 Display the Function Arguments dialog box when the insertion point is to the right of a function name in a formula. Ctrl combination shortcut keys Tip: Download or print a Quick Reference Card:. F7 Display the Quick Analysis options for selected cells that contain data.
F5 also displays this dialog box. Esc Keyboard shortcuts for formatting cells To do this Press Open the Format Cells dialog box. Ctrl+Shift+U Cancel an entry in the cell or Formula Bar. Ctrl+I or Ctrl+3 Bold text or remove bold formatting. Ctrl+Page Up moves to the previous sheet in a workbook.
. Ctrl+F2 displays the print preview area on the Print tab in the Backstage view. Press a second time to select the current region and its summary rows. It works on text and numbers within selected cells. F2 Edits the active cell and positions the insertion point at the end of the cell contents.
This request for consent is made by Corporate Finance Institute, 16th Floor, 595 Burrard Street, Vancouver, British Columbia. Ctrl+Spacebar Select an entire row in a worksheet. Ctrl+Shift+Spacebar Extend the selection of cells to the beginning of the worksheet. F7 Displays the Spelling dialog box to check spelling in the active worksheet or selected range. When a cell reference or range is selected in a formula, F4 cycles through all the various combinations of absolute and relative references.
In a data form, it moves to the first field in the next record. F10 Turns key tips on or off. Learn the top 10 Excel formulas every world-class financial analyst uses on a regular basis. Ctrl+Shift+Page Up selects the current and previous sheet in a workbook. In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection.
Selects the first command on the menu when a menu or submenu is visible. Alt+P Open the Formulas tab and insert, trace, and customize functions and calculations. Note: If an action that you use often does not have a shortcut key, you can to create one. Ctrl+T Displays the Create Table dialog box. Ctrl+Shift+: Enters the current time. Ctrl+3 Applies or removes italic formatting. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program.
Ctrl+Shift+End extends the selection of cells to the last used cell on the worksheet lower-right corner. Press To An arrow key Move cell pointer one cell in direction of arrow key Ctrl+arrow key Move to the edge of the current data region data range bounded by empty cells or worksheet borders in the direction of arrow key Home Move to the beginning of current row Ctrl+Home Move to cell pointer to first cell A1 Ctrl+End -Move cell pointer to last cell in the active area cell in last occupied column and row Page Down Move cell pointer down one screen Page Up Move cell pointer up one screen Alt+Page Down Move cell pointer one screen to the right Alt+Page Up Move cell pointer one screen to the left Tab Move the cell pointer to next unlocked cell in a protected worksheet Shift+Tab Move the cell pointer to previous unlocked cell in a protected worksheet Keyboard Shortcuts for Entering Data in Excel 2003 Filling in all those empty Excel 2003 cells may seem daunting, but keyboard shortcuts ease the pain. Ctrl+K Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks. After pressing Return, move selection, select the direction you want to move in. What are the benefits of using shortcuts? When a Ribbon tab is selected, these keys navigate up or down the tab group. When a cell reference or range is selected in a formula, F4 cycles through all the various combinations of absolute and relative references. In cell editing mode, it deletes the character to the left of the insertion point.