Indent Option in the Format Cells Dialog Box.This will still make it look like a cohesive chunk with the indent defining a different set of information. Sticking to the simple look of things, we will indent the addresses slightly to the right. All options have their bright moments and it really depends on the dataset. The text alignment of the addresses can be changed to center or right too.

There are several ways to make the store names stand out from the text which includes emboldening the store names or making a table with store names as headers. Of course when read, one can make out that these are superstores and addresses but right off the bat it's all just one chunk of information. Although Excel is built for some very different purposes when compared with Word processors, but it certainly does give you the ability to easily intent information within a cell.įor the days when left, right or center-aligned don't cut it, welcome to the tutorial where you learn how to Indent text in Excel. Generally, indentation is associated with tools like MS word or other word processors. This is why you will find the indent options in the alignment sections in Excel. Indentation has all to do with the alignment of text. We will talk about indenting text in a cell in Excel. If you punch some text in Excel and hit the enter key, you'll notice that the text is left-aligned by default and that's what we're trying to change today.

Excel shortcut key to center text