Accidentally, delete the wrong, but also emptied the Recycle Bin, how ah?
In three steps, you'll get back what you deleted and emptied the Recycle Bin.
(triple tutorial with map)
Steps:
1, click "Start"-run, and then enter regedit (open the Registry)
2, sequentially expand: Hekey--local--machime/software/microsoft/windows/currentversion/explorer/desktop/namespace on the left blank outside click "New"
, select: "PRIMARY Key" and name it "645ffo40--5081--101b--9f08--00aa002f954e"
Set the key value of the default primary key on the right to the Recycle Bin, and then exit the registry. It's OK.
3, to restart the computer.
As long as the machine has not run the disk collation. The system is intact. Any time the documents can be found back.
Perhaps you have completed hundreds of financial statements in Excel, perhaps you have used Excel functions to achieve thousands of complex operations, you may think that Excel is too much, or even new. But the countless times we routinely use the handy method is just 1% of all Excel skills. This topic from excel in some of the little-known skills to get a glimpse of the different aspects of Excel style.
Let different types of data be displayed in different colors
In the payroll, if you want to be greater than or equal to 2000 of the total wages to "red" display, greater than or equal to 1500 yuan in the total wages to "blue" display, less than 1000 of the total wages to "brown" display, and other "black" display, we can set this.
1. Open the Payroll workbook, select the column for payroll, and execute the format → conditional formatting command to open the Conditional Formatting dialog box. Click the Drop-down button to the right of the second box, select the greater than or equal to option, and enter the value "2000" in the box that follows. Click the Format button to open the Format Cells dialog box and set the font color to red.
2. Press the "Add" button, and follow the above operation set other conditions (greater than or equal to 1500, the font is set to "blue"; less than 1000 and the font is set to "Brown").
3. When the settings are complete, press the "OK" button.
Look at the payroll, and the payroll figures are displayed in different colours according to your requirements.