Removes the outline border from the selected cells.Īpplies the General number format in Microsoft Excel.Īpplies the Currency format with two decimal places (negative numbers in parentheses).Īpplies the Percentage format with no decimal places.Īpplies the Exponential number format with two decimal places.Īpplies the Date format with the day, month, and the Time format with the hour and minute, and AM or PM.Īpplies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values. Unhides any hidden columns within the selection.Īpplies the outline border to the selected cells. Unhides any hidden rows within the selection.
Ctrl + Shift + /: apply Scientist format.Microsoft Excel 2007 Keyboard Shortcuts - printable cheatsheet Microsoft Excel 2007 Keyboard Shortcuts. Ctrl + Shift +%: apply Percentage format. Ctrl + Shift + $: apply Currency format. Ctrl + Shift +!: Apply Number format with two decimal places. Ctrl + Shift + &: Add a border to the cell. Ctrl + Shift + space: select the entire sheet. Ctrl + Shift + Page Up: Select the current and previous sheet. Ctrl + Shift + Page Down: Select the current and next sheet. Ctrl + Shift + End: Extend the selection of cells to the last cell. Ctrl + Shift + Home: expand cell selection to start and sheet. Ctrl + Shift + Enter: add matrix formula. 
Ctrl + Shift + O: select cells with comments. Ctrl + Shift + L: activate range filters. Ctrl + Shift + F6: go to previous book. Ctrl + Shift + F3: create names from selection. Ctrl + D: copy the formula on the right. Ctrl + C: Copy the contents of the cells. Shift + F8: add a cell or range of cells. Shift + F6: move between sheet, options and status bar. Shift + F3: Insert Function dialog box. Alt + F11: Open Microsoft Visual Basic for Applications editor. Alt + F10: Selection and visibility panel. 
F11: Create a chart sheet with a range of cells. F9: solves the formulas of the active sheets. F8: Activate the Expand Selection mode. F3: Displays the Paste Name dialog box. Function keysĪs usual in many of the programs that we use daily, the function keys can help us to speed up the use of some features. Ctrl + cursors: go to the end of the data area. Ctrl + Page Up: previous sheet in a book. Ctrl + Page Down: next sheet in a book. The main user interface of this program is made up of a huge number of cells, so moving between them freely is also important. Tab: complete the entry and place to the right. Shift + Tab: complete the cell entry and place on the left. Shift + Enter: Complete the cell entry. Ctrl + Delete: Erase the text to the end of the line. Ctrl + Enter: Fill the selected range of cells. Ctrl + ‘: Copy the formula from the top cell. Ctrl + “: Copy the value from the top cell. Alt + Enter: Inserts a line break inside. Alt + Down: Opens a list of data validation. Ctrl + Shift + *: Select the area around the active cell. Ctrl + Shift + End: extends the selection to the last used cell. Ctrl + Shift + Home: Extend the selection to the first cell used. Ctrl + Shift + Cursors – Extends the selection to the last non-empty cell. Shift + cursors: extend in a specific direction. Shift + Page Up – extends the selection upward. Shift + Page Down – Extends the selection downward. Shift + Home: Extend the selection to the start of the row. 
Shortcuts for working with data and formulasĮntering data in the spreadsheet is key in this program, so these shortcuts will be very helpful. Tab: places us in the cell on the right.Delete: delete all the contents of a cell.Backspace: delete the contents of a cell in edit mode.Start: move to the beginning of the row.Space: Activate or deactivate the check boxes.
#Excel keyboard shortcuts printable series
The program presents us with a series of shortcuts to functions and actions that we can use at the touch of a key, as we will see below. Ctrl + Shift key shortcuts Microsoft Excel keyboard shortcuts Simple Excel shortcuts.Shortcuts for working with data and formulas.
0 kommentar(er)
