You can dictate the location in a cell of nearly any type of data that you might put into that cell. How to Vertically or Horizontally Justify Text or Numbers in Excel 2010 (Guide with Pictures) You can check out our guide on Google Sheets text wrapping not working if you are having difficulty with that tool. Our guide continues below with additional information on horizontal and vertical justification in Excel spreadsheets, including pictures of these steps.

Choose a vertical justification button.

Select a horizontal justification button.Data can be horizontally justified to the left, center, or right and it can be vertically justified to the top, middle or bottom.įinally, there is also a Wrap Text option, as well as Horizontal and Vertical Justify options that you can use if you have a string of text that is too large for its’ current cell.Ĭontinue reading to learn how to justify your text in Excel 2010.Ħ Additional Sources How to Use Text Justification Options in Microsoft Excel Justifying text or numbers will force the data into the location within the cell that you choose. It can become difficult to discern where information from one cell ends and information from another cell begins, so you will need to justify your data within its cell. You can justify text in Excel by selecting the cells to justify, clicking the Home tab, then clicking the appropriate horizontal or vertical justification button.

Unfortunately, some of Excel’s default settings can have text aligned on corresponding sides of cells (for example, a left cell that is right-justified and a right cell that is left-justified). While Microsoft Excel 2010 is most useful as a means to store, organize and compare data, you will eventually have to put some of your data into a format that is readable to a human audience.

Justify text excel