How to set excel number drop-down to remain unchanged_How to set excel number drop-down to remain unchanged

Want to set the Excel number drop-down to remain unchanged, but find that the numbers in the drop-down box still change automatically? PHP editor Xiaoxin brings you a solution. This tutorial details how to set up data validation in Excel to prevent numbers in drop-down boxes from changing automatically. Read on for more details below to learn how to set Excel's number drop-down settings invariantly.

1. First enter the cell, then move the cursor to the lower right corner and click [ ].

2. Then press and hold [ctrl] to pull down and keep the data unchanged.

3. You can also click on the small icon that appears in the lower right corner.

4. Then select [Copy cells].

The above is the detailed content of How to set excel number drop-down to remain unchanged_How to set excel number drop-down to remain unchanged. For more information, please follow other related articles on the PHP Chinese website!