ExcelTips Ribbon 2016 Archive (Table of Contents)

Summary: ExcelTips is a weekly newsletter that provides tips on how to best use Microsoft's word processing software. At the beginning of every year we put together an archive of all the tips published the previous year. Here is the complete table of contents for the archive for the ExcelTips (ribbon) newsletter for the year 2016.

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:


  • 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.

Get Adobe Acrobat ReaderThe 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.

To celebrate the release of the ExcelTips archive for 2020, for a limited time (through January 20, 2021) you can download your own copy of the archive for any of the following years at 30% off the regular price. Get your discount; place your order today!

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 Buy on CD
(259 pages)
$32.99 $23.09
Buy Download
(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 Buy on CD
(276 page)
$32.99 $23.09
Buy Download
(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 Buy on CD
(321 pages)
$32.99 $23.09
Buy Download
(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 Buy on CD
(444 pages)
$32.99 $23.09
Buy Download
(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 Buy on CD
(403 pages)
$32.99 $23.09
Buy Download
(7.5 MB)
$24.99 $17.49

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