{oapdf_gg}
Office software is closely linked to the PDF,the PDF is also must have to control!      Set home Page  Add to Favorites  
You are here:Home > OA application skills > EXCEL skills
EXCEL skills
What are the shortcut keys excel improve speed?
Finishing by: Date:2009-04-10 22:30:45 Popularity: Tags:
For the work tables, charts and macros
Insert a new worksheet: SHIFT + F11
Create a chart using the current region: F11 or ALT + F1
Show that "macro" dialog box: ALT + F8
Shows that "Visual Basic Editor": ALT + F11
Insert Microsoft Excel 4.0 macro sheet: CTRL + F11
Move to the next workbook in a worksheet: CTRL + PAGE DOWN
Moved to the workbook in a worksheet: CTRL + PAGE UP
Select the current workbook and a worksheet: SHIFT + CTRL + PAGE DOWN
Select the current workbook or a workbook: SHIFT + CTRL + PAGE UP


Select the chart sheet
Choose the next workbook in a worksheet: CTRL + PAGE DOWN
Select the workbook in a worksheet: CTRL + PAGE UP, END, SHIFT + ENTER


Worksheet used to enter data
Completion of the cell input and the downward movement of the selected region: ENTER
Folding in the cell line: ALT + ENTER
Filled with the current input of the selected range: CTRL + ENTER
Completion of the cell input and the selected region on the move: SHIFT + ENTER
Completion of the cell input and shifted to right in the selected region: TAB
Completion of the cell input and in selected regions of the left: SHIFT + TAB
Cancel input cell: ESC
Delete character left of insertion point, or delete the selected regions: BACKSPACE
The right of insertion point To delete characters, or to delete the selected region: DELETE
Insertion point to delete the text at the end of the line: CTRL + DELETE
To move up and down about a character: the arrow keys
The first line to: HOME
Repeat the last operation: F4 or CTRL + Y
Cell endorsement editorial: SHIFT + F2
By rows or columns to create name signs: CTRL + SHIFT + F3
Fill down: CTRL + D
Filled to the right: CTRL + R
The definition of the name: CTRL + F3

Setting Data Format
Show "Style" dialog box: ALT + '(apostrophe)
Show "format cells" dialog box: CTRL +1
Application of "conventional" digital format: CTRL + SHIFT + ~
Application with two decimal places of the "currency" format: CTRL + SHIFT + $
Decimal places without the application of the "percentage" format: CTRL + SHIFT +%
Application with two decimal places of the "scientific notation" in digital format: CTRL + SHIFT + ^
Application date, "date" format: CTRL + SHIFT + #
Application of hours and minutes "time" format, and indicate morning or afternoon: CTRL + SHIFT + @
Application of separator 1000 and a negative with a negative sign (-) said: CTRL + SHIFT +!
Application outside the borders: CTRL + SHIFT + &
Deleted outside the borders: CTRL + SHIFT + _
Application or cancellation of bold font formats: CTRL + B
Application or cancellation of the font format tilt: CTRL + I
Application or cancellation of the underlined format: CTRL + U
Application or cancel the deletion of line format: CTRL +5
Hidden line: CTRL +9
Unhide line: CTRL + SHIFT + (left parenthesis
Hide out: CTRL +0 (zero)
Unhide out: CTRL + SHIFT +) right parenthesis
 
there isArticle InformationsComment Information
Category column

Site Help | Site Map | Feedback |
OAPDF.COM Copyright 2009 V1.1