How to operate irregular filling in Excel

Irregular filling operations are a common problem in Excel, which can cause problems in data processing. In response to this problem, PHP editor Yuzai brings a detailed tutorial to explain how to use various methods to perform irregular filling operations, including sequence filling, formula filling, search and replace, etc. Through this article, you will gradually master these techniques to easily solve irregular filling problems in Excel and improve data processing efficiency.

First we prepare a form. To fill in all the departments, the normal operation is to drag and fill in one by one, but that doesn't work. Here are some tips.

First select the column to be filled, CTRL G to open the positioning settings, and select the null value in the set conditions.

Then enter equals and click on the cell above.

Finally CTLR and press Enter, all cells will be filled. Isn't it very simple?

The same operation can also be applied to other irregular forms, but the input content is rewritten according to your filling requirements, so CLTR Enter is the irregular filling. soul.

The above is the detailed content of How to operate irregular filling in Excel. For more information, please follow other related articles on the PHP Chinese website!