Updating the previous edition's tips to include features in Excel 2016, this new edition of MrExcel's popular software guide even incorporates suggestions sent in by readers. Each featured topic has a problem statement and description, followed by a broad strategy for solving the problem. MrExcel then walks readers through the specific steps to solve the issue. Alternate strategies are also provided, along with common scenarios that trip users up, leaving readers with not only answers to their specific dilemmas but also new and quicker ways to use formulas and spreadsheets.
Author(s): Bill Jelen
Edition: 2017 edition.
Publisher: Holy Macro! Books
Year: 2017
Language: English
Pages: xx+553
Tags: Microsoft Excel (Computer file);Electronic spreadsheets;Tableurs;Business -- Computer programs;Affaires -- Logiciels
Cover
Title Page
Credits
Table of Contents
About the Author
Dedication
Foreword
Acknowledgments
Why Does Office 365 Have Better Features?
Which Version of Office 365 Has Power Pivot?
Why Do I Have to Sign in to Excel?
How Can I Use Excel on Dual Monitors?
How Can I Open The Same Workbook Twice?
Find Icons on the Ribbon
Where is File, Exit?
Where Are My Macros?
Customizing the Ribbon
Go Wide
Minimize the Ribbon to Free Up a Few More Rows
Use a Wheel Mouse to Scroll Through The Ribbon Tabs
Why Do The Charting Ribbon Tabs Keep Disappearing? Use Dialog Launchers For More ChoicesIcon, Dropdowns, and Hybrids
Zoom is at the Bottom
Make Your Most-Used Icons Always Visible
The Excel 2003 Alt Keystrokes Still Work (If You Type Them Slowly Enough)
Use Keyboard Shortcuts to Access the Ribbon
Why Do I Have Only 65,536 Rows?
Which File Format Should I Use?
Why Does The File Menu Cover The Entire Screen?
How Do I Close The File Menu?
Increase the Number of Workbooks in the Recent Files List
Change All Print Settings in Excel
I Just Want The Old Print Preview Back
Get Quick Access to Formatting Options Using the Mini Toolbar. What Is Protected Mode?Use a Trusted Location to Prevent Excel's Constant Warnings
My Manager Wants Me to Create a New Expense Report from Scratch
Open a Copy of a Workbook
Open Excel with Ctrl+Alt+X
Have Excel Always Open Certain Workbook(s)
Set up Excel Icons to Open a Specific File on Startup
Use a Macro to Customize Startup
Control Settings for Every New Workbook and Worksheet
Excel Says I Have Links, But I Can Not Find Them
Automatically Move the Cell Pointer After Enter
Return to the First Column After Typing the Last Column
Enter Data in a Circle (Or Any Pattern). How to See Headings as You Scroll Around a ReportHow to See Headings and Row Labels as You Scroll Around a Report
Why is the Scrollbar Slider Suddenly Tiny?
Why Won't My Scrollbar Scroll to My Charts?
Jump to the Edge of the Data
Jump to Next Corner of Selection
Ctrl+Backspace brings the Active Cell into View
Zoom with the Wheel Mouse
Copy a Formula to All Data Rows
Copy the Characters from a Cell ƯInstead of Copying an Entire Cell
A Faster Way To Paste Values
Quickly Turn a Range on Its Side
Quickly Rearrange Rows Or Columns
Quickly Copy Worksheets. Use Group Mode to Change All WorksheetsFind Text Numbers
Why Can't Excel Find a Number?
Mix Formatting In A Single Cell
Enter a Series of Months, Days, or More by Using the Fill Handle
Have the Fill Handle Fill Your List of Part Numbers
Teach Excel to Fill A, B, C
Add Total to the End of Jan, Feb ... Dec
Put Date & Time in a Cell
Use Excel as a Word Processor
Add Excel to Word
Use Hyperlinks to Create an Opening Menu for a Workbook
Spell check a Region
Stop Excel from AutoCorrecting Certain Words
Use AutoCorrect to Enable a Shortcut.
