How to keep table numbers continuous when inserting rows in excel 2016

When you insert rows in Excel 2016, the table numbers may be reset, causing discontinuous numbering issues. If you need to keep your numbers consecutive, this guide will provide you with step-by-step instructions. This guide covers how to: Keep table numbers continuous when inserting rows Manually update table numbers Use a VBA script to automate number updates Read on for detailed troubleshooting steps to ensure your Excel table numbers are always consistent.

As shown in the figure, this table has thousands of rows.

Now I want to add a new line before line 50. After right-clicking to add it, it is as follows. In order to keep the serial numbers continuous, the serial numbers need to be changed.

The traditional way is to add the formula, and then drag the black dot in the lower right corner to the end, but this form is too long and it is troublesome to drag it down. Moreover, it stops halfway and you may have to start over. .

Here is a simple method. Right-click on the serial number column of the new row and select Delete.

Select the lower cell in the pop-up box to move up. This is equivalent to moving all the serial numbers up one cell, but it has no effect on other columns

After moving up, the serial numbers must be continuous, but in the last row, there will be one less space due to the move up

Finally, on the serial number of the last row, Fill in another serial number in order, so that it is very convenient to change the serial number.

The above is the detailed content of How to keep table numbers continuous when inserting rows in excel 2016. For more information, please follow other related articles on the PHP Chinese website!