Regard an accountant as the person, apply Excel software adroitly to undertake data processing and making all sorts of accountant form is indispensable skill etc. Here trimmed fundamental operation of the part, the hope helps ~ somewhat to fiscal fellow student is being joined first
1, shift arrives the brim of current data area: CTRL+ arrowhead key moves travel head: HOME
Shift makes the start of the watch to labour: CTRL+HOME
Shift makes the last unit case of the watch to labour: CTRL+END moves downward one screen: PAGEDOWN
Move up one screen: PAGEUP
Move right one screen: ALT+PAGEDOWN
Towards the left is mobile one screen: ALT+PAGEUP
Shift works to the next in working book watch: CTRL+PAGEDOWN
Move to express to a job: CTRL+PAGEUP
Move to leave one job book or window: CTRL+F6 or CTRL+TAB
Book or window work before moving: CTRL+SHIFT+F6
The next window case in moving to already tore open minute of job book: F6
Shift arrives to be gotten on mediumly by the working book of fractionation case of a window: SHIFT+F6
Roll and show mobile unit pattern: CTRL+BACKSPACE
Show " fixed position " dialog box: F5
Show " search " dialog box: SHIFT+F5
Repeat last time " search " operation: SHIFT+F4
The blame lock in protecting labour tabulation decides unit move between case: TAB
2, of Excel shortcut key when be in END mode
Mobile in labour tabulation, open or shut END mode: END
Inside group or row with data piece moves for the unit: END, arrowhead key
Shift makes the last unit case of the watch to labour: END, HOME
Move right in current travel division of unit of blank of the last blame: END, ENTER
3, of Excel shortcut key be in " scroll lock is decided " the shift in the watch is working when mode
Open or shut scroll lock to decide: SCROLLLOCK
The unit case that shift handles to the top left corner in the window: HOME
Shift arrives in the window the unit case of right place playing role: END
Up or be down scroll group: Arrowhead bolts on or next arrowhead bolt
Towards the left or roll right one: Left arrowhead bolts or right arrowhead bolts
4, of Excel shortcut key use at preview and printing documentation
Show " print " dialog box: CTRL+P
Printing in previewing when:
When enlarge shows, mobile in documentation: Arrowhead key
Should narrow when showing, roll every time in documentation one page: PAGEUP
Should narrow when showing, scroll arrives the first page: The arrowhead on CTRL+ bolts
Should narrow when showing, scroll arrives last page: CTRL+ leaves arrowhead key
5, of Excel shortcut key use at be versed in tabulation, chart is mixed grand
Insert new class tabulation: SHIFT+F11
Found the chart that uses current area: F11 or ALT+F1
Show " grand " dialog box: ALT+F8
Show " VisualBasic editor " : ALT+F11
Insert tabulation of MicrosoftExcel4.0 grand labour: CTRL+F11
The shift next job in working book expresses: CTRL+PAGEDOWN
A shift work in working book expresses: CTRL+PAGEUP
The watch works with the next currently in choosing working book: SHIFT+CTRL+PAGEDOWN
Choose current job book or book of a job: SHIFT+CTRL+PAGEUP
6, the tabulation of choice chart labour of Excel shortcut key
Below one piece of job in choosing working book expresses: CTRL+PAGEDOWN
Choose a job in working book to express: CTRL+PAGEUP, END, SHIFT+ENTER
7, the in be being used at working to express data-in of Excel shortcut key
Finish unit case to input and next moving is in in area of make choice of: ENTER
Fold in unit case row: ALT+ENTER
With the unit division section that inputs a fill make choice of currently: CTRL+ENTER
Finish unit case to input and go up in area of make choice of move: SHIFT+ENTER
Finish unit case to input and right in area of make choice of move: TAB
Finish unit case to input and left in area of make choice of move: SHIFT+TAB
Cancel unit case input: ESC
Delete the character that thrusts bit of left, or delete section of make choice of: BACKSPACE
Delete the character that thrusts bit of right, or delete section of make choice of: DELETE
Delete insert the text that orders an end: CTRL+DELETE
To fluctuation the left and right sides moves a character: Arrowhead key
Move travel head: HOME
Duplicate the last operation: F4 or CTRL+Y
Edit unit case annotate on: SHIFT+F2
Establish a name by travel or row mark: CTRL+SHIFT+F3
Be down fill: CTRL+D
Right fill: CTRL+R
Definition name: CTRL+F3
8, the setting data format of Excel shortcut key
Show " style " dialog box: ALT+'(casts order)
Show " unit case format " dialog box: CTRL+1
Apply " groovy " digital format: CTRL+SHIFT+ --
Application takes two fraction " lend money " format: CTRL+SHIFT+$
Application does not take fraction " per cent " format: CTRL+SHIFT+%
Application takes two fraction " science notes number " digital format: CTRL+SHIFT+^
Use date " date " format: CTRL+SHIFT+#
Applied hour and minute " time " format, indicate in the morning or afternoon: CTRL+SHIFT+ @
Application has 1000 separator and negative number uses minus (- ) express: CTRL+SHIFT+ !
The frame outside application: CTRL+SHIFT+&
The frame outside deleting: CTRL+SHIFT+_
Apply or cancel font to add thick form: CTRL+B
Apply or cancel font to tilt format: CTRL+I
Apply or cancel underline format: CTRL+U
Apply or cancel to delete line format: CTRL+5
Conceal row: CTRL+9
Cancel to conceal row: CTRL+SHIFT+(left bracket
Obscure a line: CTRL+0(0)
Cancel to obscure a line: CTRL+SHIFT+) right bracket
9, the editor data of Excel shortcut key
Edit mobile unit division and will insert a dot to set line fine: F2
The input in cancel unit case or editing column: ESC
Edit mobile unit division and keep clear of content of some of its Central Plains: BACKSPACE
The name that will define is stickup in formula: F3
Finish unit case input: ENTER
Regard array as formulary input formula: CTRL+SHIFT+ENTER
After function name is keyed in in formula, show formulary option board: CTRL+A
Variable name and bracket insert for this function after function name keys in in formula: CTRL+SHIFT+A
Show " the spelling checks " dialog box: F7 key
10, the insertion of Excel shortcut key, delete and area of duplicate pitch on
Area of duplicate make choice of: CTRL+C
Cut area of make choice of: CTRL+X
Area of stickup make choice of: CTRL+V
The content of area of cleared make choice of: DELETE
Delete section of make choice of: CTRL+ hyphen
Cancel the last time operates: CTRL+Z
Insert blank and unit case: CTRL+SHIFT+ plus
11, of Excel shortcut key mobile inside pitch on area
Inside area of make choice of by go up to move downward: ENTER
Move by next upgrade inside area of make choice of: SHIFT+ENTER
Inside area of make choice of by left toward right shift: TAB
Inside area of make choice of by right toward left shift: SHIFT+TAB
By the clockwise shift arrives the next horn of area of make choice of: CTRL+PERIOD
Right the area of make choice of that moves to be not photograph adjacent: CTRL+ALT+ right arrowhead bolts
Left the area of make choice of that moves to be not photograph adjacent: CTRL+ALT+ left arrowhead bolts
12, the choice unit division of Excel shortcut key, row or travel
Make choice of is current the area all round unit case: CTRL+SHIFT+*(asterisk)
Expand area of make choice of width of an unit case: SHIFT+ arrowhead bolts
The final blame sky that area of make choice of expands unit case travels together to list together is unit case: CTRL+SHIFT+ arrowhead bolts
Expand area of make choice of travel head: SHIFT+HOME
Begin what area of make choice of expands the job expresses: CTRL+SHIFT+HOME
What expand area of make choice of the job expresses is the last used unit standard: CTRL+SHIFT+END
Make choice of is whole: CTRL+SPACEBAR
Make choice of is whole: SHIFT+SPACEBAR
Whole job expresses make choice of: CTRL+A
If make choice of many unit case a make choice of is among them unit case: SHIFT+BACKSPACE
Expand area of make choice of downward one screen: SHIFT+PAGEDOWN
Expand area of make choice of up one screen: SHIFT+PAGEUP
Make choice of an object, job of make choice of expresses all boy or girl friends that attend: CTRL+SHIFT+SPACEBAR
In a switch that conceals object, indication object and object to take an a surname: CTRL+6
Show or conceal " commonly used " tool column: CTRL+7
other area medium unit case adds in pitch on area: SHIFT+F8
Expand area of make choice of the unit case of window top left corner: SCROLLLOCK, SHIFT+HOME
Expand area of make choice of the window is right the unit case of next horn: SCROLLLOCK, SHIFT+END
13, of Excel shortcut key pitch on area develops when be in End mode
Open or shut END mode: END
The final blame sky that expands area of make choice of unit case arranges a person of the same trade together is unit case: END, SHIFT+ arrowhead bolts
Expand area of make choice of the division of the last unit of data includes on labour tabulation: END, SHIFT+HOME
Expand area of make choice of the last unit case in current travel: END, SHIFT+ENTER
14, the choice of Excel shortcut key contains division of special character unit
The current area all round division of unit of pitch on activity: CTRL+SHIFT+*(asterisk)
Pitch on is current array, this array is the array that place of mobile unit division belongs to: CTRL+/
Make choice of is all the unit case that takes annotate on: CTRL+SHIFT+O(letter O)
In choosing to go, do not go with this inside the unit pattern that the cost of mobile unit division matchs: CTRL+
Do not list with this in pitch on row inside the unit pattern that the cost of mobile unit division matchs: CTRL+SHIFT+ |
Make choice of cites formularily directly in area of current make choice of unit case: CTRL+[(left square brackets)
Make choice of is current the formula in area of make choice of direct or all unit case of indirect referencing: CTRL+SHIFT+{is left big bracket
The unit case that make choice of guides the formulary seat that uses current and unit standard continuously: CTRL+](right bracket)
Make choice of is all the unit standard that contains formula, these formula direct or indirect referencing is current and unit case: CTRL+SHIFT+} is right big bracket
Fundamental operation is so much, always one suits your ~ to collect those who rise to be able to help you sooner or later
