Home > Topics > excel > How to fill in serial numbers for merged cells

How to fill in serial numbers for merged cells

醉折花枝作酒筹
Release: 2023-01-13 00:42:38
Original
85777 people have browsed it

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.

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

How to fill in serial numbers for 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.

How to fill in serial numbers for merged cells

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)

How to fill in serial numbers for merged cells

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.

How to fill in serial numbers for merged cells

#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!

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template