In the home tab of the ribbon, we have a section dedicated to alignment. Firstly, if i select some cells and click on some of these items. For example: A line left we can see all the numbers move over to the left and then if we align right. We can see everything get aligned to the right and we have a line center. Increase the row height on these rows to demonstrate another option up here. We can align everything to the top the center or the bottom of rows also with an alignment quite often, i would use wrap text.

How To Use Format Alignment 1


In the home tab of the ribbon, we have a section dedicated to alignment. Firstly, if i select some cells and click on some of these items. For example: A line left we can see all the numbers move over to the left and then if we align right. We can see everything get aligned to the right and we have a line center. Increase the row height on these rows to demonstrate another option up here. We can align everything to the top the center or the bottom of rows also with an alignment quite often, i would use wrap text.

How To Use Format Alignment Use Merge Cell Option

for example: If i type something into a cell and click return you will see that the contents of this cell overlapping all the cells. If i start typing something in the next cell. We lose visibility of the contents. So, if we use wrap text we will then wrap the text so, we can see several lines in a cell an excel is not optimizing the cell width or sale height but it's giving you the potential to see more in a sale. This way if you want to be able to see everything in the cell you can.


 

How To Use Format Alignment ? Either auto height or auto width and the final option over here is merge and center i have typed some text in cell B1. If I then highlight B1 to G1. We have merge and center options first one is merge and center. So, as we can see this centers the text across the selected cells. If i undo this alternatively we have merge across, we can see the cells emerge.

But we're aligned to the left or we can just merge the cells. We can unmerge them like this personally i try to avoid using merge as your spreadsheets grow and become more complicated and you use functionality such as sorting as well as moving and copying merge often causes problems there is an alternative which is center across selection which doesn't have the drawbacks of merge. Yet achieves the same visual effect to access center across selection use the down arrow or Ctrl 1.

Explore Format Cells

 Click on the arrow and if we go to alignment. We can choose center across selection so, here we've centered the text across the selection of cells but haven't actually merged them. So, we have perhaps achieved the same presentational objective and we'll find later on. As we get more advanced we're less likely to have errors or Issues with this approach thank you.