![]() Step 2: Select Merge & Center from the home page. If there was text above the word “City” or above “Sales”, that data is lost when you merge cells. ( Note: Merging cells will only keep the text/data that is in the upper left most cell you want to merge). In our example, we’ve selected the cell containing the text “September Sales” as well as the other two cells above the table. Step 1: Select the cells you want to merge Merging the three cells above the table will help the title stand out a bit more. The table details the sales in September for a variety of cities. This is very commonly done when creating summary tables, headers, and otherwise cleaning up a sheet so it presents well. One of the easiest formatting improvements you can make is to merge cells in Excel.
0 Comments
Leave a Reply. |