Introduction to irregular filling methods in Excel

At work, we often encounter situations where we need to fill irregularly in Excel tables, but how to achieve this goal makes it difficult for many people. PHP editor Strawberry will introduce to you the irregular filling method in Excel today to help you easily deal with this problem. If you also want to know how to fill irregular data, hurry up and continue reading the details below. We have provided you with detailed steps and examples to make it easy for you to get started!

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.

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

Enter equals and click the cell above.

Finally CTLR and press Enter, all cells will be filled.

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