How to remove indents within cells in Excel?
When importing data into Microsoft Excel from external sources such as web pages or Microsoft Word documents, it's common to encounter unwanted blank indents within cells. These indents can disrupt the uniformity of your data's appearance and might affect data processing tasks. Instead of manually adjusting each cell, this tutorial will introduce several efficient methods to quickly remove indents within cells.
- Remove indents with cells with Decrease Indent command
- Remove indents space with cells with Kutools for Excel
 |  |  |
Remove indents with cells with Decrease Indent command
Indents created using the Increase Indent command or by setting paddings can be reversed easily.
Step 1: Highlight the range of cells from which you want to remove indents. Ensure these cells contain indents created by the Increase Indent command.
Step 2: Navigate to the Home tab, click the Decrease Indent button.
This action removes the indent, except for indents created by blank spaces.
Quickly remove indents space with cells with Kutools for Excel
Indents in Excel cells are sometimes created using blank spaces, especially when data is copied from other sources like web pages or word processing documents. These blank spaces can make data look uneven and poorly formatted. Fortunately, Kutools for Excel includes a Remove Spaces tool that simplifies the process of eliminating these space-based indents quickly and efficiently.
Step 1: Select the cells or range where you want to remove indent spaces.
Step 2: Click Kutools > Text > Remove Spaces.
Step 3: In the Remove Spaces dialog box, check the All excess spaces option, and click OK.
After clicking OK, Kutools for Excel processes your selected cells, and all spaces that were used as indents will be removed. The cells will now appear clean, with text properly aligned without unnecessary spaces.
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
