A reader recently asked if there was any way that she could adjust the text margins within a cell in her Worksheet.
I had to tell her that there is no Excel command that will add more space like you can in Word tables or with the CELLPADDING attribute in an HTML table.
There is, however, a way in which you can accomplish this, but you will have to do this manually.
Follow the steps below to learn how:
- Select the cell you in which you would like more white space.
- Display the Home tab of your Ribbon.
- Click the small icon on the bottom-right of Number group to display the Format Cells dialog box.
- Be certain the Alignment tab is displayed.
- Under Horizontal, use the drop-down to select Center.
- Under Vertical, use the drop-down to select Center.
- Click OK.
You can now adjust your column width to leave the amount of white space that you would like on both sides of your cell.
You can also adjust your row height to leave the amount of white space above and below your cell contents.
The only drawback is that it will affect the width the entire row and column. Also, your numbers will not line up properly with a decimal point. There is a way around this. You can still center your contents horizontally, but you must use a custom number format for the cells:
[???, ??0.00;-??, ??0.00]
The question marks will force Excel to leave space as if there were a digit even though there is not.
You cannot change the vertical white space without adjusting your row height. You can, however, try this if you want to change your horizontal white space:
Adjust the indent value used in your cell. All you have to do is display the Format Cells dialog and set the indent on the Alignment tab.
You can adjust the left or the right indent, but not both.