When you click OK, your cells will look like they've been merged, but they're actually separate cells. In the dialog box that appears, open the Horizontal menu and select Center Across Selection. On the Home tab, first click the small arrow in the bottom-right corner of the Alignment group. Luckily, the Center Across Selection feature can give the same basic look as merged cells without creating problems in your spreadsheet. Because of this, it's generally best to avoid merging cells unless you absolutely have to. However, merged cells are notorious for creating problems in spreadsheets especially if you're trying to sort, copy, paste, or move data. en/excel-tips/find-a-sum-without-using-a-formula/content/ Why you should avoid merging cellsĮxcel allows you to merge several cells into a single large cell, which can be used to center text across several rows or columns. Lesson 10: Why You Should Avoid Merging Cells
0 kommentar(er)
