Excel Formula或VBA执行此操作的策略. [英] Strategy for Excel Formula or VBA to do this.

问题描述

我有一个包含汽车零件信息的Excel工作表.

I have an Excel sheet with information about auto parts.

部件号在A2上.它适合的第一辆车在B3上.它适合的第二辆车在B4上.它适合的第三辆车在B5上.依此类推，直到下一个零件的下一个零件编号.有些零件有数百辆适合的车辆.有些为0(非美国汽车为零).

Part number is on A2. First Vehicle it fits is on B3. Second Vehicle it fits is on B4. Third vehicle it fits is on B5. And so on and so forth until the next Part Number for the next part. Some parts have hundreds of vehicles they fit. Some have 0 (parts for non-US cars).

我需要在A3，A4，A5等上有零件编号.

I need to have the part number on A3, A4, A5, etc.

推荐答案

解决这个问题的绝妙技巧-请执行以下操作:

Cool trick to fix this - Do the following:

1. 在A列中选择要填写的整个区域
2. 查看 F5 键
3. 选择 Special
4. 选择空白，然后单击确定

1. Select the entire region in column A you want to fill in
2. Prsee the F5 key
3. Select Special
4. Select Blanks and click Ok

现在应该选择所有空白单元格

Now all the blank cells chould be chosen

1. 键入 = ，然后按向上箭头
2. 点击 ctrl + enter

1. Type in = and press the up arrow
2. Hit ctrl + enter

应该这样做

这篇关于Excel Formula或VBA执行此操作的策略.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！