Seven entry tips in Excel
igerisw 2020-11-26 05:09:03

Excel in 7 Here's an introductory tip


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 :

Excel in 7 Here's an introductory tip

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 :‘’

Excel in 7 Here's an introductory tip

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 :

Excel in 7 Here's an introductory tip

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 :

Excel in 7 Here's an introductory tip

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 ” .

Excel in 7 Here's an introductory tip

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

Excel in 7 Here's an introductory tip

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 .

Excel in 7 Here's an introductory tip


Want to delete duplicate values , Select a range of cells with duplicate values , data - Delete the duplicate value .

Excel in 7 Here's an introductory tip


That's what I want to share with you , I hope it helped you .

版权声明
本文为[igerisw]所创,转载请带上原文链接,感谢
https://fheadline.com/2020/11/20201126050803744k.html
相似文章

2021-08-09