14 MORE Excel Formatting Tips (Make Excel Beautiful AGAIN)
Tiger Spreadsheet Solutions Tiger Spreadsheet Solutions
94K subscribers
18,902 views
204

 Published On Jan 12, 2023

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.

🔥FREE EXCEL DATA ANALYSIS CRASH COURSE
https://tinyurl.com/2p9f8w9e

💼FILE DOWNLOAD LINK
https://tinyurl.com/nhdbfj78

14 MORE EXCEL FORMATTING TIPS

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

📺1st VIDEO IN THE SERIES
   • 14 Excel Formatting Tips (Make Excel ...  

🔥FREE EXCEL DATA ANALYSIS CRASH COURSE
https://tinyurl.com/2p9f8w9e

show more

Share/Embed