【 Weak current College 】 encyclopedia-EXCEL 2007 keyboard shortcuts--Power By 【 China power house network 】

Ctrl combination shortcut keys
　
Key description
Ctrl + Shift + (Unhide any hidden within the selection.
Ctrl + Shift + a) cancel the selection of all the hidden columns.
Ctrl + Shift + & the bounding box to the selected cell.
Ctrl + Shift_ from selected cell to delete the bounding box.
Ctrl + Shift + ~ application "conventional" number format.
Ctrl + Shift + the application with two decimal format in the "currency" (negative numbers in parentheses).
Ctrl + Shift +% of applications with no decimal "percentage" format.
Ctrl + Shift + ^ application with two decimal "index of" format.
Ctrl + Shift + # application with day, month and year of the "date" format.
Ctrl + Shift + @ application with hours and minutes, and am or PM in the "time" format.
Ctrl + Shift + s application with two decimal places, thousands separator, and minus sign (-) sign (for negative values) "value" format.
Ctrl + Shift + * choice around the active cell of the current region (by blank rows and blank columns to the data area enclosed).
In a PivotTable report, it will select the entire PivotTable report.
Ctrl + Shift +: enter the current time.
Ctrl + Shift + "the value from the cell above the active cell into the cell or the formula bar.
Ctrl + Shift + plus sign (+) to display for the Insert blank cells in the "insert" in the dialog box.
Ctrl + minus sign (-) display is used to delete the selected cell of the "remove" in the dialog box.
Ctrl +; enter the current date.
Ctrl + would switch in a worksheet to display cell values and formulas.
Ctrl + ' the formula from the cell above the active cell into the cell or formula bar.
Ctrl + 1 to display the "cell format" dialog box.
Ctrl + 2 to apply or remove bold formatting.
Ctrl + 3 apply or remove italic formatting.
Ctrl + 4 apply or remove an underline.
Ctrl + 5 apply or remove strikethrough.
Ctrl + 6 in hiding objects, displaying objects, and displaying placeholders for objects.
Ctrl + 8 show or hide the outline symbols.
Ctrl + 9 hide selected rows.
Ctrl + 0 to hide the selected columns.
Ctrl + A to select the entire worksheet.
If the worksheet contains data, CTRL + A selects the current region, again by pressing CTRL + A selects the current region and its summary rows, the third press CTRL + A selects the entire worksheet.
When the insertion point is in the formula to the right of a function name, it displays the "function parameters" dialog box.
When the insertion point is in the formula to the right of a function name, press CTRL + Shift + A will insert the parameter name and the parenthesis.
Ctrl + B to apply or remove bold formatting.
Ctrl + C to copy the selected cells.
If you press Ctrl + C twice, you will display the Clipboard.
Ctrl + D to fill with "down" command within the selected range of topmost cell contents and copy the formatting to the cells below.
Ctrl + F to display the "find and replace" dialog box appears with the "find" tab is selected.
Press SHIFT + F5 also displays this tab and SHIFT + F4 repeats the last time the "find" action.
Press CTRL + Shift + F will open the "format cells" dialog box appears with the "fonts" tab is selected.
Ctrl + G to display the "locate" dialog box.
Press F5 also displays this dialog box.
Ctrl + H to display the "find and replace" dialog box appears with the "replace" tab is selected.
Ctrl + I apply or remove italic formatting.
Ctrl + K to new hyperlink to display the "Insert Hyperlink" dialog box, or for selected an existing hyperlink to display the "Edit Hyperlink" dialog box.
Ctrl + n to create a new blank workbook.
Ctrl + O to display the "open" dialog box to open or to locate the file.
Press CTRL + Shift + O to select all cells that contain comments.
Ctrl + P to display the "print" dialog box.
Press CTRL + Shift + P to open the "format cells" dialog box appears with the "fonts" tab is selected.
Ctrl + R to fill with the "right" command will select the leftmost cell in the range of content and copy the formatting to the cell to the right.
Ctrl + S to use its current file name, location and file format saves the active document.
Ctrl + T to display the "create table" dialog box.
Ctrl + U apply or remove an underline.
Press CTRL + Shift + U will expand and collapse the Edit bar to switch between.
Ctrl + V in the insertion point into the Clipboard contents, and replace any selection. Only in the cut or copied an object, text, or cell contents before you can use this shortcut.
Ctrl + W closes the selected workbook window.
Ctrl + X to cut the selected cells.
Ctrl + Y repeat last command or action (if possible).
Use "Ctrl + Z to undo" command to undo the last command or to delete the last keyIn the content.
Displays the AutoCorrect Smart tags, press CTRL + Shift + Z you can use the "undo" or "repeat" command to undo or redo the last automatic correction.