Looking at a spreadsheet that hasn’t been formatted at all can feel like hard work, and honestly it’s not very inviting either. A well formatted spreadsheet should make the key information practically jump off the page, without the reader needing to study every cell to work out what matters.
Start with the basics
Pick one font and stick to it throughout the file, Aptos is the latest Microsoft default font and works well as it’s easy to read at any size. Use size and bold to separate your headings from ordinary data, so the eye naturally knows where to look first. Number formatting matters more than people expect too, currency, percentages and dates should always look like currency, percentages and dates, not just plain numbers the reader has to interpret themselves.
Colour and borders are simple to add and can be super effective, since the eye is drawn to a colour without needing to read or understand any of the detail behind it. Just don’t go overboard, more on that below.
Let Conditional Formatting do the highlighting for you
Rather than manually colouring cells that meet a certain condition, Conditional Formatting does it automatically and keeps doing it as your data changes. Data Bars fill a cell with a bar proportional to its value, Colour Scales shade a cell based on where it sits in the range, and Icon Sets add a little visual indicator, all of which look genuinely ACE and make trends obvious at a glance.
Tables and charts
Converting a range into a proper Excel Table (Ctrl+T is the shortcut) gives you automatic banded rows, built in filtering and sorting, and a much tidier look with barely any effort. Charts are worth the same care, choosing the right chart type and cleaning up the title, legend and labels makes a huge difference to how professional the end result looks.
Keeping it readable
- Consistency: same font, size and colour scheme throughout the file.
- Simplicity: you don’t need to use every formatting option Excel offers on one spreadsheet, keep it simple.
- White space: adjust column width and row height so data isn’t cramped, and use Wrap Text where it helps.
- Alignment: numbers right aligned, text left aligned, it’s a small thing but it reads properly.
Bonus Tip: once you’ve spent time formatting a spreadsheet, it’s worth protecting it (Review tab, Protect Sheet) so nobody accidentally wipes out your hard work.
Get these basics right and your spreadsheets stop being just a place to store numbers, they start telling a story the moment someone opens them.
