How to use it quickly Excel Data operation management ？ Now let's share with you Excel Several simple and commonly used tips in operation .
01、 Add a table or picture to the comment
Operation steps ： First , You can save the table to be inserted as a picture file , After that, format the inserted comments , Set the fill color to picture fill , Can finish . Here's the picture ：
02、 Filter copy visible cells
Operation steps ： Select all the data areas to be copied , Then press F5 Shortcut key , In positioning conditions , Select visible cells , After you click OK , Copy and paste directly . Here's the picture ：‘’
03、 Interlaced colouring
Operation steps ： Choose D2:D9 Cell range , Mouse click 【 Start 】-【 Conditional format 】-【 New rules 】-【 Use the formula to set the cell of the rule 】, According to the pop-up dialog box prompt , The input formula is ：=(MOD(ROW(),2)=1)*($A1<>""), In the format , Set the cell fill color to light green , After clicking on 【 determine 】, Can finish . Here's the picture ：
04、 Drop down menu making
Operation steps ： Select the range of cells you want to make a drop-down menu , Mouse click 【 data 】-【 data validation 】-【 Sequence 】, In the source , Input the menu content to be pulled down , The contents of different dropdowns should be separated by commas in English , Then click 【 determine 】. Here's the picture ：
05、 Quickly fill in the date
Operation steps ： Enter the start date in the table , Drop down to fill in quickly , Click the fill option in the lower right corner , choice “ Fill in the workday ” .
06、 Keep the sequence number continuous
When we deal with tabular data , Often delete or hide the specified number of lines , How to keep the sequence number continuous ？
Enter the formula in the cell =SUBTOTAL(103,$B$2:B2)*1
07、 Duplicate value processing
Select the data area - Start - Conditional format - Highlight cell rules - duplicate value , Duplicate values of the selected area will be marked .
Want to delete duplicate values , Select a range of cells with duplicate values , data - Delete the duplicate value .
That's what I want to share with you , I hope it helped you .