填写 - Google Apps脚本的电子表格 [英] Fill down - Google Apps Script for Spreadsheets

问题描述

是否有一个函数可以将数据填充到上述行中的所有空单元格中？

如果不是，任何人都可以使用Google Apps脚本帮助我或其他解决方案），可以通过我的谷歌电子表格中的每一行，检查空单元格，如果找到，用上面的行填入数据？

这个函数应该已经包含在我认为的电子表格程序中（以及填充）。

解决方案

这样的函数应该已经包含在电子表格程序中了
认为（和填充）。

我会尝试描述本机的功能。

1. 如果双击右下方的小蓝色方块一个选定的单元格或范围，这将自动填充该单元格到左侧填充的单元格块的末尾。或者，您可以拖动这个小蓝框（向下，向上，向左或向右）自动填充。




2. 您可以选择源单元格和单元格（请参阅第4点），然后按 Ctrl + D 填充。您也可以使用 Ctrl + R 来填写正确的内容。




3. 您可以选择源单元格，按 Ctrl + C 进行复制，然后选择上面的单元格（或向左 - 再次参考点4），然后按 Ctrl + V 粘贴。这可以填充（或左边）。




4. 您可以快速选择空白单元格下方（或上方，右侧或左侧）通过按 Ctrl + Shift + 向下（或向上，或向右或向左）这将带您到工作表的极限或下一个填充的单元格。如果是后者，您可以按 Shift + 向上（或向下或向左或向右）返回到最后一个空白单元格。然后按照第2点和第3点的要求填写。




5. 您需要为每个非连续的空白单元格组执行此操作。如果您希望能够快速自动填充非连续的空白单元格组，则是，需要脚本。

Is there a function that can fill down data to all empty cells from the row above?

If not, could anyone help me out with a Google Apps Script (or other solution) that can go through every row in my google spreadsheet, check for empty cells, and if found, fill them in with data from the row above?

Such a function should be already included in a spreadsheet program I think (and "fill up" as well).

Thank you!

解决方案

Such a function should be already included in a spreadsheet program I think (and "fill up" as well).

I'll attempt to describe the native functionality in GSheets pertaining to this.

1. If you double-click the little blue square on the bottom-right of a selected cell or range, this will automatically fill that cell down to the end of a block of populated cells on the left. Alternatively, you can just drag this little blue box (down, up, left or right) to auto-fill.

2. You can select the source cell and cells underneath it (refer to point 4), and then press Ctrl+D, to fill down. You can also use Ctrl+R to fill right.

3. You can select the source cell, press Ctrl+C to copy, then select cells above (or to the left - and again refer to point 4), and then press Ctrl+V to paste. This has the effect of filling up (or left).

4. You can quickly select blank cells under (or over, or right of, or left of) the source cell by pressing Ctrl+Shift+Down (or Up, or Right, or Left). This will take you to either the limit of the sheet, or the next populated cell. If the latter, you can then press Shift+Up (or Down, or Left, or Right) to back-track to the last blank cell. And then fill as required as per points 2 and 3.

5. You will need to do this for each non-contiguous group of blank cells. If you want to be able to quickly auto-fill non-contiguous groups of blank cells, then yes, a script would be required.

这篇关于填写 - Google Apps脚本的电子表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！