Adding a little extra padding to the limits of your cells can make it easier to read data in a Microsoft Excel spreadsheet. If you want to add extra white space between text and cell borders, here’s how.
Added extra spacing between left and right cell borders
To add the extra space you need between the borders of a cell and the data it contains, you need to align your text or numbers with indentation. Formatting your cells to do this will give you extra space between your cell border and the start of your data.
To get started, open your Excel spreadsheet and select the cells you want to format. Right-click the cells you have selected, then click the “Format cells” button.
This opens the “Format cells” options box. From there you can change everything from your cell number type to font style. Click on the “Alignment” tab and then open the “Horizontal” drop-down menu in the “Text alignment” section.
For additional space between the cell text and the left or right border of the cell, click “Left (Indent)” or “Right (Indent)”. Click “Distributed (Withdrawal)” to have equal spacing between text and cell borders on both sides.
In the “Withdrawal” box, select the size of your additional space. Click the up and down arrows or enter a number in the box.
Once you are ready, click the “OK” button to save the changes.
The extra padding between your text and the cell borders will be applied to the selected cell range.
In the example below, we applied a distributed indentation to the cell borders in column B, using four spaces, to allow for equal filling between the cell text and the left and right cell borders.
With this cell formatting applied, the cell values retain the additional padded limits relative to the cell borders, even if you change the column width manually.
Added extra spacing between the top and bottom cell borders
If you want to add extra spacing between your text and the top and bottom cell borders, you can also do this from the “Format cells” option box. As before, select your range of cells in the spreadsheet, right-click on the selection, then click “Format Cells”. In the “Alignment” tab, click on the “Vertical” drop-down menu.
Select “Top” to align your cell data to the top of your cell, “Center” to ensure equal space between the top and bottom, or “Bottom” to align your text to the bottom of your cell.
Click “OK” to apply the new formatting to your cells.
Depending on the option you choose, your cell data will now be aligned with the option you choose. If you chose to use the “Center” option, this will align your text in the middle of the cell. You can see it in action by modification of line height to allow a “higher” row.
In the example below, each of these options was used with a text string containing the alphabet.
You can combine horizontal and vertical alignment of the text for your cells if you prefer. This allows you to apply additional spacing between your cell data and each of your cell borders.