The shortcut key of fixed cell $in excel is the F4 key on the keyboard. The specific operation method is as follows: 1. Open the excel table on the computer and build some data.2. Confirm the cell, enter the formula to be calculated in the cell, and calculate the first group of data.3. You can see that the formula cell is directly pulled down to fill in, and the calculated value is wrong. At this time, you need to lock the cell data required for calculation. Click the cell, position the cursor in front of the cell to be locked in the upper input column, and then press F4 to lock it. Then, you can pull down the formula to get the correct value.
Select the cell you want to enter, and enter the keyboard shortcut key ctrl+,The date will be displayed in the cell. In addition, virtual machine group products are super cheap