title appear in center without merging cells in Excel
Q71. I have read that "Merging cells" should be avoided if possible. In Excel, how can I then make my Title appear in the center of my Data Table?
For example, in the Table below, I have a header "Employee List". I would like to center it across the Table. Can I do that without merging cells D1-G1?
This solution is much better than useing Merging cell which has its own limitations like making copy pasting or inserting rows or columns much more difficult.
To do it in Excel, here is the answer:
a) Select the cells "D1-G1" and right click. Click on "Format Cells" option.
b) In the "Alignment" tab, for the "Horizontal" field, select "Center Across Selection". Click OK.
c) The Title is now centered across the Table as shown below without actual merging of cells.