"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Excel Users Become Local Spreadsheet Experts"

How To Indent Text Without Adding Extra Spaces


Many times you will find that when you have a column of text immediately to the right of a column of numbers they both look 'squat together.'

Many people insert spaces at the beginning of each of their text entries to provide some 'white space'. There are various reasons why this is not the best option, including the fact that it is very time consuming.

There is a much easier way easier way to achieve the same result without the various side-affects.

Here's what you do:

  1. Select the cells that contain the data you want indented;
  2. From the Format menu select Cells... ;
  3. Click on the Alignment tab and select Left (Indent) from the Horizontal dropdown list;
  4. On the Indent spinner box set the number of spaces you want to insert between the start of your text and the left edge of the the column;
  5. Click OK and you're done.
If you find that you use this procedure often you may want to customize your toolbar to include the Decrease Indent and Increase Indent buttons. That will allow you to accomplish the same result in fewer clicks.


Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.