When applying a right-aligned format to column labels in Excel, the text ends up being squeezed right against the borders, which does not make for easy reading. To fix this problem, you can add easily add some space between the border and your text.
To add a space between right-aligned text and border:
- Click the Home tab on the Ribbon.
- Click the Dialog Launcher on the Number group on the Ribbon.
- Click “Custom” in the Category list window.
- Click in the Type field and type the @ symbol, followed by a blank space. If you wish more space between the border and the end of your text, enter as many spaces as you like.
- Click OK.
Similar Posts:
- None Found
