7

I'm trying to add 2 or 3 pixel blank space at the top of all cells. but "Format Cell" doesn't have any indent for top.

(I don't want space on the top and on the bottom be the same like what center in vertical alignment does.)

I want to know is there any solution to add this 3px top padding to cells?

It doesn't matter that you use macro or any third party tools.

1

4 Answers 4

2

Sounds like you want to make the row(s) 3px taller and bottom-align all your cells.

Ways to change the row height include:

  • Click on the border between two row labels:

       

    and drag it down (or up).  Or

  • Select the row and type one of the following key sequences:

    • Alt, O, R, E, or
    • Alt, H, O, H
       

    and then type a new row height value.

1

If you won't mind doing it cell by cell, you can use Alt + Enter and adjust the font size of the created blank line.

DETAILS:

  1. Place your cursor in the beginning of your cell data;

  2. Press Alt + Enter to create a blank line;

  3. Put the cursor in the created blank line by pressing Up Arrow Key;

  4. Press Shift + Left Arrow key to highlight an invisible space;

  5. Adjust the font size of the highlighted space to 3 or any size of your choice

1

Similar to Rajesh Sinha's answer, create a column and input any text, with auto fit row height, increase font size of the created column.

0

Excel doesn't supports Cell padding.

But yes, up to certain extend this can be manged by using Alignments & Indent.

You may try this trick also:

  • Select Cell Range & increase the Font's size.
  • Apply Auto fit.
  • Finally, reverse the Font size.

This will create Cell padding look.

2
  • I don't like that this would change column widths as well, leaving them wider than necessary.
    – AdamV
    Jul 15, 2019 at 12:04
  • @AdamV,, the object was Padding Cell with White Spaces never increase size !! Jul 15, 2019 at 14:07

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .