cmd？ +V: paste
cmd？ +X: Cut? In the past, I would copy it first, then paste it in an important place, and then delete the original content, so that I wouldn't have to repeat my work after cutting it.
cmd？ +Z: Undo
If you are used to the mac keyboard, you can obviously feel that when copying and pasting with the pc keyboard, the distance of finger collapse increases obviously, because the ctrl key is located in the lower left corner.
cmd？ +CONTROL+V paste selectively
The frequency of selective plastering is very high.
Or CONTROL+OPTION+V or cmd? +option+V. The summary is that control, option and command randomly select two keys.
Cell format
cmd？ +B？ Memory mode: B is the beginning of bold type.
cmd？ +U？ Memory mode: u is the beginning of the word underline.
cmd？ +Me? Memory style: I is the beginning of the word italics.
In practical problems, we often have to choose a whole column or a whole row of data, and the stupid way is to drag the mouse to choose. The limitation of this method is that the amount of data is too large, and it takes a lot of time to drag, just like the selection of 123 cell in the above picture. In the process of big data processing, there are usually thousands of data, so a fast way is needed.
Select the first cell to select, such as cell A2, and then press Shift+cmd? +so that all the data in column A can be selected. Similarly, Shift+cmd? +? You can select all the data in the second row.
cmd？ +A: Select all cells
There are some tips:
Select the first cell, hold down the Shift key, and then select another cell. At this point, all cells between the diagonal lines of two cells will be selected.
cmd？ Key can realize discontinuous selection. In some cases, if you want to select multiple cells by jumping, you can select a cell first and then hold down the cmd key. , and then select another cell.
Find and replace
Many friends can't find a place to look and change. In fact, there is a search worksheet in the upper right corner of the document, and you can directly enter what you want to find; If you want to replace it, you can click the magnifying glass icon? You will see substitutes. Of course there are shortcut keys.
In practical problems, replacing this function is very powerful. In the case of deleting some fields, I will replace a blank field with replacement (that is, don't type anything), which is a quick way to delete fields.
Create a new document and save it.
cmd？ +N: Create a new document
cmd？ +S: save
I have to say, saving is a good habit. Suddenly the computer crashed or the power supply was insufficient, resulting in the disappearance of the hard-earned documents. So remember to press cmd from time to time? +S, save, save, save, say the important things three times.
cmd？ +T: absolute reference
cmd？ +Numeric key 4: Absolute reference
Both methods can be realized. Pressing this shortcut key continuously can change the absolute reference part and achieve the effect of local absolute reference in the formula.
Start a new line in a cell.
When I was a beginner, I wanted to break lines in a unit. According to conventional thinking, I should just press Enter, but in Excel, Enter will jump to the next cell.