We will show you some sample table designs in Excel.
Sample table designs
Because of Excel’s structure, you do not have the same flexibility as you would in a word processor. Or, in a desktop publisher app. However, with some creative thinking, designing fancy stuff is always possible.
Also, the good thing about tables in Excel is that, performing calculations is part of the program. Moreover, you can easily integrate tables with graphs. Now, that is great. Overall, it opens you up to a whole new set of ideas.
Here are some designs you may find userful in your work.
Design 1
Standard format with a total row that automatically calculates the total.
Design 2
Table containing a focus row.
Design 3
A table with a highlighted content row, and a highlighed total row. Nice colors.
Design 4
Now, we get a little fancy, with a colorful first column, a highlighted content row, and a highlighted total row. This is good stuff!
Design 5
Same as the above design, except, this version has a border between the last two columns.
Design 6
This table is similar to the previous ones. Except, we include a summary row within our highlighted row.
Design 7
So, this one includes a callout. It floats on the page. In this instance, we did the callout in Excel, but you can do it in another app, such as PowerPoint. In that case, you would put your table in such app.