Excel
|
Microsoft Excel
- Tech and Technology
|
| Microsoft Excel
- Tips and Tricks - Keyword Shortcuts
|
| Keyboard shortcuts for Microsoft Excel
|
Formatting How to format cells, rows and columns?
| Keystroke = Function
| | [Ctrl]B = Bold the selection
| | [Ctrl]I = Italicize the selection
| | [Ctrl]U = Underline the selection
| | [Ctrl]5 = Strike through the selection
| | [Alt] and ' = Open the Style dialog box
| | [Ctrl]1 = Open the Format Cells dialog box
| | [Ctrl][Shift]~ = Apply General format
| | [Ctrl][Shift]$ = Apply Currency format
| | [Ctrl][Shift]% = Apply percentage format
| | [Ctrl][Shift]# = Apply Date format
| | [Ctrl][Shift]@ = Apply Time format
| | [Ctrl][Shift]! = Apply Number format
| | [Ctrl][Shift]^ = Apply Exponential number format
| | [Ctrl][Shift]& = Apply an outline border to selection
| | [Ctrl][Shift] and _ = Remove outline border from selection
| Navigation How to move in cells?
| Move to the next worksheet in a workbook = [Ctrl][Page Down]
| | Move to the previous worksheet in a workbook = [Ctrl][Page Up]
| | Cycle between open workbooks = [Ctrl][F6]
| | Move one cell up, down, left, or right = Arrow keys
| | Move to the edge of the data region = [Ctrl] and an arrow key
| | Move to the beginning of a row = [Home]
| | Move to the beginning of a worksheet = [Ctrl][Home]
| | Move to the end of the used portion of a worksheet = [Ctrl][End]
| | Move between panes in a split worksheet = [F6]
| | Display the active cell = [Ctrl][Backspace]
| | Move down a cell in a selected range = [Enter]
| | Move up a cell in a selected range = [Shift][Enter]
| | Move one cell to the left in a selected range = [Shift][Tab]
| | Move from corner cell to corner cell in a selected range = [Ctrl] and . (period)
| Selection How to select cells, columns and rows?
| Selection techniques
| | Select a row = [Shift][Spacebar]
| | Select a column = [Ctrl][Spacebar]
| | Select an entire worksheet = [Ctrl]A
| | Select from current cell(s) to the beginning of the row = [Shift][Home]
| | Select from current cell(s) to last used cell in row = [Shift][End][Enter]
| | Select from current cell(s) to the beginning of the worksheet = [Ctrl][Shift][Home]
| | Select from current cell(s) to the end of the used portion of a worksheet = [Ctrl][Shift][End]
| | Select the data region surrounding the active cell = [Ctrl] and *
| | Select all cells that contain a comment = [Ctrl][Shift]O
| | Select cells that a selected formula directly references = [Ctrl] and [
| | Select formulas that directly reference the active cell = [Ctrl] and ]
| Workbook How to work with documents?
| Workbook basics
| | Open a workbook = [Ctrl]O
| | Create a new workbook = [Ctrl]N
| | Save a workbook = [Ctrl]S
| | Open the Save As dialog box = [F12]
| | Print a workbook = [Ctrl]P
| | Close a workbook = [Ctrl]W
| | Insert a new worksheet = [Shift][F11]
| | Hide selected rows = [Ctrl]9
| | Display hidden rows in selection = [Ctrl][Shift]9
| | Hide selected columns = [Ctrl]0
| | Display hidden columns in selection = [Ctrl][Shift]0
| | Open the Find tab of the Find And Replace dialog box = [Ctrl]F
| | Open the Replace tab of the Find And Replace dialog box = [Ctrl]H
| | Run a spelling check on a worksheet or selected text = [F7]
| Data How to work with databases?
| Working with data. Import and export files.
| | Complete an entry and move to the next cell = [Enter]
| | Insert a new line within a cell = [Alt][Enter]
| | Enable editing within a cell = [F2]
| | Fill selected cells with an entry you type = [Ctrl][Enter]
| | Fill data down through selected cells = [Ctrl]D
| | Fill data through selected cells to the right = [Ctrl]R
| | Create a name = [Ctrl][F3]
| | Insert a hyperlink = [Ctrl]K
| | Insert the current date = [Ctrl] and ; (semicolon)
| | Insert the current time = [Ctrl] and : (colon)
| | Cut the selected text or objects to the Clipboard = [Ctrl]X
| | Copy the selected text or objects to the Clipboard = [Ctrl]C
| | Paste the contents of the Clipboard = [Ctrl]V
| | Repeat last action = [Ctrl]Y
| | Undo last edit = [Ctrl]Z
| | Delete from the insertion point to the end of the line = Ctrl][Delete]
| | Add blank cells = [Ctrl][Shift]+
| | Delete selected cells = [Ctrl]- (hyphen)
| | Create a chart from a range of data = [F11]
| Formula How to make formulas with cells?
| Formula shortcuts
| | Begin a formula = =
| | Enter a formula as an array = [Ctrl][Shift][Enter]
| | Display the Insert Function dialog box (Paste Function in Excel ) = [Shift][F3]
| | Paste a defined name into a formula = [F3]
| | Insert a SUM AutoSum formula = [Alt]=
| | Display the Function Arguments dialog box = Type a function in the Formula bar and press [Ctrl]A
| | Copy the value from the cell above the current cell into the current cell = [Ctrl][Shift] and "
| | Copy a formula from the cell above the current cell into the current cell = [Ctrl] and '
| | Toggle between display of formulas and cell values = [Ctrl] and `
| | Calculate values for sheets in all open workbooks = [F9]
| | Calculate values for the current worksheet = [Shift][F9]
| | Cancel an entry you're making in a cell or in the formula bar = [Esc]
| | | | | | |