Wondershare EdrawMind
MindMap Gallery WPS operation skills mind map
- 112
WPS operation skills mind map
This is a mind map about WPS operation skills, including Excel, display, operation, editing, etc. Hope this helps!
Edited at 2023-11-17 23:26:27
- Recommended to you
- Outline
WPS operation skills
Excel
Trivia
Enter @ in front of the Chinese character font in the table to rotate the Chinese characters 90° counterclockwise.
Alt down arrow
Select from the drop-down list (display the drop-down list of existing Chinese characters in the selected cell column)
calculate
Alt =
Consolidate calculations
function lock
function
EVALUATE()
Calculate the written text equation
=SUMIF(A:A,C,B:B)
Function: A is the filter area, C is the filter condition, and B is the numerical range for addition.
=SUBTOTAL(109,B1:B100)
Function: 109 is the operation code for summation, and then sums the column selection. If there are filter conditions, the sum calculation will be re-calculated based on the rows after the filter result to obtain the calculation result of the local dynamic sum.
=COUNTIF(B4:B16,"Credit")
Function: Filter out the number of identical characters or data
=RANK(F1,F:F)
Function: Sort data, generally used for sorting results
=INDEX(G:G,RANDBETWEEN(1,6))
Function: Lottery function, long press F9 to randomly draw in the selected area
show
How to hide formulas with blank data and display them as 0
Cell Formatting-Custom-Type is written as:
# (i.e. do not display meaningless numbers 0)
[=0]"" (that is, if the value is 0, it will be displayed as empty)
Ctrl `
Show formula
operate
Input multiple cells simultaneously
After selecting multiple cells, enter the content and press Ctrl and press Enter.
Double-click the edge of the row number and column label to automatically adapt to the text range.
Ripple adjustment position
Select the data column that needs to be adjusted, move the mouse to the border of the list, hold down shift, and move it.
Content protection
Review-Protect worksheet (unlocked cells will not be protected)
edit
Ctrl G
Find location
Ctrl E
Smart fill
Alt Enter
newline
Ctrl T /L
Create as filterable list
Ctrl;
Quickly type dates
C S arrow keys
Continuous grids in their orientation can be quickly selected
Quickly add rows and columns
After selecting the cell, hold down shift, move the mouse to the corner, the cursor changes to a small black cross, and drag to complete the addition.
C S =
Insert rows and columns
Ctrl-
Delete a row or column of cells
From yuan to ten thousand
Enter 10000 in a blank cell and copy it. Select the cell to be modified and right-click to perform Paste Special. Then select the attribute content: value, except . Click OK to complete modifications
Specify color for specific font fill
Start - Conditional Formatting - New Rule
Automatically update the sort number
write=Row()- num . If you delete a row, the arrangement will automatically go up
Arranged alphabetical number
First enter the sequence of 65-90, write =char (cell position of 65) in the column next to it, pull it down to fill it in, and you are done. Lowercase letters are 97 - 122
World
Trivia
Change the word suffix [docx] to [rar] and you can decompress it to get the → picture file in media
operate
Quickly create separators
Enter more than three symbols at the far left and press Enter
common
F4
Repeat previous step
F12
Save as