一定数量的列后，Excel选项卡移至新行 [英] Excel tab to new line after certain amount of columns

问题描述

我要设置一个Excel电子表格，以便使用条形码扫描仪输入数据. 条形码扫描器先发送条形码，然后发送标签或回车键，具体取决于其编程方式.

I am wanting to set up an excel spreadsheet for data entry with a barcode scanner. The barcode scanner sends the barcode then a tab OR an enter key depending how its programmed.

基本上我想设置一个Excel工作表，我们可以为每个项目扫描6个条形码，而扫描仪每次都跳至下一列，然后当它到达第六列时，下一个选项卡将使其移动到新的下一个产品的生产线.

Basically I want to set up an excel sheet that we can scan 6 barcodes for each item, with the scanner tabbing to the next column each time, then when it reaches the 6th column the next tab will make it move to a new line for the next product.

我希望这是有道理的.可以用MS字来完成...例如，如果您创建一个具有6列的表格并按Tab 7次，它将移至下一行. 我想在Excel中执行此操作. 谢谢

I hope this makes sense. It can be done in MS word... e.g if you create a table with 6 columns and push tab 7 times it will move to the next row. I am wanting to do this in Excel. Thank you

推荐答案

也许我在此问题上漏了一些东西，但是如果您选择了六列并使用创建列表"命令来转换选择，那么只要您按一下到一行的最后一个单元格，您将自动转到下一行.此外，如果您在最后一行，则会创建一个新行. IM不确定为什么要为此使用宏?

Maybe I'm missing something on the issue, but if you select your six columns and transform the selection with the "create list" command, then whenever you tab to the last cell of a line you'll automatically going to the next line. Furthermore, if you're at the last line, a new one will be created. IM not sure why you need a macro for that ?

这篇关于一定数量的列后，Excel选项卡移至新行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！