Tag Archives: Format

How to customise Excel table’s look and feel

There are numerous ways you can customise how your Excel table looks. Yo can e.g.

  • Change the font color or cell’s fill color
  • Make texts bold, italic, etc.
  • Draw different kinds of borders around your cells
  • Align cell’s texts different ways
  • Merge cells to make it easier to align texts the way you like
  • Adjust column widths and cell heights
  • Hide Excel’s gridlines
  • …and much more…
A shortcut tip: You can open Format Cells -dialog by pressing
  • Windows: ctrl + 1
  • Mac: cmd + 1

Following demonstration video shows some of these techniques to format a table:

Excel: How to show number in custom format

You are able to format Excel’s cell items as you like. You can e.g. add custom texts to be shown with numbers. Typical case is to show numbers with units:

  1. Select the cell/cells you want to format:
    Context menu: Select Format Cells
    Shortcut: Windows ctrl + 1, Mac cmd + 1
  2. Select Number and Custom from the Category list.
  3. If you want to one decimal and unit, type following format code
    0.0″ kg” or
    0.0″ lb”
Following video demonstrates this in action: