Learn Excel from Mr. Excel Part 4 - Formatting

Table of Contents: Learn Excel From Mr Excel - 277 Excel Mysteries Solved

Part 4: Formatting

• Create a Chart with One Click
• Change a Chart from a Chart Sheet to an Embedded Chart
• Customize Anything on a Chart with Right-click
• How to Minimize Overlap of Pie Chart Labels
• Add New Data to a Chart
• Add a Trendline to a Chart
• Display Profitability in a Profit Waterfall Chart
• For Each Cell in Column A, Have Three Rows in Column B
• Copy Formatting to a New Range
• Copy Without Changing Borders
• Leave Helpful Notes with Cell Comments
• Change Appearance of Cell Comments
• Force Certain Comments to be Always Visible to Provide a Help System to Users of Your Spreadsheet
• Control Name That Appears in Comments
• Change Shape of Comment to a Star
• Add a Pop-up Picture of an Item in a Cell
• Add a Pop-up Picture to Multiple Cells
• Change the Background of the Worksheet
• Add a Printable Background to Your Spreadsheet
• Remove Hyperlinks Automatically Inserted by Excel
• Change Width of All Columns in One Command
• Control Page Numbering in a Multisheet Workbook
• Use White Color for Fonts to Hide Data
• Hide and Unhide Data
• Temporarily See a Hidden Column Without Unhiding
• Build Complex Reports Where Columns in Section 1 Don’t Line up with Section 2
• Paste a Live Picture of a Cell
• Monitor Far-off Cells in Excel 2002 and Later Versions
• Add a Page Break at Each Change in Customer
• Use Horizontal Page Breaks Even When You Use Fit to N Pages Wide
• Hide Error Cells When Printing
• Organize Your Worksheet Tabs with Color
• Copy Cell Formatting, Including Column Widths
• Why Does Excel Mark All My TRUE Cells with an Indicator?
• Debug from a Printed Spreadsheet
• Copied Formula Has Strange Borders
• Double Underline a Grand Total
• Use the Border Tab in the Format Cells Dialog
• Fit a Slightly Too-Large Value in a Cell
• Show Results as Fractions
• Color All Sales Green for a Day if Total Sales > $999
• Color Sales for a Day That Exceeds $999
• Turn off Wrap Text in Pasted Data
• Delete All Pictures in Pasted Data
• Draw an Arrow to Visually Illustrate That Two Cells Are Connected
• Add an AutoShape to Your Worksheet
• Draw Perfect Circles
• Draw Perfect Squares
• Draw More Than the Four Basic Shapes
• Change an Existing AutoShape
• Add Text to an AutoShape
• Use the Toolbar to Change Three Colors of an AutoShape
• Rotate an AutoShape
• Alter the Key Inflection Point in an AutoShape
• Add a Shadow to an AutoShape
• Add a 3-D Effect to an AutoShape
• Add Connectors to Join Shapes
• Join Two AutoShapes
• Change Properties of Only One AutoShape in a Group
• When Two AutoShapes Overlap, Control Which Is on Top
• Make Any Logo into an AutoShape
• Use the Scribble Tool
• Place Cell Contents in an AutoShape
• Draw Business Diagrams with Excel
• Draw Org Charts with Excel
• Add WordArt to a Chart or Worksheet
• Use MapPoint to Plot Data on a Map
• Add a Dropdown to a Cell
• Store Lists for Dropdowns on a Hidden Sheet
• Add a ToolTip to a Cell to Guide the Person Using the Workbook
• Configure Validation to “Ease up”
• Use Validation to Create Dependent Lists

Part 1: The Excel Environment

Part 2: Calculating with Excel

Part 3: Wrangling Data

Part 4: Formatting Excel