Solution to cell drop-down not increasing: 1. Open the Excel spreadsheet software, click on the first cell, and then place the mouse in the lower right corner of the cell format. When the mouse changes to a plus sign, Hold down Ctrl and pull down the cell; 2. Click the small triangle next to the symbol in the lower right corner, and then click "Fill Series" in the pop-up window.
The operating environment of this article: Windows 7 system, Microsoft Office Excel 2003 version, Dell G3 computer.
Recommended: "Excel Tutorial"
The first step is to open the Excel spreadsheet software, click on the first cell, and place the mouse in the lower right corner of the cell format .
In the second step, when the mouse turns into a plus sign, hold down Ctrl and pull down the cell, and we will see that the data can be incremented.
The third step is to drop down the cell format and click the small triangle next to the symbol in the lower right corner, and then we will see the pop-up window.
The fourth step is to click "Fill Series" in the pop-up window to see the incremental changes in the data. Click "Fill Series" in the pop-up window to see The data has changed incrementally. This solves the problem of the drop-down numbers in excel tables not being incremented.
The above is the detailed content of Why does cell dropdown not increment?. For more information, please follow other related articles on the PHP Chinese website!