Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there a way to add padding to cells in Excel 2010?

The spreadsheet I'm using has cells in one column with varying row heights. I don't want to center the text, I just want it padded slightly from the left side.

share|improve this question
up vote 3 down vote accepted

Note: I'm on Excel 2007, but I would be surprised if this doesn't work.

Select the cells, right click, select Format Cells.

Move to the Alignment tab, set the Horizontal value to Left (Indent) and adjust the Indent value as desired.

There should be two alignment buttons on the ribbon as well (that increase or decrease the indent), they look like this:

Excel 2007 ribbon; highlighted decrease/increase indent buttons

share|improve this answer
Looks good, I wish they offered something similar on vertical alignment. – Seth P. Jan 28 '11 at 20:44
@SethP. - See ingenious solution (hide dummy column with fat borders):… – aparente001 Sep 19 '15 at 22:40

That's an 'indent'. Cell padding is exactly the same thing as page margins, but at the cell level. Excel does not currently support this feature although it is supported in Word tables. Go figure.

share|improve this answer
I don't know why it was down-voted, he is right. – void May 9 '12 at 23:16
Years later, 2013 is out and still no cell margin to be found. Les' answer is indeed the correct one. – GroundZero Dec 21 '14 at 20:26

You can cheat and apply a border to all 4 sides of the cell that is the same color as the cell background. Do this in the Home tab - Format (in the cells group) - Borders, or select the cells and right click, then choose "format cells" at the bottom of the dropdown.

Make sure you click the border icons on the right AFTER you set the border color and width. Even if they are already highlighted, they do not apply the color unless they are clicked again after you select them and set the border color.

share|improve this answer
Options for border width seem to be limited. The thick option in Excel 2010 fails to satisfy. – Smandoli Dec 28 '15 at 16:42
  1. Select the cell range and increase the fonts size several points.
  2. Auto fit the column width and row height.
  3. Set the font size back to the original size.

This takes a few steps, but it gets the look I want without the padding feature. I also like to center the type vertically once this is done.

share|improve this answer

I just press Alt+Enter before the first row and after last one (you must be in the cell by double clicking it).

Of course it is pain if you work dozens of data, but if you fill the rows from zero it does the trick.

share|improve this answer
question is about adding left indent, but you give an answer how to add space on the top. Why? – Máté Juhász Jan 6 at 10:07

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.