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