![]() ![]() Perhaps you have some merged cells, or text that is center-aligned, or some that are right-aligned, such as in this example. There may be cases where you have cells in your selection that you don't want to clear the alignment for. ![]() Remove Indenation but Keep Alignment Settings Note: If the Left Align button is not already enabled, or you have different alignment settings for each cell, then you will have to press the Left Align button twice to change the alignment to General. The values in the cells will use the General Alignment, which differs based on the data type of the cell. Then click the Left Align button to change the alignment to General. Start by selecting all of the cells that you want to remove the indentation for. The first way to take care of this issue is to change the alignment of the cells to the General setting. The indentation is NOT removed.įortunately, there are ways to quickly remove the indentation at multiple levels all at one time. If you select all of the cells that contain indentation (at multiple levels) and press the Decrease Indent button, nothing happens. Removing all of the indentations can be a time-consuming task. Sometimes the formatting of a sheet has indentation on multiple levels, such as with this example of an income statement. Remove Indentation Formatted Income Statement.xlsx Removing Indentation from Multiple Cells Watch on YouTube & Subscribe to our Channel Download the Excel Fileįollow along using the same file I use in the video. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |