---
title: Formatting tables
date: "2011-06-10T12:53:08Z"
categories:
  - excel-tips
  - visualisation
wp_id: 2677
description: I demonstrate how to improve Excel table formatting through specific visualization tips. Use these basic methods to enhance clarity and professional appearance beyond the standard software defaults.
keywords: [excel, data visualization, table design, spreadsheet formatting, business analytics]
---

Formatting tables in Excel is a fairly common task, but there are a number of ways to improve on the way it's done most of the time.

Here are a few tips. Fairly basic stuff, but hopefully useful.

<div class="video-embed"><iframe src="https://www.youtube.com/embed/kHvFC5uMuf8" title="YouTube video" loading="lazy" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe></div>

---

## Comments

<!-- wp-comments-start -->

- **Neela** _18 Aug 2011 6:16 pm_:
  Thanks a lot for the tips! I think there might be a small error in the video posted above, since the last part about conditional formatting is repeated twice. Very useful nonetheless!
- **[Gaurav Vohra](http://www.jigsawacedemy.in)** _27 Sep 2011 10:55 am_:
  Hey (stud) Anand , stumbled upon your blog recently. It is a great read.
  Lou Reed said "between thought and expression, lies a lifetime". I think you bridge that gap really well.
  You can add me to your list of avid followers now. :)
  I would especially recommend your blog to anyone who wants to get into the field of business analytics (all my students :) )

<!-- wp-comments-end -->