How to fill in serial numbers for merged cells

Filling method: First open the excel table that needs to be operated, select the specified cell; then enter the formula "=Counta (cell or reference)" in the cell, and press "ctrl enter" on the keyboard A key combination can be used to fill in serial numbers for merged cells.

The operating environment of this tutorial: windows7 system, WPS Office2016 version, Dell G3 computer.

Enter a table as shown in the figure. We often encounter tables like this, where the serial number is based on the content in column B, so the serial number column must also be in the state of merged cells.

If you still use the original method, enter 1 in the merged cell of the first serial number, and then pull down, the serial numbers will not be generated in the normal order.

Faced with such a situation, you need to use the COUNTA function. First select all the merged cells that need to be populated with serial numbers. Then directly enter =COUNTA($B$2:B2)

on the keyboard. After the formula is entered correctly, the most critical thing is to click the ctrl enter key, and the serial number will automatically Generate, just pressing the enter key has no effect.

#The COUNTA function is to count the number of non-empty cells in the selected range. $B$2 represents the starting area cell for calculation, and then increments one row downward from this cell. So the serial numbers of merged cells can be filled in order.

Related learning recommendations: excel tutorial

The above is the detailed content of How to fill in serial numbers for merged cells. For more information, please follow other related articles on the PHP Chinese website!