The available horizontal justification buttons are: Click the horizontal justification setting in the Alignment section of the ribbon that you want to apply to your selected cell. Click the Home tab at the top of the window. If you want to justify all of the values in a row or column, you can click the row heading or column heading at the left or top of the window, respectively. Click the cell, row or column that you want to justify. Step 1: Open the Excel file that contains the data you want to justify. This is helpful for presenting data that is easier to read because it can separate data that might otherwise cluster together in the default settings.

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. How to Use Text Justification Options in Microsoft Excel # 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. 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).

What is right justify text excel