Excel Shortcuts

Pregunta	Respuesta
Ctrl + Shift + &	applies the outline border to the selected cells
Ctrl + Shift_	removes the outline border from the selected cells
Ctrl + Shift + ~	applies the general number format
Ctrl + Shift + $	applies the currency format with two decimal places (negative numbers in parentheses)
Ctrl + Shift + %	applies the percentage formal with no decimal places
Ctrl + Shift + ^	applies the scientific number format with two decimal places
Ctrl + Shift + #	applies the date format with the day, month, and year
Ctrl + Shift + @	applies the time format with the hour and minute, and AM or PM
Ctrl + Shift + !	applies the number format with two decimal places, thousands separator, and minus sign for negative values
Ctrl + Shift + *	selects the current region around the active cell ( the data area enclosed by blank rows and columns) In a PivotTable it selects the entire PivotTable report
Ctrl + Shift + :	enters the current time
Ctrl + Shift + "	copies the values from the cell above the active cell into the formula bar
Ctrl + Shift + Plus(+)	displays the Insert dialog box to insert blank cells
Ctrl + Shift + Minus(-)	displays the Delete dialog box to delete the selected cells
Ctrl + ;	enters the current date
Ctrl + `	alternates between displaying cell values and displaying formulas in the worksheet
Ctrl + '	copies a formula from the cell above the active cell into the cell or the formula bar
Ctrl + 1	displays the Formal Cells dialog box
Ctrl + 2	applies or removes bold formatting
Ctrl + 3	applies or removes italic formatting
Ctrl + 4	applies or removes underlining
Ctrl + 5	applies or removes strikethrough
Ctrl + 6	alternates between hiding and displaying objects
Ctrl + 8	displays or hides the outline symbols
Ctrl + 9	hides the selected rows
Ctrl + 0	hides the selected columns
Ctrl + D	uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below
Ctrl + E	invoke Flash Fill to automatically recognize patterns in adjacent columns and fill the current column
Ctrl + Shift + F	opens the Format Cells dialog box with the Font tab selected
Ctrl + G	displays the Go To dialog box
Ctrl + H	displays the Find and Replace dialog box with the Replace tab selected
Ctrl + K	displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks
Ctrl + L	displays the Create Table dialog box
Ctrl + O	displays the Open dialog box to open or find a file
Ctrl + Shift + P	opens the format cells dialog box with the Font tab selected
Ctrl + P	displays the Print tab in Microsoft Office Backstage view
Ctrl + Q	displays the quick analysis options for your data when you have cells that contain that data selected
Ctrl + R	uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right
Ctrl + T	displays the Create Table dialog box
Ctrl + Shift+ U	switches between the expanding and collapsing of the formula bar
Ctrl + Alt + V	displays the Paste Special dialog box
Ctrl + W	closes the selected workbook window
Ctrl + X	cuts the selected cells
Ctrl + Y	repeats the last command or action, if possible
F1	displays the Excel Help task pane
Ctrl + F1	displays or hides the Ribbon
Alt + F1	creates an embedded chart of the data in the current range
Alt + Shift + F1	inserts a new worksheet
F2	edits the active cell and positions the insertion point at the end of the cell contents, also move the insertion point into the Formula Bar when editing in a cell is turned off
Shift + F2	adds or edits a cell comment
Ctrl + F2	displays the print preview area on the Print tab in the Backstage view
F3	displays the Paste Name dialog box.
Shift + F3	displays the Insert Function dialog box
F4	repeats the last command or action is possible
Ctrl + F4	closes the selected workbook window
Alt + F4	closes Excel
F5	displays the Go To dialog box
Ctrl + F5	restores the window size of the selected workbook
F6	switches between the worksheet, Ribbon, task pane, and Zoom controls
Shift + F6	switches between the worksheet, Zoom controls, task pane, and Ribbon
Ctrl + F6	switches to the next workbook window when more than one workbook window is open
F7	displays the Spelling dialog box to check spelling in the active sheet or selected range
Ctrl + F7	performs the Move command on the workbook window when it is not maximized, use the arrow keys to move the window and when finished press Enter, or Esc to cancel
F8	turns extend mode on or off. In the extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection
Shift + F8	enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys
Ctrl + F8	performs the Size command when a workbook is not maximized
Alt + F8	displays the Macro dialog box to create, run, edit, or delete a macro
F9	calculates all worksheets in all open windows
Shift + F9	calculates the active worksheet
Ctrl + Alt + F9	calculates all worksheets in all open workbooks, regardless of whether they have changes since the last calculation
Ctrl + F9	minimizes a workbook window to an icon
F10	turns key tips on or off
Shift + F10	displays the shortcut menu for a selected item
Alt + Shift + F10	displays the menu or message for an Error Checking button
Ctrl + F10	maximizes or restores the selected workbook window
F11	creates a chart of the data in the current range in a separate Chart area
Shift + F11	inserts a new worksheet
Alt + F11	opens the Microsoft Visual Basic for Applications Editor, in which you can create macro by using Visual Basic for Applications
F12	displays the Save As dialog box

Siguiente

Descripción

Resumen del Recurso

Similar

	Creado por Amethyst Maxson hace alrededor de 7 años