autofit_AutoFit合并的单元格行高

autofit

You've most likely heard this warning -- "Avoid merged cells in your Excel worksheets!", and that is excellent advice. Merged cells can cause problems, especially when they're in a table that you'll be sorting and filtering. You'll run into more problems if you try to autofit merged cell row height.

您最有可能听到此警告-“避免在Excel工作表中合并单元格！”，这是极好的建议。 合并的单元格可能会导致问题，尤其是当它们位于要进行排序和过滤的表中时。 如果尝试自动调整合并单元格的行高，则会遇到更多问题。

被迫合并 (Forced to Merge)

Occasionally though, you might have no choice but to use one or more merged cells on a worksheet. As long as you avoid merging table cells, and proceed with caution, things might be okay.

但是，有时您可能别无选择，只能在工作表上使用一个或多个合并的单元格。 只要您避免合并表格单元格并谨慎行事，事情就可能会好的。

In the example shown below, there is an order form, and space for a note about the order. If the note will always be short, there's no need to merge the cells – just let the text flow across the columns.

在下面显示的示例中，有一个订购单，并在其中留有关于订单的备注。 如果注释始终很短，则无需合并单元格–只需让文本跨列流动即可。

However, if the notes will be two or more lines, you'll need to merge the cells, and turn on Wrap Text. Adjusting the column width would affect the product list that starts in row 12, so that's not an option.

但是，如果注释为两行或更多行，则需要合并单元格，然后启用“自动换行”。 调整列宽会影响从第12行开始的产品列表，因此这不是一种选择。

合并单元格行高 (Merged Cell Row Height