"How To Excel" Mini-Tutorials|
"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:
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.
- Select the cells that contain the data you want indented;
- From the Format menu select Cells... ;
- Click on the Alignment tab and select Left (Indent) from the Horizontal dropdown list;
- 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;
- Click OK and you're done.
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)