Merging 4 cells of width 20 gives me 82. AutoFit Column Width: It is a feature that allows the column width to become automatically adjusted so it can fit the cell’s text. It can be possible for you to have multiple rows autofit at once.
But it's not like that a border (well acctually it's gridlines, because my merged cells don't have borders) has a fixed width. Autofit Row Height: Here is a feature that allows the row height to adjust automatically to fit the cell’s text.
But the only way (at this moment) for me to know what the real width of the merged cell is, is to drag the first column of the merged cells until it equals (just place it right above) the right border of the merged cell.Īt this point i haven't found a way to predict (calculate) the width of the merged cell.Īt first i thought if i would merge four cells three 'inside' borders would disappaer. But even without any borders the width of the merged cell doesn't add up to the sum of the widths of its merged cells. Changing the border of any cell does shifts the cells down a bit (so the height of a merged cell could be dependent of the borders of merged cells - but this is irrelevant to the AutoFitMergedCellRowHeight procedure) but in my Excel version (97) changing the borders doens't shift the cells right, so I think it doesn't matter to the width of the merged cell what type of border its merged cells have.Ģ.
I don't know if you are right about the borderwidth though.ġ. Don't apologies: you were right: replace 'Merge 4 rows.
