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!
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1359
52
What to do if merged cells cannot be pasted
Aug 31, 2023 pm 03:48 PM
If merged cells cannot be pasted, you can solve the problem by updating the Excel version, clearing special formats or content, deleting blank cells, trying other methods of merging cells, reopening the file, or contacting the technical support team. Detailed introduction: 1. Update the Excel version. Older versions of Excel may have some compatibility issues, resulting in the inability to merge cells normally; 2. Clear special formats or content. Certain formats or content may cause the inability to merge cells. Operation; 3. Delete blank cells, etc.
How to find and delete merged cells in Excel
Apr 20, 2023 pm 11:52 PM
How to Find Merged Cells in Excel on Windows Before you can delete merged cells from your data, you need to find them all. It's easy to do this using Excel's Find and Replace tool. Find merged cells in Excel: Highlight the cells where you want to find merged cells. To select all cells, click in an empty space in the upper left corner of the spreadsheet or press Ctrl+A. Click the Home tab. Click the Find and Select icon. Select Find. Click the Options button. At the end of the FindWhat settings, click Format. Under the Alignment tab, click Merge Cells. It should contain a check mark rather than a line. Click OK to confirm the format
How to merge cells in WPS table
Mar 21, 2024 am 09:00 AM
When we use WPS to make our own tables, the header of the table needs to be in a cell. At this time, the question arises, how does WPS merge cells? In this issue, I have brought you the specific operation steps, which are below. Please study them carefully! 1. First, open the WPS EXCEL file on your computer. You can see that the current first line of text is in cell A1 (as shown in the red circle in the figure). 2. Then, if you need to merge the words "Subsidy Statistics Table" into the entire row from A1 to D1, use the mouse to select cell A1 and then drag the mouse to select cell D1. You can see that all cells from A1 to D1 have been selected (as shown in the red circle in the figure). 3. Select A
How to merge cells using shortcut keys
Feb 26, 2024 am 10:27 AM
How to use the shortcut keys for merging cells In daily work, we often need to edit and format tables. Merging cells is a common operation that can merge multiple adjacent cells into one cell to improve the beauty of the table and the information display effect. In mainstream spreadsheet software such as Microsoft Excel and Google Sheets, the operation of merging cells is very simple and can be achieved through shortcut keys. The following will introduce the shortcut key usage for merging cells in these two software. exist
How to solve the problem that WPS cannot make partial modifications to merged cells
Jun 28, 2023 pm 03:05 PM
The solution to the problem that WPS cannot make partial modifications to merged cells: 1. Cancel the merged cells first; 2. After selecting the cells that need to be merged, hold down "ctrl" + "1", and click on the cell settings page Switch to "Alignment"; 3. Select "Center Across Columns" in "Horizontal Alignment"; 4. After clicking "OK", the content will be displayed centered across columns, and you can modify the content.
Shortcut keys for merging cells on computer keyboard
Feb 19, 2024 am 11:52 AM
Computer keyboard shortcut keys for merging cells In daily office work, we often use spreadsheet software for data processing and organization. Merging cells is one of the commonly used operations in spreadsheets. It can merge several adjacent cells into one large cell to better display data. In order to improve work efficiency, it is very necessary to learn the shortcut keys for merging cells on the computer keyboard. Below, I will introduce you to some shortcut keys for merging cells in commonly used operating systems and spreadsheet software. Under Windows, use M
Implementation method of table merged cells in Vue document
Jun 20, 2023 pm 09:12 PM
Vue is a popular JavaScript framework that provides many convenient features for building dynamic interfaces. Among them, tables are common elements in web development. In some cases, we may need to merge adjacent cells into one cell to better display information. This article will introduce how to merge table cells in Vue documents. Vue provides a built-in component VueTable, which can easily create tables. In the VueTable component, you can use the HTML table tag
Keyboard shortcut for merging cells in WPS tables
Feb 19, 2024 pm 12:01 PM
WPS shortcut keys for merging cells WPS is a commonly used office software with a wide range of applications. In table processing, merging cells is a common operation, which can merge multiple cells into one large cell to facilitate data display and format adjustment. This article will introduce the shortcut key operations for merging cells in WPS tables. In the WPS table, there are two ways to merge cells: through the toolbar button operation, or by using shortcut keys. Using shortcut keys can improve operation efficiency and complete the operation of merging cells more conveniently.
