vfp取得excel的句柄_使用Excel填充句柄插入行

vfp取得excel的句柄

If you want to insert a block of cells on a worksheet, what method do you use? Do you insert rows with Excel fill handle, or with a command?

如果要在工作表上插入一个单元格块，请使用哪种方法？ 您是否使用Excel填充手柄或命令插入行？

One way to insert cells is to select some cells, right-click on the selected range, and click Insert. Then you can select one of the Insert options.

插入单元格的一种方法是选择一些单元格，右键单击所选范围，然后单击“插入”。 然后，您可以选择“插入”选项之一。

用填充手柄插入 (Insert With the Fill Handle)

This week, I was doing some updates on this blog, and found a tip that I posted 5 years ago. You can use the Fill Handle as a shortcut for inserting and deleting cells.

本周，我在此博客上进行了一些更新，并发现了我 5年前发布的提示 。 您可以将“填充手柄”用作插入和删除单元格的快捷方式。

Select cells as a starting point, press Shift, and drag the fill handle to insert cells. You can use the Fill Handle to delete cells too!

选择单元格作为起点，按Shift，然后拖动填充手柄以插入单元格。 您也可以使用“填充手柄”来删除单元格！

Apparently I haven’t used that tip too often, because I forgot all about it! You’ll find more data entry tips on my Contextures website.

显然，我并没有太频繁地使用该技巧，因为我忘了所有这些技巧！ 您可以在我的Contextures网站上找到更多数据输入提示 。

观看视频 (Watch the Video)

Maybe I’ll remember this tip a bit longer if I make a video.

如果我制作视频，也许我会记住这个技巧的时间更长一些。

To see the steps for inserting and deleting a block of cells, watch this short video. And watch for this tip again in 2018!

要查看插入和删除单元格块的步骤，请观看此简短视频。 并在2018年再次注意此技巧！

演示地址

翻译自: https://contexturesblog.com/archives/2013/04/30/insert-rows-with-excel-fill-handle/

vfp取得excel的句柄