Excel: Advanced Formatting Techniques (365/2019)

Learn advanced formatting techniques in Excel that can help you create effective and appealing spreadsheets.

View simple, powerful tips for making Excel data more readable and easier to manipulate. Author Dennis Taylor shows you how to emphasize individual cells with fonts, borders, and colors; adjust the position of cell contents; format numeric data; and increase the readability of worksheets. You can also learn how to add images to worksheets and discover automation techniques that can take the drudgery out of formatting even large amounts of data.

Introduction

• Harness the power of Excel formatting techniques

1. Alignment Tools

• Create angled text variations for variety and readability
• Indent data and dollar signs
• Use the Merge and Center button to simplify title adjustments
• Use Wrap Text and Shrink to Fit to control titles and headings

2. Adjusting Numeric Formats

• Build custom numeric formats
• Create custom date formats

3. Tables, Styles, and Themes

• Work with tables
• Use styles and themes for consistent formatting

4. Row, Column, and Sheet Adjustments

• Work with rows, columns, and sheets
• Use the Hide & Unhide options

5. Other Worksheet Formatting Tools

• Use the Format Cells dialog box and formatting part of a cell
• Format text from Word or the web with the Justify feature
• Add a background image to a worksheet

6. Displaying Data as an Outline

• Set up data for outlines
• Use the Subtotal feature to create outlines

7. Formatting Images

• Format picture styles
• Add borders and effects to pictures
• Format Sparklines for visual impact
• Use WordArt for formatted titles and headings

8. Specialized Power Formatting Techniques

• Hide repeating titles in a column to clarify printed output
• Restore missing title data in a column
• Display large values without using formulas
• Create picture links
• Format column and row titles
• Format a list for double-spaced printing

Conclusion

• Next steps