How to Add Space Between Text and Cell Borders in Excel

Microsoft Excel logo

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.

Right-click your cells in Excel, and then click Format Cells

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.

Confirm the spacing for removing the border from your cell, then click OK

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.

A table column in Microsoft Excel with indented 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.

Select your text removal options at the top or bottom from the vertical drop-down menu in the format cell area

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.

RELATED: How to set row height and column width in Excel

In the example below, each of these options was used with a text string containing the alphabet.

A cell table in Google Excel with cell formatting for text removal at the top, bottom and center applied

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.