Express elder sister as, ferial in often follow Excel contact with, in Excel is being shared below, I compare commonly used little skill, assure simple, practical, everybody can learn.
One, fast sue for peaceEverybody knows Excel sue for peace, some people use SUM formula, some people nod symbol of sue for peace with the mouse directly, but this is not the most businesslike method. The method of sue for peace with the rapiddest rate is: Data of pitch on begin, by " direction of Ctrl + Shift + bolts " fast pitch on is whole / travel data, next " Alt + = " key can direct will whole / list data sue for peace, does the ox force not?
Generally speaking, blank value will be right our data statistic is affected somewhat, the means of settlement is direct fill of will blank value is become 0 OK. How does that locate all blank are worth quickly? Press " F5 " function of key v fixed position, choice " position condition " → " blank value " OK.
Believe everybody has encountered this kind of situation certainly: Input " 01 " , before the result " 0 " disappeared automatically, input Id, the result became scientific counting method. How to solve? Very simple, add an only quote in front of what input content directly ' OK, the attention is the only quote below English.
When we insert cavalcade, be commonly " right key " - " insert row / row " . But if want insertion travel / if the row is overmuch, such efficiency are very low. More efficient way is to resemble laying a plan such:
The divine class shortcut key in Excel -- F4. Can duplicate operation of on one pace, applied setting is extensive. For instance format fill, repeat input some paragraph the word is OK it is finished easily.
This is my commonly used 5 Excel skill, it is very simple learn easily practical, hope to be helped somewhat to everybody.
