Home  >  Article  >  Topics  >  Excel table drop-down numbers automatically add 1

Excel table drop-down numbers automatically add 1

王林
王林Original
2020-05-07 11:07:1113342browse

Excel table drop-down numbers automatically add 1

Method 1: Enter the first number first, then hold down the ctrl key and pull down to the last table

Excel table drop-down numbers automatically add 1

Method 2: Enter the formula =row(a1) in the cell, and then pull down to fill in the formula

Excel table drop-down numbers automatically add 1

Recommended tutorial: excel tutorial

The above is the detailed content of Excel table drop-down numbers automatically add 1. For more information, please follow other related articles on the PHP Chinese website!

Statement:
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