Home  >  Article  >  Software Tutorial  >  How to set excel number drop-down to remain unchanged_How to set excel number drop-down to remain unchanged

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

WBOY
WBOYforward
2024-04-24 12:40:05964browse

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 [ ].

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

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

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

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

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

4. Then select [Copy cells].

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

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!

Statement:
This article is reproduced at:zol.com.cn. If there is any infringement, please contact [email protected] delete