How to Remove Cell Indentation in Excel 2013


Spaces preceding data in a cell can make your spreadsheet look less professional, and may even create potential problems for people working with your data. This indentation can occur if you have copied and pasted the data from another source, or if if has been introduced to the worksheet by accident.

Fortunately the amount of indentation in a cell is something that you can control, and you can remove it entirely if it is not needed. Our guide below will show you how to select cells containing indentation and remove that indentation in Excel 2013.

 

Remove the Indentation Space Before Data in Excel 2013

The steps in this article will assume that you have a worksheet containing cells that have an indentation. If you follow the steps below and the indentation is not removed, then you may have blank spaces preceding your data, as opposed to indentation formatting. If that is the case, then you will have more luck with the Excel TRIM function. For example, if you have data in the A1 cell that contains blank spaces that you wish to remove, then entering the formula =TRIM(A1) into a blank cell will remove spaces from the data. You can learn more about the TRIM function here.

 

  1. Open your Excel worksheet containing the indentation that you want to remove.
  2.  

  3. Select the cells containing the indentation that you want to remove. If you wish to remove all indentation from your worksheet, then you can press Ctrl + A on your keyboard, or click the gray button above the row 1 heading, and to the left of the column A heading. Both of those options will select the entire sheet.
  4. select the indented cells

     

     

  5. Click the Home tab at the top of the window.
  6. click the Home tab

     

     

  7. Click the Decrease Indent button in the Alignment section of the ribbon until the indentation is remove. Depending upon the amount of indentation that was added to the cell(s), you may need to click this button a few times.

how to remove cell indentation in excel 2013

 

 

Another way to quickly remove indentation, and any other formatting, in Excel 2013 is to use the Clear Formats option. You can learn how to remove all formatting from an Excel 2013 worksheet to restore all of your cells to the default Excel format.

how to start your own website
Have you ever wanted your own blog or website? Click here to learn how to get started today and have you own domain in less than 20 minutes!