Now we can see vertical alignment in action.įor the bottom three rows, we can enable text wrapping and Excel will adjust each row as needed to fit the text. That's because vertical alignment doesn't actually do anything unless the row height is increased. Note that nothing in our table has changed. So there's no need to change the setting. Let's format the text in each column to match the headings.įor columns C, D, and E, it's easiest to set vertical alignment using the three buttons in the Alignment group on the home tab of the ribbon.įor column C, we click the Top Align button.įor column D, we use the Middle Align button.įor column E, vertical alignment is already set to Bottom Align. The options available for vertical alignment in Excel are listed across the top of the table. The bottom three rows contain larger amounts of text. The top three rows contain a single line of text. Here we have a table with several rows of sample text. Excel provides options to align text to the top, bottom, and middle of cells, as well as options to justify and distribute text vertically. In this lesson we'll look at how to align text vertically in cells.
