如果采用纯手工操作的方法，虽然可行，但相当繁琐。事实上，我们可以采取一种更简单的方法。以excel 2013版为例。
Press ldquo; Ctrl+F; key combination, open the find and replace ldquo; ; dialog box, switch to the ldquo tab, click on the search; ; ldquo; option; this button, you will see ldquo format; ; button, click to open the ldquo format; search; dialog box, switch to the ldquo tab, ; alignment; as shown in Figure 1, check the ldquo here; merge cells ; check box, confirm after return ldquo; find and Replace dialog box, click the ; ldquo; search all ; button at this time will merge cells all automatically find, keep the find and replace ldquo; ; open the dialog box, press the ldquo; Ctrl+A; combination of keys, select the merge cells, then you can fill color, the final result is shown in 图2，不是很方便
