One my favorite little Excel tricks

One my favorite little Excel tricks


2 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.


Start, Grow, or Automate Your
Financial Consulting Business

Subscribe to The Finance Solopreneur and get 1 Actionable Tip each week.

    I will never sell your information for any reason.

    ยซ Back to Blog