Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and beauty - How to drop down the excle table and automatically change it according to the existing content.
How to drop down the excle table and automatically change it according to the existing content.
I don't know what is the neighborhood where you live in Jincheng Road, Hangzhou? Suppose it is B2, select this column, and then press CTRL+G to locate the condition, null value and OK. Then you can see that all the spaces are selected, and enter =B2 on the keyboard. At this time, you should be able to see that there is one more under Jincheng Road in Hangzhou. Press CTRL+D again, and it will be filled in automatically.