Excel Forum
Similar Content
Custom Threshold Highlighting Trick in Excel
Tutorial: How to highlight data in Excel based on the number you input into a cell and the comparis...
6 Tricks to Make Dates Work in Excel
Tutorial: Watch this tutorial if you work with dates! Quick and easy ways to reliably convert dates...
How to Add Formatting to Cells and Data in Excel Styles, Fonts, Colors, & More
Tutorial: In this tutorial I will cover how to use the various formatting tools in Excel. The Format...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Excel Magic Trick #150 Formatting Guidelines (Eye Candy)


Format Formatting Spreadsheets. Learn how to apply formatting efficiently and with eye-candy effectiveness. Learn about basic guidelines for formatting and about common pitfalls in Excel formatting. See the Format Cells dialog box and the: Number tab, Alignment tab, Font tab, Borders tab, Fill tab. See how to apply Number formatting, Alignment formatting (Center Across Selection), Font formatting, Border Formatting, Fill Pattern formatting. Learn about color theory and similar and complementary colors for Excel spread sheets, Time and Date formatting, Column width formatting, accounting formatting and more. Learn about how to apply borders in the correct order.
Format spreadsheet for printing and for looking at and working with





Got a Question? Ask it Here in the Forum.