As before, select your cell range within the spreadsheet, right-click on the selection, and then click “Format Cells.” In the “Alignment” tab, click on the “Vertical” drop-down menu. you to change the attributes of cell font, including font face, size, style, and color. If you want to add extra spacing between your text and the top and bottom cell borders, you can also do this from within the “Format Cells” options box. To open the Format Cells dialog box, do one of the following. Adding Extra Spacing Between Top and Bottom Cell Borders With this cell formatting applied, the cell values keep the extra padded boundaries against the cell borders, even if you change the width of the column manually. In the example below, we’ve applied a distributed indent to the cell borders in column B, using four spaces, to allow for equal padding between the cell text and the left and right cell borders. The additional padding between your text and cell borders will be applied to your selected cell range. Once you’re ready, click the “OK” button to save any changes. Click the up and down arrows or type a number in the box.
In the “Indent” box, select the size of your additional spacing.