Excel: Advanced Formatting Techniques

Introduction

• Advanced formatting in Excel

• Subscript, underline, and strikethrough text
• Center across a selection vs. merged cells
• Create angled text for readability and organization
• Indent cell contents and add new lines within a cell
• Insert symbols: Bullet points, stars, and François

• Dates and custom formatting
• Make consistent entries with Find and Replace
• Positive and negative numbers
• Format hours, minutes, and seconds
• M for millions and K for thousands
• Format numbers with Power Query

• Group and align shapes
• Transform text into shapes with WordArt
• Place text inside a shape

• Conditional formatting for duplicates
• Highlight fast-approaching dates
• Conditional formatting for icons
• Conditional formatting for strikethrough fonts

• Page numbers and page breaks
• Print preview
• Format your worksheets to control what gets printed

• Format multiple sheets at once
• Set workbook defaults to open with your preferences

• Format tables
• Format slicers
• Apply workbook themes and styles

• Grid lines, legends, and other chart formatting
• 3D, shadows, and other advanced chart formatting

• Install and uninstall fonts
• Format your worksheet's background with an image
• Manage hyperlinks
• Color-picker and RGB code for colors
• Clear Formatting

• Getting the most from Excel