在不丢失数据的情况下组合行和列的最佳方法是什么 [英] What is the best way to combine rows and columns without losing data

问题描述

我在A列到E列中有相同的数据。但是，F，G和H列中的数据不同。我以为我想实际上合并单元格A到E但是它会进行合并并且仅将数据保留在最左边的列中...在这种情况下为A列。我更喜欢
列B至E仍然有助于理解工作表信息。使用组是最简单的方法吗？我不想在工作表中添加另一层复杂性，但如果这是唯一的方法。

感谢您的评论，并希望得到答复。

解决方案

下载此AddIn

https://www.dropbox.com/s/eow60utqq4nf1gr/AK.zip?dl=1

它有针对此方案的不同例程你可以录制宏来获取文件的代码。

Andreas。

I have the same data in columns A thru E. The data in columns F, G, and H is different though. I thought I wanted to actually Merge Cells A thru E but that does a Merge and only keeps the data in the left-most column...Column A in this case. I would prefer Columns B thru E remain valued for understanding the worksheet information. Is the easiest way to do this by using a Group? I hate to add another layer of complexity to the worksheet but if this is the only way to do it.

Thanks for your review and am hopeful for a reply.

解决方案

Download this AddIn
https://www.dropbox.com/s/eow60utqq4nf1gr/AK.zip?dl=1

It has different routines for this scenarios and you can record a macro to get code for your file.

Andreas.

这篇关于在不丢失数据的情况下组合行和列的最佳方法是什么的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！