14 MORE Excel Formatting Tips (Make Excel Beautiful AGAIN)
What makes an Excel spreadsheet look good is all a matter of opinion, right? Well, I’m not so sure.
I think there are certain things you can do to any Excel spreadsheet to make it look better.
In this video, I share 14 Excel formatting tips and techniques that you can start using now to create beauty in Excel. It’s a follow-up to our popular ‘Make Excel Beautiful’ video.
.jpg)
00:00 Make Excel Beautiful?
00:20 Excel Data Analysis Minicourse
01:00 Classy indentation
01:30 Format formulae differently
02:00 Protect formulae(?)
03:32 Format dropdowns differently (Input Message)
05:00 All upper case for header (and column groupings)
Merging cells can be dangerous!
07:24 Keep zoom level consistent (custom navigation?)
08:15 Try on different monitor / screen resolution
09:00 Consider conditional formatting (but manage it carefully!)
10:26 Reduce no. zeroes (#,##0.0,)
12:14 Symbols (eg. $) needed in cells?
12:38 Force Excel to show decimal places (?)
13:34 Build up a format store (copy formats from here)
14:40 Control sheet tab colours
00:20 Excel Data Analysis Minicourse
01:00 Classy indentation
01:30 Format formulae differently
02:00 Protect formulae(?)
03:32 Format dropdowns differently (Input Message)
05:00 All upper case for header (and column groupings)
Merging cells can be dangerous!
07:24 Keep zoom level consistent (custom navigation?)
08:15 Try on different monitor / screen resolution
09:00 Consider conditional formatting (but manage it carefully!)
10:26 Reduce no. zeroes (#,##0.0,)
12:14 Symbols (eg. $) needed in cells?
12:38 Force Excel to show decimal places (?)
13:34 Build up a format store (copy formats from here)
14:40 Control sheet tab colours