同时将相同的下拉值添加到多个单元格 [英] Adding same drop-down value to multiple cells simultaneously

问题描述

我想知道如何同时向列中的多个单元格添加相同的下拉值（例如是或否）？我尝试使用Ctrl选择需要填充相同值的单个单元格，然后从下拉菜单中选择该值，但它仅填充单个突出显示的单元格。

是否有一种快速的方法来选择单元格，然后将相同的下拉值同时添加到所有单元格？

我正在使用Excel 2013。

谢谢！

解决方案

我将尽力为您解释清楚一点。

用鼠标选择您想全部设为是的列中最上面的单元格，如果需要，请向下滚动，然后在单击任何内容之前，按住SHIFT（非CTRL）键，同时单击要更新的行的底部单元格。

这应该突出显示从单击到最后单击的列中的所有单元格。现在，释放SHIFT键并在顶部单元格中选择是（或否）。顶部的单元格（仅）将变为YES（如果选择了，则为No）。现在，无需单击任何其他操作，按住CTRL的同时按住D即可。

如果正确完成，所有突出显示的单元格将与顶部单元格匹配。 / p>

I was wondering how to add the same drop-down value (e.g. Yes or No) to multiple cells in the column at the same time? I tried selecting individual cells that I need to fill with the same value using Ctrl, and then selecting the value from the drop-down menu, but it only fills the single highlighted cell.

Is there a quick way to select cells and then add the same drop-down value simultaneously to all of them?

I'm using Excel 2013.

Thank you!

解决方案

I'll try and explain a little more clearly for you.

Select, with your mouse, the top most cell in the column you want to make all YES, scroll down if you need to and then, before clicking anything hold the SHIFT (not CTRL) key while you click the bottom cell in the row you wish to update.

This should highlight all of the cells in the column from the first, to the last you clicked. Now, release the SHIFT key and select YES (or no) in the top cell. The top cell (only) will change to YES (or No if you selected that). Now, without clicking doing anything else, hold down CTRL and while holding it press D.

If done correctly, all of the highlighted cells will now match the top cell.

这篇关于同时将相同的下拉值添加到多个单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！