ExcelTips Ribbon 2015 Archive (Table of Contents)

Summary: ExcelTips is a weekly newsletter that provides tips on how to effectively use Microsoft's best-selling spreadsheet program. 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 ExcelTips (ribbon) newsletter archive for 2015.

ExcelTips Ribbon 2015 Archive (Table of Contents)

ExcelTips Ribbon 2015 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

  • Understanding Relative and Absolute Addressing
  • Picking a Workbook Format
  • Shortcut for Viewing Formulas
  • A Shortcut for Switching Focus
  • Weird Mouse Shortcut
  • Inadvertently Getting Rid of Frozen Panes
  • Dividing the Screen Unevenly between Two Workbooks
  • Fixing a Numeric Keypad Key
  • Grabbing a User's Name from Excel
  • Counting the Times a Worksheet is Used
  • Clearing Large Clipboard Entries
  • Changing Error Checking Rules
  • Turning Off Error Checking
  • Adding Pop-Up Documentation to a Cell
  • Turning Off ScreenTips
  • Speeding Up Large Worksheets
  • Getting Rid of Workbook Links
  • Viewing Two Worksheets at Once
  • Making AutoComplete Work for an Entire Column
  • Viewing Workbook Statistics
  • Turning Headers On and Off
  • Can't Access the Registry
  • Setting the Width for Row Labels
  • Where Is that Name?
  • Forcing Manual Calculation for a Workbook
  • Saving Excel Configuration Settings
  • Getting Rid of Numbered Columns
  • Changing the Ribbon's Size and Look
  • Disabling a Function Key
  • Enlarging the Formula Bar

Editing Tips

  • Entering Numbers in Excel
  • Entering Info into Multiple Cells
  • Canceling an Edit
  • Ranges on Multiple Worksheets
  • Editing the Same Cell in Multiple Sheets
  • How Operators are Evaluated
  • Converting from Relative to Absolute
  • Displaying a Hidden First Row
  • Can't Empty the Clipboard
  • Quickly Updating Values
  • Clearing Everything Except Formulas
  • Deleting Everything Except Formulas
  • Deleting Old Data from a Worksheet
  • Deleting Every X Rows without a Macro
  • Formatting Canadian Postal Codes
  • Unwanted Data Changes
  • Turning Off Automatic Capitalization
  • Creating New Windows
  • Displaying an Input Format in a Cell
  • Can't Enter Years in a Cell
  • Limiting Entry of Prior Dates
  • Ensuring Unique Values in a Column
  • Correcting a Capital Mistake
  • Copying Data without Leaving the Currently Selected Cell
  • Using AutoComplete with Disjointed Lists
  • Fast AutoFill
  • AutoFill Won't Work as Expected
  • Retaining Formatting After a Paste Multiply
  • Dividing Values
  • Easily Dividing Values by 1000
  • Character Limits for Cells
  • Working with Imperial Linear Distances
  • Working in Feet and Inches
  • Updating Links in Copied Files
  • Defining Shortcut Keys for Symbols
  • Finding Unused Names
  • Extracting Numbers within a Range
  • Copying Rows between Worksheets Based on a Text Value
  • Setting a Length Limit on Cells
  • Increasing Undo Levels
  • Highlighting the Rows of Selected Cells
  • Automatically Breaking Text
  • Adjusting Formulas when Pasting
  • Three-Dimensional Transpositions
  • Turning Off Paste Options
  • Concatenating Ranges of Cells
  • Converting Text to Values
  • Quickly Filling a Column
  • Checking for an Entry in a Cell
  • Moving and Selecting Rows
  • Importing a Subset of Records
  • Checking for a Value in a Cell
  • Turning Off Insert Options
  • Typing Check Marks into Excel
  • Disabling Dragging and Dropping
  • Using Subtotals and Totals
  • Contingent Validation Lists

Find and Replace Tips

  • Wildcards in 'Replace With' Text
  • Removing Cells Containing Specific Terms
  • Finding Boolean Values
  • Replacing Only Whole Words in Excel
  • Finding and Replacing with Subscripts
  • Limiting Searching to a Column

Formatting Tips

  • Setting Vertical Alignment in Cells
  • Specifying Superscript Text
  • Changing Fonts in Multiple Workbooks
  • Random Width and Height Changes
  • Shortcut Key for Format Painter
  • Hiding Columns Based on a Cell Value
  • Displaying Latitude and Longitude
  • Exporting Latitude and Longitude
  • Preventing Changes to Formatting and Page Size
  • Adding Diagonal Borders
  • Drawing Borders
  • Partially Blocking Social Security Numbers
  • Adjusting to a Maximum Row Height
  • Changing Width and Height to Inches
  • Adjusting Row Height when Wrapping Text
  • Referencing External Cell Colors
  • Automatic Row Height for Merged Cells with Text Wrap
  • Filling a Cell
  • Adjusting Cell Margins for More White Space
  • Changing Cell Patterns
  • Stopping Fractions from Reducing
  • Hiding Rows Based on Two Values
  • Selecting a Paper Size
  • Changing the Percent Symbol
  • Automatic Row Height for Wrapped Text
  • Notation for Thousands and Millions
  • Getting Rid of Leading Zeros in a Number Format
  • Using a Custom Format to Add Dashes
  • Dates with Periods
  • Handling Negative Numbers in a Complex Custom Format
  • Saving Custom Formats

Conditional Formatting Tips

  • Highlighting Cells Containing Specific Text
  • Changing Shading when a Column Value Changes
  • Shading Based on Odds and Evens
  • Conditionally Formatting for a Pattern
  • Sorting Conditional Formats Properly
  • Protecting Your Conditional Formatting Rules
  • Leaving a Cell Value Unchanged If a Condition Is False

Header and Footer Tips

  • Putting a Different Date in a Header
  • Last Saved Date in a Footer
  • Dynamic Headers and Footers
  • Putting Headers and Footers on Multiple Worksheets
  • Adding Ampersands in Headers and Footers
  • Creating Long Page Footers
  • Adding Graphics to a Header or Footer

Online Tips

  • Pasting a Hyperlink
  • Copying a Hyperlink to Lots of Worksheets
  • Deleting a Hyperlink
  • Removing Hyperlinks without a Macro
  • Removing Hyperlinks without a Macro, Take Two
  • Changing Portions of Many Hyperlinks
  • Hyperlinks to Charts
  • Extracting URLs from Hyperlinks
  • ScreenTip for an Image
  • Tying a Hyperlink to a Specific Cell
  • Specifying a Browser in a Hyperlink
  • Hyperlinks No Longer Work in a Workbook
  • Generating a Web Page
  • Setting Web Fonts
  • Specifying Your Target Monitor

Worksheet Tips

  • Quickly Inserting a New Worksheet
  • Hiding and Unhiding Worksheets
  • Shortcut to Move between Two Worksheets
  • Disabling Moving Between Worksheets
  • Referencing Worksheet Tabs
  • Freezing Top Rows and Bottom Rows
  • Switching Headers in a Frozen Row
  • Quickly Copying Worksheets
  • Testing for an Empty Worksheet
  • Comparing Formulas on Two Worksheets
  • Enabling Editing Erases Worksheet
  • Identifying the Last Cell Changed in a Worksheet
  • Inserting and Deleting Rows in a Protected Worksheet
  • Protecting a Worksheet's Format

Worksheet Function Tips

  • Getting Help when Entering Functions
  • Specifying Proper Case
  • Strange ATAN Results
  • Replacing Dashes with Periods
  • Getting the Name of the Parent Workbook
  • Using a Cell Value as a Worksheet Name in a Formula
  • Returning a Weight and a Date
  • Using the MROUND Worksheet Function
  • Returning Blanks or Asterisks from a Lookup
  • Rounding Numbers
  • Rounding by Powers of 10
  • Using the TRUNC Worksheet Function
  • Using the INT Worksheet Function
  • Specifying a Language for the TEXT Function
  • Cell and Name References in COUNTIF
  • Determining Columns in a Range
  • Using the CONCATENATE Worksheet Function
  • Using the IF Worksheet Function
  • Looking Backward through a Data Table

Formula Tips

  • Averaging the Last Numbers in a Column
  • Calculating Averages by Date
  • Excluding Values from Averaging
  • Calculating the Median Age of a Group of People
  • Moving the House Number to Its Own Cell
  • Using a Numeric Portion of a Cell in a Formula
  • Where Is that Text?
  • Adjusting Test Scores Proportionately
  • Finding the Nth Occurrence of a Character
  • Only Showing the Maximum of Multiple Iterations
  • Stopping a Formula from Updating References
  • Unbreakable Formula References to Worksheets
  • Returning Least-Significant Digits
  • Errors when Subtracting
  • Summing Only Positive Values
  • Getting Rid of Alphabetic Characters
  • Counting Non-Blank Cells
  • Ignoring Case in a Comparison
  • Referencing the Last Six Items in a Formula
  • Counting Consecutive Negative Numbers
  • Ignoring N/A Values in a Sum
  • Combinations for Members in Meetings
  • Determining If a Value is Out of Limits
  • Deriving High and Low Non-Zero Values
  • Calculating the Interval Between Occurrences
  • Counting Cells with Specific Characters
  • Counting Unique Values
  • Retrieving the Last Value in a Column
  • Finding the First Non-Digit in a Text Value
  • Changing Limited Relative References to Absolute
  • Adjusting Formulas for Top-Added Rows
  • Reordering Last Name and First Name
  • Reversing Names in Place
  • Cell Address of a Maximum Value
  • Getting the Name of the Worksheet Into a Cell
  • Copying Named Ranges
  • Limiting Entries to Numeric Values
  • Modified Rounding
  • Figuring Out the Low-Score Winner
  • Determining Winners, by Category
  • Calculating a Sum for a Range of Dates
  • Finding Columns of a Certain Width
  • Dealing with Circular References

PivotTable Tips

  • Using a PivotTable to Count Items
  • Refreshing PivotTable Data
  • Setting Stable Column Widths in a PivotTable
  • Suppressing Zero Values in PivotTables

Sorting and Filtering Tips

  • Sorting Decimal Values
  • Sorting with Graphics
  • Sorting a Range of Cells
  • Performing Complex Sorts
  • Sorting Data on Protected Worksheets
  • Sorting Data Containing Merged Cells
  • Sorting by the Last Digits in Variable Length Data
  • Fixing Odd Sorting Behavior
  • Incomplete and Corrupt Sorting
  • Copying Comments when Filtering
  • Filtering to a Date Range in the Past
  • Filtering for Purchases within a Given Month
  • Finding Rows with Values in Two Columns
  • Column Formatting Based On a Filter

Comment Tips

  • Managing Comments
  • Editing a Comment Close to Its Cell
  • Moving Comment Background Pictures to Cells
  • Finding and Replacing Text in Comments
  • Printing Formatted Comments

Date and Time Tips

  • How Excel Stores Dates and Times
  • Changing Excel's Starting Date
  • Setting a Default Date Format
  • Converting European Dates to US Dates
  • Determining Business Quarters from Dates
  • Monthly Close-Out Dates
  • Determining If a Year is a Leap Year
  • Returning Nothing If Two Values are Empty
  • Entering Dates without Separators
  • Calculating an Age On a Given Date
  • Counting Dates in a Range
  • Calculating Differences in Months using Non-Standard Date Values
  • Automatically Advancing by a Month
  • Using Excel for Timing
  • Dealing with Midnight Ending a Day
  • Entering Negative Times
  • Displaying Negative Times
  • Rounding Time
  • Converting UTC Times to Local Times
  • Converting Time Notation to Decimal Notation
  • Displaying a Result as Minutes and Seconds
  • Combining and Formatting Times

Graphics Tips

  • Nudging a Graphic
  • Resize Graphics Outside of Excel
  • Taking a Picture
  • Using the Camera in VBA
  • Pulling Text from a Cell and Placing It in a Shape
  • Specifying an Order for Drawing Objects
  • Exporting a Graphics Group
  • Adding Text to a Drawing Shape
  • Setting Default Attributes for Lines and Arrows
  • Using Text Boxes
  • Placing Textbox Text Into a Worksheet

Charting Tips

  • Unselecting a Chart Item
  • Selecting Fonts for a Chart
  • Locking Callouts to a Graph Location
  • Negatives in Pie Charts
  • Creating a Log/Log Chart
  • Creating Charts in VBA
  • Formatting Axis Patterns
  • Exporting Black and White Charts
  • Changing Text in Text Boxes on a Chart
  • Using Dynamic Chart Titles
  • Using Graphics to Represent Data Series
  • Creating Venn Diagrams with Excel Data
  • Outside End Data Label for a Column Chart
  • Two-Level Axis Labels
  • Reading Values from Graphs
  • Changing Axis Tick Marks
  • Controlling the Plotting of Empty Cells

Printing Tips

  • Setting the Print Area
  • Adding the Set Print Area Tool
  • Copying Print Areas when Copying Worksheets
  • Printing Just the Visible Data
  • Selecting a Paper Source
  • Resetting Page Setup
  • Printing Workbooks in a Folder
  • Automatically Printing a Range
  • Hiding Errors on Printouts
  • Printing a Draft Watermark
  • Printing a Chart Across Multiple Pages
  • Changing Cell Values while Printing
  • Out of Kilter Borders
  • Rows on a Printout Except On the Last Page
  • Printing Multiple Pages on a Piece of Paper

Workbook and File Tips

  • Seeing All Open Workbook Names
  • Opening a Workbook to a Specific Worksheet
  • Strange Message about Others Making Changes in a Workbook
  • Sudden Increases in Workbook File Size
  • Reducing File Size
  • Reducing File Sizes for Workbooks with PivotTables
  • Remembering Workbook Position and Size
  • Forcing a Workbook to Close after Inactivity
  • Frequent Workbook Recovery Prompts
  • Creating a Workbook Clone
  • Grabbing the MRU List
  • Sorting Files
  • Correctly Saving Delimited Files
  • Getting Input from a Text File
  • Handling Leading Zeros in CSV Files
  • File Formats that Include Field Formats
  • Saving in Two Locations
  • Saving a Workbook with a Preview
  • Opening Personal.xlsb
  • Pulling Filenames into a Worksheet
  • Changing Link References
  • Finding Wayward Links
  • Don't Update Links to Other Programs
  • Saving a Workbook Using Passwords
  • Visually Showing a Protection Status
  • Using Strong Workbook Protection

Tools Tips

  • Setting Spell-Checking Options
  • Spell-checking Uppercase Words
  • Spell-Checking in a Protected Worksheet
  • Backing Up Custom Dictionaries
  • Using AutoCorrect
  • Increasing the Capacity of AutoCorrect
  • Changing Fonts in Data Validation Drop-Down Lists
  • Allowing for Words that Contain Numbers
  • Fixed-Width Settings when Converting Text to Columns
  • Using List Box Controls
  • Understanding Outlining
  • Adding Buttons to Your Worksheet
  • Using Data Forms
  • AutoFilling from a Custom List
  • Importing Custom Lists
  • Watching Cell Values
  • Converting Imported Information to Numeric Values
  • Using Data Validation
  • Setting Data Validation Input Messages
  • Handling Validation for Proper Latitude
  • Single-Use Drop-Down List

Macro Tips

  • Editing Macros
  • Hiding Macros
  • Develop Macros in Their Own Workbook
  • Aborting a Macro and Retaining Control
  • Understanding Subroutines
  • Understanding Functions in Macros
  • Understanding the Select Case Structure
  • Moving Macros from the Personal Workbook
  • Removing All Macros
  • Getting Rid of the "Enable Macros" Notice
  • Running a Macro when a Worksheet is Deactivated
  • Running a Macro when a Workbook is Closed
  • Forcing a Macro to Run when a Worksheet is Recalculated
  • Disabled Macros
  • Making Modal Dialog Boxes Appear in Front of Workbooks
  • Specifying Location for a Message Box
  • Deleting Worksheet Code in a Macro
  • Detecting Types of Sheets in VBA
  • Saving a Workbook in a Macro
  • Running a Macro in a Number of Workbooks
  • Clearing the Undo Stack in a Macro
  • Progression Indicator in a Macro
  • Macro Fails after Filter
  • Limiting Scroll Area
  • Determining How Many Windows are Open
  • Counting Precedents and Dependents
  • Saving Changes when Closing
  • DOS from Macros
  • Setting Program Window Size in a Macro
  • Resizing a Text Box in a Macro
  • Finding Cells Filled with a Particular Color
  • Determining a Worksheet's Number
  • Making Common Functions Available to Others
  • Pulling Apart Cells
  • Default Worksheet when Opening
  • Converting Numbers Into Words
  • Macro Runs Slowly, but Steps Quickly
  • Stepping Through a Macro with a Worksheet Visible
  • Trouble Recording Paste Special Formula
  • Counting Commas in a Selection
  • Working while a Macro is Running
  • Finding Positions of Formatted Characters in a Cell
  • Magnifying Only the Current Cell
  • Generating Unique Numbers for Worksheets
  • Selecting a Range of Cells Relative to the Current Cell
  • Copying Worksheets in a Macro
  • Selecting a Cell in the Current Row
  • Comparing Strings
  • Finding the Last-Used Cell in a Macro
  • Sheets for Days
  • Sheets for Months
  • Getting a File Name

Order Your ExcelTips Archives Today!

Each download item shown below includes the size of the download file. (When you're dealing with hundreds and hundreds of pages per archive volume, files can get large.) 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 archives for 2019, for a limited time (through January 22, 2020) you can download your own copy of the archives 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 Menu 2015
(for Excel 97, 2000, 2002, and 2003 users)
3 Jan 15 — 26 Dec 15 208 tips Buy on CD
(205 pages)
$32.99 $23.09
Buy Download
(3.4 MB)
$24.99 $17.49
ExcelTips Ribbon 2015
(for Excel 2007, 2010, 2013, and 2016 users)
3 Jan 15 — 26 Dec 15 416 tips Buy on CD
(499 pages)
$32.99 $23.09
Buy Download
(6.1 MB)
$24.99 $17.49
ExcelTips Menu 2016
(for Excel 97, 2000, 2002, and 2003 users)
1 Jan 11 — 31 Dec 11 211 tips Buy on CD
(236 pages)
$32.99 $23.09
Buy Download
(3.6 MB)
$24.99 $17.49
ExcelTips Menu 2017
(for Excel 97, 2000, 2002, and 2003 users)
1 Jan 17 — 30 Dec 17 208 tips Buy on CD
(241 pages)
$32.99 $23.09
Buy Download
(3.1 MB)
$24.99 $17.49
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 Menu 2018
(for Excel 97, 2000, 2002, and 2003 users)
6 Jan 18 — 29 Dec 18 208 tips Buy on CD
(250 pages)
$32.99 $23.09
Buy Download
(3.9 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 Menu 2019
(for Excel 97, 2000, 2002, and 2003 users)
5 Jan 19 — 28 Dec 19 208 tips Buy on CD
(249 pages)
$32.99 $23.09
Buy Download
(4.1 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

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