Written by Allen Wyatt (last updated April 25, 2020)
This tip applies to Excel 97, 2000, 2002, and 2003
Alfred wonders if there is a way to increase spacing between characters in a cell. He is not talking about spacing between cells, but between characters in a single cell.
The short answer is that you can't do this. Word lets you adjust this type of spacing, but Excel does not. For that reason, you may want to import your Excel data into Word as a table and make the advanced character formatting changes there.
If that is not possible, then the only thing you can do in Excel is try to apply a few workarounds. One such workaround is to play with the font used for your characters. You might try different fonts that use different character spacing; this could take quite a bit of trial and error to find the font that is right for your needs.
Another possible approach is to use different, contrasting fonts within a cell. For instance, if you alternate the formatting of sequential characters between Arial and Arial Narrow, you may end up with the spacing you want.
The only other option is to add characters between existing cell characters. For instance, you could add a space between each character in the cell and then format those spaces to a font size that gives the desired overall appearance. You could also insert thin spaces, which is done using the Symbol dialog box.
Remember that when you insert extra spaces between characters in a cell, it changes what is actually stored in a cell. Thus, your numeric values will start being treated as text by Excel and formulas that rely upon a certain character sequence will no longer work (because you've changed the sequence of the characters in the cell).
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (12473) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Changing Character Spacing.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!
There are any number of reasons to format different cells in different colors. Excel allows you to easily change the ...
Discover MoreExcel allows you to format your numeric values in a wide variety of ways. One such formatting option is to display ...
Discover MoreWhen creating custom formats, you can employ a wide range of codes to define your formatting pattern. This tip focuses on ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments