How to Indent Text in Microsoft Excel 2010

When the cells in a Microsoft Excel worksheet are nearly filled with similar data, it can be difficult to read and understand the information contained in those cells. One way to help with this problem is to increase the amount of white space that separates the data in individual cells. A method for making this change is to adjust the amount of indentation that is applied to your cells.

Excel 2010 offers two different methods for increasing or decreasing the amount of indentation in a cell or group of cells that you have selected. Our tutorial below will show you both of these options so that you can start changing the indentation in your cells.

 

Indenting Cells in Excel 2010

The steps in this tutorial will show you how to indent the text that is contained inside a cell. You will be able to select either an individual cell or a group of cells, then apply this formatting to the cells that you have selected.

 

  • Step 1: open your worksheet in Excel 2010.
  •  

  • Step 2: Use your mouse to select the cell(s) to which you wish to apply the indenting.
  • select your cells

     

     

  • Step 3: Click the Home tab at the top of the window.
  • click the Home tab

     

     

  • Step 4(option 1): Click either the Decrease Indent or Increase Indent in the Alignment section of the Office ribbon. For an alternate way to adjust your cell indentation, use the method in the next step instead.
  • click the increase indent or decrease indent buttons

     

     

  • Step 4(option 2): Click the Format Cells: Alignment button at the bottom-right corner of the Alignment section of the ribbon,
  • click the alignment button

     

     

  • Then click the arrows next to the Indent field to adjust the number of characters for the indentation.
  • click the indent controls

     

     

  • You can also click the drop-down menu under Horizontal if you wish to adjust the manner in which the indentation is distributed across the cell. Click the OK button when you are done to save your changes and close the window.

click the drop-down menu under horizontal

 

 

Do you find that your Excel spreadsheets never print correctly, or that you could adjust some settings to make them look better? Our guide to Excel 2010 printing can show you some modifications that you can make to the page layout of your spreadsheet so that it is easier to read when printed.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.