excel复制公式递增_快速向下复制Excel公式

excel复制公式递增

You probably know how to quickly copy Excel formula down a column, if there is data in the next column. But how can you do the same thing, if there are blank rows?

如果下一列中有数据，您可能知道如何快速将Excel公式复制到一列中。 但是，如果有空白行，您该怎么做？

复制公式时出现问题 (Problem Copying a Formula Down)

Recently, I saw this tweet, from someone stuck on an Excel problem:

最近，我看到有人在Excel问题上遇到这个推文：

• An Excel problem I have never solved – easily copying a formula down tens of thousands of rows where the row next to it may be blank.
  我从未解决过的Excel问题–轻松地将公式向下复制到成千上万行，而该行旁边的行可能为空。

在填充单元格旁边填充 (Fill Down Beside Filled Cells)

Yes, it's easy to copy a fo