Add Data to Excel Table with Total Row

With a formatted Excel table, you can turn the Total Row on or off easily, and it shows at the bottom of the table. Someone asked me how to add data to Excel Table with Total Row showing – they were hiding the totals every time they wanted to add data. You don't need to do that!

Continue reading "Add Data to Excel Table with Total Row"

Highlight Top or Bottom Values in Excel List

With Excel's conditional formatting options, you can highlight cells based on their values, or add colour scales, icons and data bars to the cells. There are built-in rules to highlight top or bottom values, and you can also create your own rules, as shown below.

Continue reading "Highlight Top or Bottom Values in Excel List"

Allow Weekend Dates Only in Excel

With Excel Data Validation, you can add rules to a data entry sheet, and control what people put in the cells. In today's example, we'll set up a cell that only allows you to enter a weekend date. Just remember that Data Validation isn't foolproof, and people can find ways around your rules.

Continue reading "Allow Weekend Dates Only in Excel"

Excel Advent Calendar No Macros

December is only 2 days away, so it's time for an Excel Advent Calendar! I've made two new versions this year, and they don't use macros, just basic Excel features. Even if you don't need an Advent calendar, take a look to see how they're set up . You might find a use for these techniques in other projects.

Continue reading "Excel Advent Calendar No Macros"