14 Excel Formatting Tips (Make Excel BEAUTIFUL!)

14 Excel Formatting Tips (Make Excel BEAUTIFUL!)

Here’s a topic I’ve avoided for some time. That’s because what looks ‘good’ is a matter of opinion, right? What one person likes differs from the next. It’s all subjective … or is it?

🔥FREE: YOUR EXCEL CHEATSHEET MINI-COURSE
https://tinyurl.com/jxezd355

With Excel, I’ve come to realise, over the years, this isn’t the case. Yes, though the finer points of spreadsheet presentation will always be a matter of debate, you can do some things to guarantee your spreadsheet looks better.

💼EXCEL DOWNLOAD FILE
https://tinyurl.com/yckjym77

It’s not just about Excel ‘looking’ better, however; an effectively formatted spreadsheet encourages people to engage with the data. In fact, that’s the only purpose of formatting in Excel: to help people understand the story of the data. It’s one way for your data analysis to have more impact.

🔥FREE: YOUR EXCEL CHEATSHEET MINI-COURSE
https://tinyurl.com/jxezd355

With that said, let’s look at 14 easy Excel formatting tips you can start using today.

14 EXCEL FORMATTING TIPS

00:00 Introduction
01:28 Leave a few rows at the top / columns on the right
02:14 Ensure column widths are consistent (a unit?)
03:33 Change default font (use Arial?)
04:33 Adjust row heights (competing with text?)
04:38 Ensure Consistent row heights are consistent (14.4?)
05:43 Wrap text
06:20 Use a comment (avoid long headers)
07:09 Consider hiding columns
07:43 Have a colour scheme (one colour!)
08:02 Use dark colour with white text (as an alternative)
11:08 Consider differentiation in font size (for page title?)
11:48 Use horizontal borders only
12:36 Switch off gridlines (for a clean look)
12:54 Consider different line styles (heavier at top / on left)

Any formatting tips I haven’t covered in this video? Leave me a comment on YouTube, I will get back to you there.

Leave a Reply

Close Menu