One my favorite little Excel tricks

One my favorite little Excel tricks


1 minute read

One my favorite little Excel tricks:

๐—ฆ๐—ถ๐—ป๐—ด๐—น๐—ฒ ๐—”๐—ฐ๐—ฐ๐—ผ๐˜‚๐—ป๐˜๐—ถ๐—ป๐—ด format.

It lets you add just the tiniest little space b/t your headers for a much cleaner look.

Take a look at the image below -- do you see the tiny space b/t Periods 1, 2, & 3 (at the bottom)?

That's done using the Single Accounting format.

Here's how to do it:

-- pick the cell you want to format, then press Ctrl + 1 (format cells box)

-- click on the "Font" ribbon at the top

-- then click the dropdown below "Underline:"

-- Select "Single Accounting"

-- then click "OK"

An underline should appear below the cell.

This is an awesome look if you have a bunch of months going across the top, or for summaries on a dashboard.

One of the first things I learned at FTI Consulting is "๐—ณ๐—ผ๐—ฟ๐—บ๐—ฎ๐˜๐˜๐—ถ๐—ป๐—ด ๐—บ๐—ฎ๐˜๐˜๐—ฒ๐—ฟ๐˜€ ๐—บ๐—ผ๐—ฟ๐—ฒ ๐˜๐—ต๐—ฎ๐—ป ๐˜†๐—ผ๐˜‚ ๐˜๐—ต๐—ถ๐—ป๐—ธ"

Still as true as ever.

Give it a try!

—Chris

If and when the time is right, I offer refreshingly straightforward Financial Modeling Courses for FP&A and Private Equity Professionals that have been recognized all over the world.  Check them out if you're interested (if not, that's cool too ๐Ÿ‘).  Just click here.

ยซ Back to Blog