Rechecks dependent formulas, and then calculates all cells in all open workbooks. Pressing a third time selects the entire worksheet Performs the size command (on the control menu for the workbook window) when a workbook is not maximized use the arrow keys to move the window, and when finished press enter, or esc to cancel Performs the move command on the workbook window when it is not maximized. Opens the microsoft visual basic editor, in which yon can create a macro by using visual basic for applications (vba) Moves to the previous sheet in a workbook
Moves to the previous cell in a worksheet or the previous option in a dialog box Moves to the edge of the current data region in the worksheet Moves one screen to the right in a worksheet Moves one screen to the left in a worksheet Move on cell up, down, left, or right in a worksheet Maximizes or restores the selected workbook window If the cursor is in the formula bar, selects all text in the formula bar from the cursor position to the end-this does not affect the height of the formula bar If the cursor is in the formula bar, moves the cursor to the end of the text if more than one smart tag is present, it switches to the next smart tag and displays its menu or message.ĭisplays the open dialog box to open of find a fileĭisplays the shortcut menu for a selected itemĭisplays the spelling dialog box to check spelling in the active worksheet or selected rangeĭuring formula typing, adjusts the reference type, abs to relative, otherwise repeats last actionĮnables you to add a nonadjacent cell or range to a selection of cells by using the arrow keysĮxtends the selection of cells by one cellĮxtends the selection of cells to the beginning of the worksheetĮxtends the selection of cells to the last used cell on the worksheet (lower-right corner)įills the selected cell range with the current entry
#List of excel keyboard shortcuts full#
It also doses full screen mode when this mode has been applied, and returns to normal screen mode to display the ribbon and status bar again.Ĭompletes a cell entry and selects the cell aboveĬopies a formula from the cell above the active cell into the cell or the formuula barĬopies the value from the cell above the active cell into the cell or the formula barĬopies values from cell above to current cellĬreates a chart of data in the current rangeĭisplays the control menu for the microsoft office excel windowĭisplays the delete dialog box to delete the selected cellsĭisplays the insert dialog box to insert blank cellsĭisplays the insert hyperlink dialog box for new hyperlinks or the edit hyperlink dialog box for selected existing hyperlinksĭisplays the macro dialog box to create, run, edit, or delete a macroĭisplays the menu or message for a smart tag. Closes an open menu or submenu, dialog box, or message window. in cell editing mode, it deletes the character to the left of the insertion pointĪlternates between hiding objects, displaying objects, and displaying placeholders for objectsĪpplies the currency format with two decimal places (negative numbers in parentheses)Īpplies the date format with the day, month, and yearĪpplies the exponential number format with two decimal placesĪpplies the number format with two decimal places, thousands separator, and minus sign (-) for negative valuesĪpplies the outline border to the selected cellsĪpplies the percentage format with no decimal placesĬTRL + SHIFT + the time format with the hour and minute, and am or pmĪuto sum selected cells and places value in cell beneathĬalculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculationĬancels an entry in the cell or formula bar.
also clears the content of the active cell. Shortcut Keyĭeletes one character to the left in the formula bar.
#List of excel keyboard shortcuts download#
You can print this page or you can download here. I have listed some of the shortcut keys of Microsoft Excel below. Even users with a basic knowhow of Excel can become more efficient by learning keyboard shortcuts. Microsoft Excel is frequently used by finance and accounting professionals on a daily basis.
0 kommentar(er)
