Title: How to Remove Cell Indentation in Excel 2013 - Solve Your Tech
Headings: How to Remove Cell Indentation in Excel 2013
How to Remove Cell Indentation in Excel 2013
Remove the Indentation Space Before Data in Excel 2013
Matthew Burleigh

Content: How to Remove Cell Indentation in Excel 2013 - Solve Your Tech
Home » Programs » How to Remove Cell Indentation in Excel 2013
How to Remove Cell Indentation in Excel 2013
December 11, 2015 by Matthew Burleigh
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. Open your Excel worksheet containing the indentation that you want to remove.