101 Excel® 2013 Tips, Tricks & Timesavers
Table of Contents
Tip 1: Changing the Look of Excel
Tip 2: Customizing the Quick Access Toolbar
Tip 4: Understanding Protected View
Tip 5: Understanding AutoRecover
Tip 6: Using a Workbook in a Browser
Tip 7: Saving to a Read-Only Format
Tip 8: Generating a List of Filenames
Tip 9: Generating a List of Sheet Names
Tip 11: Understanding Excel Compatibility Issues
Tip 12: Where to Change Printer Settings
Tip 13: Working with Merged Cells
Tip 14: Indenting Cell Contents
Tip 16: Creating Custom Number Formats
Tip 17: Using Custom Number Formats to Scale Values
Tip 18: Creating a Bulleted List
Tip 19: Shading Alternate Rows Using Conditional Formatting
Tip 20: Formatting Individual Characters in a Cell
Tip 21: Using the Format Painter
Tip 23: Showing Text and a Value in a Cell
Tip 24: Avoiding Font Substitution for Small Point Sizes
Tip 26: Resizing the Formula Bar
Tip 27: Monitoring Formula Cells from Any Location
Tip 28: Learning Some AutoSum Tricks
Tip 29: Knowing When to Use Absolute and Mixed References
Tip 30: Avoiding Error Displays in Formulas
Tip 31: Creating Worksheet-Level Names
Tip 33: Sending Personalized E-Mail from Excel
Get 101 Excel 2013 Tips, Tricks and Timesavers now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.