Microsoft Office Tutorials and References
In Depth Information
Locating all merged cells
Here are a few things to keep in mind:
➤ You can’t use merged cells in a table (created by choosing Insert Tables Table). This is
understandable because data in a table must be consistent in terms of rows and columns.
Merging cells in a table will destroy that consistency.
➤ Normally, you can double-click a column header or row header to autofit the data in the
column or row, but that feature doesn’t work if the row or column contains merged cells.
Instead, you need to adjust the column width or row height manually.
➤ Merged cells can also affect sorting and filtering. That’s another reason why merged cells
aren’t allowed in tables. If you have a range of data that you will sort or filter, avoid using
merged cells.
➤ Finally, merged cells can cause problems with VBA macros. For example, if the cells in A1:D1
are merged, a VBA statement such as the following will actually select four columns (not at
all what the programmer intended):
Locating all merged cells
To find out whether a worksheet contains merged cells, follow these steps:
1. Press Ctrl+F to open the Find and Replace dialog box.
2. Check to be sure the Find What field is empty.
3. Click the Options button to expand the dialog box.
4. Click the Format button to open the Find Format dialog box, where you specify the
formatting to find.
5. In the Find Format dialog box, choose the Alignment tab and place a check mark next to
Merged Cells.
6. Click OK to close the Find Format dialog box.
7. In the Find and Replace dialog box, click Find All.
Excel displays a list of all merged cells in the worksheet (see Figure 13-3). Click an address in the list,
and the merged cell is activated.
Search JabSto ::

Custom Search