用第一个空格上方的单元格的值填充不连续的空白单元格 [英] Fill non-contiguous blank cells with the value from the cell above the first blank
问题描述
我想知道是否有办法在excel或公开办公室做这个条件：
I want to know if there is a way to do this conditional in excel or open office:
if the cell is empty then
the cell will have the same value as the cell above it
else
do nothing.
我应该用这个宏吗？
请帮我出去我对Excel很少有经验。
Should I use a macro for this? Please help me out; I have very little experience with Excel.
c 1 | 10/21/2011
c 2 |
c 3 |
c 4 | 10/24/2011
c 5 |
c 6 |
c 7 | 10/25/2011
c 8 |
c 9 |
c10 | 10/26/2011
c 1 | 10/21/2011
c 2 |
c 3 |
c 4 | 10/24/2011
c 5 |
c 6 |
c 7 | 10/25/2011
c 8 |
c 9 |
c10| 10/26/2011
推荐答案
-
选择包含您需要的空白单元格的范围填写
Select the range that contains blank cells you need to fill.
点击首页>查找&选择>转到特殊...，将出现转到特殊对话框，然后选择空白选项。
Click Home > Find & Select > Go To Special…, and a Go To Special dialog box will appear, then check Blanks option.
单击确定，并选择所有空白单元格。然后在活动单元格B3中输入公式= B2，而不更改选择。可以根据需要更改此单元格引用。
Click OK, and all of the blank cells have been selected. Then input the formula "=B2" into active cell B3 without changing the selection. This cell reference can be changed as you need.
按Ctrl + Enter，Excel会将相应的公式复制到所有空白单元格。
Press Ctrl + Enter, Excel will copy the respective formula to all blank cells.
此时，填充的内容是公式，我们需要将表单转换为值。然后选择整个范围，右键单击选择复制，然后按Ctrl + Alt + V激活选择性粘贴对话框。并从粘贴中选择值选项，并从操作中选择无选项。
At this point, the filled contents are formulas, and we need to convert the formals to values. Then select the whole range, right-click to choose Copy, and then press Ctrl + Alt + V to active the Paste Special… dialog box. And select Values option from Paste, and select None option from Operation.
然后点击确定。所有公式都已转换为值。
Then click OK. And all of the formulas have been converted to values.
这篇关于用第一个空格上方的单元格的值填充不连续的空白单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
