Tag Archives: Formatting

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:

How to use Excel Conditional Formatting to highlight past dates

Excel has very powerful feature called conditional formatting. In this post I will demonstrate how to use the feature to automatically highlight past dates in different way than future dates.

  • I use TODAY()-function to get current date
  • I set conditional formatting so that when the value of the cell is less than TODAY(), it will be formatted

Following video demonstrates this: