ExcelTips Ribbon 2016 Archive (Table of Contents)

ExcelTips Ribbon 2016 Archive includes hundreds of valuable tips. The following is the Table of Contents for the archive:

Introduction

• What's In This E-Book?
• Need More Tips?
• A Special Note of Thanks
• Sharing this Document

General Tips

• Tab Key Won't Move from Cell to Cell in Locked Worksheet
• Forcing Stubborn Recalculation
• Date Last Edited
• Unhiding Columns that are Persistently Hidden
• Opening Two Workbooks with the Same Name
• Error when Double-Clicking Workbook Files
• Status Bar Summing No Longer Available
• Arranging Workbook Windows
• Choosing Direction After Enter On a Workbook Basis
• Excel Self-Tests
• Saving Non-Existent Changes
• Differences between Tables and Named Ranges
• Thoughts and Ideas on Significant Digits in Excel
• Moving from Sheet to Sheet
• Changing Ribbon Tool Defaults
• Displaying Page Breaks

Editing Tips

• Selecting Formulas
• Changing Multiple Cells at Once
• Automatically Numbering Rows
• Inserting a Radical Symbol
• Moving Cells Using the Mouse
• Pasting without Updating References
• Understanding AutoComplete
• Viewing Formula Results
• Skipping Rows when Filling
• Combining Columns
• Ensuring Rows and Columns are Empty
• Quickly Entering Dates and Times
• Entering Formulas in Excel
• Symbols Convert to Numbers in Excel
• Errors when Copying References to External Cells
• Ensuring Conditional Formatting and Data Validation is Copied
• Changing Months in a Workbook
• Not Enough Resources to Delete Rows and Columns
• Cell Movement After Enter
• Limiting Number of Characters in a Cell
• Counting Words
• Deleting All Names but a Few
• Setting a Default for Shifting when Inserting
• Pasting Multiple Paragraphs Into a Single Cell
• Clearing and Deleting Cells
• Editing Individual Cells
• Relative References to Cells in Other Workbooks
• Turning Off AutoFill for a Workbook
• Tab Key Jumps a Screen at a Time
• Creating a Shortcut for Pasting Values
• Moving and Copying Cells
• Undoing an Edit
• Conditionally Deleting Rows
• Accepting Only a Single Digit

Find and Replace Tips

• Replacing Tildes at the Beginning of a Cell
• Making All Occurrences Bold
• Finding Based on Displayed Results
• Replacing in Worksheets and Comments At the Same Time
• Deleting Dates within Text Strings
• Allowing for Prefixes and Suffixes in Find and Replace
• Using Find and Replace to Pre-Pend Characters
• Finding a Worksheet with a Specific Value in a Specific Cell

Formatting Tips

• Setting Orientation of Cell Values
• Removing All Formatting
• Widening Multiple Columns Proportionally
• Automatically Formatting for Decimal Places
• Merge and Center Not Available
• Changing Cell Colors
• Hiding a Huge Number of Rows
• Converting Dates to Text
• Changing Number Display Settings for Single Workbooks
• Decimal Tab Alignment
• Setting Row Height
• Creating a Center Across Selection Button
• Shrinking Cell Contents
• Changes in Font Size when Copying
• Setting Cell Width and Height Using the Keyboard
• Rounded Corners on Cells
• Hiding Individual Cells
• Hiding and Unhiding Rows
• Hiding and Unhiding Columns
• Displaying Negative Percentages in Red

Conditional Formatting Tips

• Highlighting Cells Containing both Letters and Numbers
• Finding Cells that Use Conditional Formatting
• Defining a Single Condition
• Conditional Formatting Based on Date Proximity
• Highlighting Values that are 10x a Baseline Value
• Controlling Data Entry in a Cell
• Turning a Cell Red when a Threshold is Exceeded

Header and Footer Tips

• Selective Headers and Footers
• Using a Formula in a Footer
• Using a Different Footer on Secondary Pages
• Ampersands in Headers and Footers

Online Tips

• Editing a Hyperlink
• Sending an E-mail when a Due Date is Reached
• Extracting E-mail Addresses from Hyperlinks
• Turning Off Hyperlink Activation
• Jumping to a Specific Cell Using a Hyperlink

Worksheet Tips

• Forcing a Worksheet to be Protected Again
• Protecting Worksheets from Deletion
• Copying a Worksheet
• Alphabetizing Worksheet Tabs
• Turning Off Worksheet Tabs
• Protecting Many Worksheets
• Creating Worksheets from a List of Names
• Creating a Copy without Formulas
• Creating a Worksheet Copy by Default
• Limiting Input by Time of Day

Worksheet Function Tips

• Returning a Worksheet Name
• Counting with Formulas
• Establishing a FLOOR and CEILING
• Calculating Combinations
• Using the IRR Function
• Finding the Nth Root of a Number
• Counting the Number of Blank Cells
• Finding the Date Associated with a Negative Value
• Random Numbers in a Range
• Using the REPT Function
• Converting to Hexadecimal
• Using the EOMONTH Function

Formula Tips

• Counting Only Money Winners
• Rounding Up to the Next Half
• Getting a Conditional Count of Cells Containing Values
• Searching for a Value Using a Function
• Counting Wins and Losses
• Counting Unique Values with Functions
• Picking Different Random Numbers from a Range
• Adding a Statement Showing an Automatic Row Count
• Counting Alphabetic Characters in a String
• Condensing Sequential Values to a Single Row
• Extracting First and Last Words
• Patterns of Numbers with a Formula
• Returning the Minimum of Integers of a Range
• Generating Random Strings of Characters
• Non-adjusting References in Formulas
• Summing When the First Character Matches a Value
• Throwing Out the Lowest Score
• Summing Digits in a Value
• Locating a Single-Occurrence Value in a Column
• Determining Combinations to Make a Total
• Incrementing Numeric Portions of Serial Numbers

PivotTable Tips

• Displaying a PivotTable's Name in the PivotTable

Sorting and Filtering Tips

• Ignoring Selected Words when Sorting
• Non-standard Sorting
• Sorting IP Addresses
• Counting Filtered Rows
• Removing Filters and Unhiding Rows and Columns on Multiple Worksheets
• Toggling AutoFilter
• Filtering for Comments
• Performing Calculations while Filtering
• Clearing Only Filtering Settings

Comment Tips

• Adding a Comment to Multiple Cells
• Locking the Size of Pictures in Comments
• Copying Comments to Cells
• Counting Comments in a Worksheet
• Editing Comments
• Keyboard Shortcut for Comments

Date and Time Tips

• Working with Elapsed Time
• Listing Dates at Regular Intervals
• Backwards Date Parsing
• Forcing Dates Forward

Graphics and Charting Tips

• Selecting Drawing Objects
• Changing a Shape
• Changing the Size of a Graphic
• Inserting a Watermark Behind Merged Cells
• Creating a Year-to-Date Comparison Chart
• Adding Data Labels to Your Chart

Printing Tips

• Printing a Portion of a Worksheet
• Setting Page Margins
• Showing Filter Criteria on a Printout
• Forcing Worksheets to Print on a New Sheet
• Printing Multiple Selections
• Printing All or Nothing
• Setting Print Titles
• Printing Multiple Worksheet Ranges
• Centering Your Worksheet
• Printing Comments
• Massive Printouts
• Printing a Worksheet List
• Easily Printing to PDF
• Printing Row Numbers
• Changing Paper Size for a Complete Workbook
• Locking the Print Area

Workbook and File Tips

• Excel Not Responding
• Losing Data in a Shared Workbook
• Calculating Only the Active Workbook
• Creating Default Formatting for Workbooks and Worksheets
• Finding the Parent Folder
• Invalid Names when Opening Workbook
• Full Path to Workbook

Tools Tips

• Understanding Views
• Pulling Access Information into Excel
• Turning Off Track Changes without Unsharing

Macro Tips

• Stopping a Checked Box from being Unchecked
• Item Not Available in Library
• Understanding Variables in VBA Macros
• Converting Phone Numbers
• Deleting Zero Values from a Data Table
• Creating and Naming a Worksheet Using a Macro
• Self-Aware Macros
• Using the Status Bar
• Switching Windows in a Macro
• Getting User Input in a Dialog Box
• Selecting All Visible Worksheets in a Macro
• Determining the Number of Visible Columns
• Filling a Range of Cells with Values
• Selecting a Specific Cell in a Macro
• Transferring Data between Worksheets Using a Macro
• Importing Based on a Partial File Name
• Generating Unique, Sequential Names
• Bypassing the BeforeClose Event
• Detecting Hidden Rows
• Displaying the First Worksheet in a Macro
• Extracting Proper Words
• Generating a Keyword Occurrence List
• Selecting Columns in VBA when Cells are Merged

Order Your ExcelTips Archives Today!

Each download item shown below includes the size of the download file. If you have a slow connection to the Internet, you can save precious time by ordering your archives on CD-ROM, instead of as a download.

The ExcelTips archives include PDF documents. To read these documents, you need to have either Adobe Acrobat or Adobe Reader on your system. Adobe Reader is free to download; click the link to get the latest version.

Archive Year	Dates Covered	Tips	CD	Download
ExcelTips Ribbon 2016 (for Excel 2007, 2010, 2013, and 2016 users)	1 Jan 11 — 31 Dec 11	212 tips	(259 pages) $32.99 $23.09	(3.2 MB) $24.99 $17.49
ExcelTips Ribbon 2017 (for Excel 2007, 2010, 2013, and 2016 users)	1 Jan 17 — 30 Dec 17	208 tips	(276 page) $32.99 $23.09	(3.8 MB) $24.99 $17.49
ExcelTips Ribbon 2018 (for Excel 2007, 2010, 2013, 2016, 2019, and Office 365 users)	6 Jan 18 — 29 Dec 18	249 tips	(321 pages) $32.99 $23.09	(4.0 MB) $24.99 $17.49
ExcelTips Ribbon 2019 (for Excel 2007, 2010, 2013, 2016, 2019, and Office 365 users)	5 Jan 19 — 28 Dec 19	312 tips	(444 pages) $32.99 $23.09	(7.2 MB) $24.99 $17.49
ExcelTips Ribbon 2020 (for Excel 2007, 2010, 2013, 2016, 2019, and Office 365 users)	4 Jan 20 — 26 Dec 20	312 tips	(403 pages) $32.99 $23.09	(7.5 MB) $24.99 $17.49

You can also order any of the ExcelTips archives by calling our order line: 307-200-0450.