{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:
Edit data
Edit active cell and place the insertion point at the end of the line: F2
The abolition of the cell or edit the entry in column: ESC
Edit active cell and clear the contents of the original one: BACKSPACE
The definition of the name will be pasted into the formula: F3
Enter the cell to complete: ENTER
Will enter the formula as an array formula: CTRL + SHIFT + ENTER
In the formula after the function name, type, indicating the formula palette: CTRL + A
Type function in the formula for the function were inserted after the variable name and in brackets: CTRL + SHIFT + A
Show that "Spell Check" dialog box. : F7 key

Insert, delete, and copy the selected region
Copy the selected region: CTRL + C
Cut selected regions: CTRL + X
Paste the selected regions: CTRL + V
Clear the contents of the selected region: DELETE
To delete the selected region: CTRL + hyphen
Undo the last operation: CTRL + Z
Insert a blank cell: CTRL + SHIFT + plus sign

Select the region in the mobile
In selected regions from moving down: ENTER
In selected areas by mobile bottom-up: SHIFT + ENTER
In selected regions by the left-right movement: TAB
In selected regions to the left from the right mobile: SHIFT + TAB
Moving clockwise to the next selected angle region: CTRL + PERIOD
The right to select non-adjacent regions: CTRL + ALT + right arrow keys
Left to select non-adjacent regions: CTRL + ALT + left arrow keys

Select the cell, row or line
Selected the current region around the cell: CTRL + SHIFT + * (asterisk)
Regional expansion of a selected cell width: SHIFT + arrow keys
Selected regions of cells expanded to peer out the final with non-empty cell: CTRL + SHIFT + arrow keys
Selected areas will be extended to the first line: SHIFT + HOME
Selected areas will be extended to the beginning of the worksheet: CTRL + SHIFT + HOME
Selected areas will be extended to the last worksheet cell-use: CTRL + SHIFT + END
Out the entire selection: CTRL + SPACEBAR
Select the entire line: SHIFT + SPACEBAR
The entire worksheet selected: CTRL + A
If you selected multiple cells only one cell selected: SHIFT + BACKSPACE
Down the expansion of the region will be selected on the screen: SHIFT + PAGE DOWN
Upward expansion of the region will be selected on the screen: SHIFT + PAGE UP
Selected an object, selection of all objects in the list: CTRL + SHIFT + SPACEBAR
In the hidden object show placeholder object with the object to switch between: CTRL +6
Show or hide the "common" Toolbar: CTRL +7
there isArticle InformationsComment Information
Category column

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