Shortcut for merge and center on excel for mac

broken image
broken image

Similarly, there are plenty of reasons where you can benefit from splitting a large cell into two smaller cells without influencing the rest of the rows and columns within your table. So merging the two header cells and then substituting the text in the merged cell makes this table use space much more efficiently, as shown within the table that's shown at the bottom of Figure 1, above. Notice that the header content, Weather in C and Weather in F both span two lines each whereas the data below does not really need that much space.

broken image

This is essentially true for tables that have two header rows, or even with tables that have a long phrase in the header row, as shown within the sample table shown towards the top in Figure 1, below.įigure 1: Some tables need to have merged or split cells Yet, very few people realize that table cells can be made larger or smaller without influencing the entire row or column, by merely merging or splitting cells in your existing table. That's the case with most people who work with tables.

What comes next? Probably you need to add or remove rows and columns. Add a table to your PowerPoint slide and then populate the table with content.