How to set excel serial number auto-increment setting method

WBOY
Release: 2024-08-27 10:07:53
Original
512 people have browsed it

In excel, you can automatically increment the serial number by pulling down the first sequence in the table, which is very convenient. However, recently some users discovered that when using this function in Excel, the serial number will not be incremented and remains the same as the first one. How to solve it? The editor below will share with you how to set up the excel serial number that cannot be automatically incremented. Method 1 1. Open EXCEL and select cell A1 for drop-down filling.

excel序号自动递增怎么设置 excel序号自动递增设置方法

2. After completing a filling, a filling option will appear next to it, click to expand.

excel序号自动递增怎么设置 excel序号自动递增设置方法

3. Select [Fill Sequence] in the expanded list.

excel序号自动递增怎么设置 excel序号自动递增设置方法

4. Just pull down again.

excel序号自动递增怎么设置 excel序号自动递增设置方法

Method 2 1. Open the table and right-click on the cell that cannot be incremented. Select [Format Cells] in the pop-up menu. 2. Change the number category [Value] in [Number] to [General].

excel序号自动递增怎么设置 excel序号自动递增设置方法

The above is the detailed content of How to set excel serial number auto-increment setting method. For more information, please follow other related articles on the PHP Chinese website!

source:xpwin7.com
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
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!