Essential to Expert Skills progression

Excel tutorials

The only Excel books you will ever need

  • The only constantly updated Excel 365 titles more…
  • Thoroughly covers Power Pivot and Power Query more…
  • Covers business intelligence and OLAP features more…
  • Simple, easy, understandable, 2-page lessons more…
  • Available as both printed books and e-Books more…
  • Used by schools, colleges and universities  more…
  • Available for 365, 2019, 2016 and Mac versions more…

Changing cell padding in Excel

If you have a background in web design or desktop publishing you might be familiar with the concept of ‘cell padding’, where tables have a certain amount of ‘padding’ space within the cells. Excel doesn’t have a concept of cell padding, but the same effect can be achieved by resizing rows and columns and changing the alignment settings of cells.

Excel’s ‘grid’ layout can make it challenging to create the layouts you need, but using the techniques shown in this article should allow you to create almost any layout.

If you’re unfamiliar with resizing Excel rows and columns you could greatly benefit from our completely free Basic Skills E-book, which will teach you the basics of Excel in a very short time.

Centering text inside a cell

A common ‘cell padding’ requirement is to center some text inside a cell with ‘padding’ space surrounding it.

In this example I want to center the text The Smart Method in cell B2 with padding around it.

The first thing to do is click on cell B2 to select it and set its horizontal and vertical alignment settings to Center and Middle Align.

Now the text in cell B2 will always be centered within it. If you resize column B and row 2 you should be able to achieve the ‘padded’ effect you need.

You should be able to achieve this using just the skills taught in our free Basic Skills E-book.

Indenting text

Sometimes you want to add padding to the left of a cell instead of centering it. You can do this by using the Home > Alignment > Increase Indent button.

Using Drawing objects

There may be times when you need a design that simply can’t be achieved by formatting cells. In these cases you can insert ‘Drawing’ objects, including text boxes, speech bubbles, arrows and many other shapes.

Drawing objects can be inserted using the Insert > Illustrations group on the Excel Ribbon.

Text boxes and drawings are covered in greater depth in our Essential Skills and Expert Skills Books and E-books.

Share this article

Share on facebook
Share on twitter
Share on linkedin
Share on stumbleupon
Share on email

Recent Articles

Excel protected view warning

Excel protected view: Be careful – files from the Internet can contain viruses. Unless you need to edit it’s safer to stay in Protected View. This article explains what this error message means.

VLOOKUP inexact match illustration (chicken and egg).

VLOOKUP inexact match

VLOOKUP lesson with sample file that will teach you everything there is to know when creating a VLOOKUP inexact match Excel function.

VLOOKUP exact match

Simple VLOOKUP tutorial with sample file that will teach you everything there is to know when creating a VLOOKUP function with an exact match.

Clients

When you use The Smart Method you’re in good company Here are some of the companies that The Smart Method have helped empower with excellent

Microsoft Office update channels

Microsoft Office update channels are explained in this article. Beta, Current, Monthly Enterprise and Semi-annual enterprise are all covered.

Leave a Reply

Your email address will not be published.

1 × 1 =