Learn Excel from Mr. Excel: 277 Excel Mysteries Solved

Book Cover
 Half Title
 Full Title
 Copyright Page
 Table Of Contents
 About The Author
 Acknowledgments
 Dedication
 Foreword
 Part-I: The Excel Environment
 Show Full Menus All The Time
 Show Full Toolbars All The Time
 Add A Close Button To The Standard Toolbar
 Close All Open Workbooks
 Double The Value Of The Recently Used File List
 Remember Workbooks To Open Using A Workspace
 Automatically Move The Cell Pointer In A Direction After Entering A Number
 How To See Headings As You Scroll Around A Report
 How To See Headings And Row Labels As You Scroll Around A Report. How To Print Titles At The Top Of Each Pageprint A Letter At The Top Of Page 1 And Repeat Headings At The Top Of Each Subsequent Page
 How To Print Page Numbers At The Bottom Of Each Page
 How To Make A Wide Report Fit To One Page Wide By Many Pages Tall
 Arrange Windows To See Two Or More Open Workbooks
 Why Is There A \":2\" After My Workbook Name In The Title Bar?
 Have Excel Always Open Certain Workbook(S)
 Set Up Excel Icons To Open A Specific File On Startup
 Use A Macro To Further Customize Startup
 Control Settings For Every New Workbook And Worksheet
 Open A Copy Of A Workbook. Open A Saved File Whose Name You Cannot Recallsuppress The Update Links Message
 Send Excel File As An Attachment
 Save Excel Data As A Text File
 Use A Laser Printer To Have Excel Calculate Faster
 Use Excel As A Word Processor
 Spellcheck A Region
 Use Hyperlinks To Create An Opening Menu For Your Workbook
 Get Quick Access To Paste Special
 Use Shift Key To Reverse Popular Toolbar Icons
 Create A Menu Or A Toolbar Of Your Favorite Icons
 Restore Your Menus After Customizing
 Quickly Copy A Formula To All Rows Of Data
 Quickly Turn A Range On Its Side. Stop Excel From Autocorrecting Certain Wordsuse Autocorrect To Enable A Shortcut
 Why Won\'t The Track Chages Feature Work In Excel?
 Copy Cells From One Worksheet To Many Worksheets
 Have Excel Talk To You
 Enter Special Symbols
 Find Text Entries
 Copy A Formula That Contains Relative References
 Copy A Formula While Keeping One Reference Fixed
 Create A Multiplication Table
 Calculate A Sales Commission
 Simplify Entry Of Dollar Signs In Formulas
 Learn R1c1 Referencing To Understand Formula Copying
 Create Easier-To-Understand Formulas With Named Range
 Use Named Constants To Store Numbers. Build A Formula Using Labels Instead Of Cell Addressesuse Natural Language Formulas To Refer To The Current Row
 Assign A Formula To A Name
 Total Without Using A Formula
 Count, Average, Etc. Without Using A Formula
 Add Two Columns Without Using Formulas
 How To Calculate Sales Over Quota
 How To Join Two Text Columns
 How To Sort On One Segment Of An Account Id
 How To Isolate The Center Portion Of An Account Id
 How To Isolate Everything Before A Dash In A Column By Using Functions
 How To Use Functions To Isolate Everything After A Dash In A Column. How To Use Functions To Isolate Everything After The Second Dash In A Column.