ExcelTips Ribbon 2012 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 2012.

ExcelTips Ribbon 2012 Archive (Table of Contents)

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

  • Starting in Safe Mode
  • Excluding a Specific Add-In at Startup
  • Arranging Workbook Windows
  • Quickly Changing Windows
  • Opening Two Workbooks with the Same Name
  • Moving from Sheet to Sheet
  • Turning Headers On and Off
  • Odd Arrow Key Behavior
  • Forcing Manual Calculation For a Workbook
  • Forcing Stubborn Recalculation
  • Where Is that Name?
  • Understanding Relative and Absolute Addressing
  • Relative Worksheet References
  • Relative References to Cells in Other Workbooks
  • Date Last Edited
  • Viewing Workbook Statistics
  • Status Bar Summing No Longer Available
  • Losing Data in a Shared Workbook
  • Ignoring Other Applications
  • Weird Actions for Arrow Keys and Enter
  • Saving Non-Existent Changes
  • Identifying Merged Cells
  • Working with Record Numbers
  • Enlarging the Formula Bar
  • Setting the Width for Row Labels
  • Problem with Missing Context Menu Option
  • Turning Off Names
  • Thoughts and Ideas on Significant Digits in Excel
  • Choosing Direction After Enter On a Workbook Basis
  • Tab Key Won't Move from Cell to Cell in Locked Worksheet
  • Disabling Page Layout View
  • Displaying Page Breaks
  • Pulling Access Information into Excel

Editing Tips

  • Entering Formulas in Excel
  • Entering Info into Multiple Cells
  • Dealing with Long Formulas
  • Viewing Formula Results
  • How Operators are Evaluated
  • Cell Movement After Enter
  • Moving and Selecting Rows
  • Ranges on Multiple Worksheets
  • Turning Off Insert Options
  • Creating Selections
  • Editing Individual Cells
  • Picking a Group of Cells
  • Undoing an Edit
  • Moving Cells Using the Mouse
  • Clearing and Deleting Cells
  • Enhanced Filling
  • AutoFilling from a Custom List
  • Skipping Rows when Filling
  • Quickly Filling a Column
  • Using the Fill Handle from the Keyboard
  • Turning Off AutoFill for a Workbook
  • AutoFill Won't Work as Expected
  • Errors when Copying References to External Cells
  • Activating the Formula Bar with the Keyboard
  • Adjusting Formulas when Pasting
  • Limiting Input to a Format
  • Limiting Number of Characters in a Cell
  • Limiting Entry of Names
  • Quickly Transposing Cells
  • Three-Dimensional Transpositions
  • Automatically Breaking Text
  • Concatenating Ranges of Cells
  • Turning Off Paste Options
  • Modifying Proper Capitalization
  • Deleting Everything Except Formulas
  • Converting Text to Values
  • Checking for an Entry in a Cell
  • Getting Help when Entering Functions
  • Typing Check Marks into Excel
  • Combining Multiple Rows in a Column
  • Disabling Dragging and Dropping
  • Using Slashed Zeroes
  • Using Subtotals and Totals
  • Counting Words
  • Deleting All Names but a Few
  • Pasting without Updating References
  • Symbols Convert to Numbers in Excel
  • Checking for a Value in a Cell
  • Changing Multiple Cells at Once
  • Understanding AutoComplete
  • Combining Columns
  • Creating a Shortcut for Pasting Values
  • Tab Key Jumps a Screen at a Time
  • Ensuring Rows and Columns are Empty
  • Inserting a Radical Symbol
  • Reference Shortcut
  • Using the Same Range Name on Different Worksheets
  • Conditionally Deleting Rows
  • Moving and Copying Cells
  • Changing Months in a Workbook
  • Accepting Only a Single Digit
  • Automatically Numbering Rows
  • Pasting Multiple Paragraphs Into a Single Cell
  • Entered Values are Divided by 100
  • Selecting Formulas
  • Scroll Wheel Doesn't Work when Editing

Find and Replace Tips

  • Finding Text in Text Boxes
  • Using Find and Replace to Pre-Pend Characters
  • Finding and Replacing Error Values
  • Making All Occurrences Bold

Formatting Tips

  • Selecting a Paper Size
  • Setting Row Height
  • Setting Vertical Alignment
  • Setting Cell Width and Height Using the Keyboard
  • Adjusting Cell Margins for More White Space
  • Removing All Formatting
  • Converting from Numbers to Text
  • Formatting Currency
  • Hiding and Unhiding Columns
  • Unhiding a Single Column
  • Unhiding Columns that are Persistently Hidden
  • Hiding and Unhiding Rows
  • Hiding a Huge Number of Rows
  • Hiding Rows Based on Two Values
  • Hiding Individual Cells
  • Setting Orientation of Cell Values
  • Filling a Cell
  • Changing the Percent Symbol
  • Displaying Negative Percentages in Red
  • Accurate Font Sizes
  • Changes in Font Size when Copying
  • Shrinking Cell Contents
  • Changing Cell Colors
  • Changing Cell Patterns
  • Creating 3-D Formatting for a Cell
  • Using Fractional Number Formats
  • Stopping Fractions from Reducing
  • Creating a Center Across Selection Button
  • Merge and Center Not Available
  • Decimal Tab Alignment
  • Rounded Corners on Cells

Conditional Formatting Tips

  • Defining a Single Condition
  • Copying Conditional Formatting
  • Finding Cells that Use Conditional Formatting
  • Conditional Formatting Based on Date Proximity
  • Shading a Cell Until Something is Entered
  • Shading Rows with Conditional Formatting
  • Shading Based on Odds and Evens
  • Conditional Format that Checks for Data Type

Header and Footer Tips

  • Creating Long Page Footers
  • Using a Different Footer on Secondary Pages
  • Selective Headers and Footers
  • Adding Graphics to a Header or Footer
  • Adding Ampersands in Headers and Footers
  • Ampersands in Headers and Footers

Online Tips

  • Editing a Hyperlink
  • Turning Off Hyperlink Activation
  • Drop-Down List of Hyperlinks
  • Opening Sites in a Browser
  • Automatic Text in an E-mail
  • Extracting E-mail Addresses from Hyperlinks

Worksheet Tips

  • Quickly Inserting a New Worksheet
  • Hiding and Unhiding Worksheets
  • Copying a Worksheet
  • Creating a Copy without Formulas
  • Turning Off Worksheet Tabs
  • Unlocking a Worksheet with an Unknown Password
  • Disabling Moving Between Worksheets
  • Switching Headers in a Frozen Row
  • Identifying the Last Cell Changed in a Worksheet
  • Protecting a Worksheet's Format
  • Protecting Worksheets from Deletion
  • Retrieving Worksheet Names
  • Lotus Grouped Worksheets

Worksheet Function Tips

  • Rounding Numbers
  • Cell and Name References in COUNTIF
  • Using the TRUNC Worksheet Function
  • Using the INT Worksheet Function
  • Establishing a FLOOR and CEILING
  • Specifying a Language for the TEXT Function
  • Finding the Date Associated with a Negative Value
  • SUMIF Doesn't Recalc Automatically
  • Counting with Formulas
  • Specifying Proper Case
  • Using the REPT Function
  • Using the EOMONTH Function
  • Calculating Combinations
  • Using the COLUMN Function
  • Counting the Number of Blank Cells
  • Using the IRR Function
  • Random Numbers in a Range
  • Converting to Hexadecimal
  • Strange ATAN Results
  • Finding the Nth Root of a Number
  • Making VLOOKUP Case Sensitive
  • Making VLOOKUP Trigger a Macro
  • Returning a Worksheet Name

Formula Tips

  • Creating an Amortization Schedule
  • Limiting Entries to Numeric Values
  • Dealing with Circular References
  • Copying Named Ranges
  • Summing Based on Part of the Information in a Cell
  • Summing Based on Formatting in Adjacent Cells
  • Summing Digits in a Value
  • Summing Only Visible Values
  • Incrementing Numeric Portions of Serial Numbers
  • Last Non-Zero Value in a Row
  • Getting the Name of the Worksheet Into a Cell
  • Cell Address of a Maximum Value
  • Determining Winners, by Category
  • Searching for a Value Using a Function
  • Counting Wins and Losses
  • Finding Columns of a Certain Width
  • Generating Random Strings of Characters
  • Picking Different Random Numbers from a Range
  • Counting Unique Values with Functions
  • Getting Rid of Everything Except Numbers
  • Rounding Up to the Next Half
  • Condensing Sequential Values to a Single Row
  • Patterns of Numbers with a Formula
  • Extracting a Pattern from within Text
  • Counting Only Money Winners
  • Determining Combinations to Make a Total
  • Returning Zero When a Referenced Cell is Blank
  • Non-adjusting References in Formulas
  • Throwing Out the Lowest Score
  • Looking Backward through a Data Table
  • Returning Item Codes Instead of Item Names
  • Calculating a Geometric Standard Deviation
  • Compiling a List of Students in a Course
  • Extracting First and Last Words
  • Separating Names into Individual Columns
  • Reordering Last Name and First Name
  • Reversing Names In Place

PivotTable Tips

  • Default Formatting for PivotTables
  • Text Truncated in PivotTable
  • Expanding PivotTable Rows to Sheets
  • Weighted Averages in a PivotTable

Sorting and Filtering Tips

  • Understanding Ascending and Descending Sorts
  • Sorting an Entire List
  • Sorting Decimal Values
  • Ignoring Selected Words when Sorting
  • Non-standard Sorting
  • Performing Complex Sorts
  • Toggling AutoFilter
  • Setting Up Custom AutoFiltering
  • Filtering for Comments
  • Counting Filtered Rows
  • Performing Calculations while Filtering
  • Showing Filter Criteria on a Printout
  • Hiding Graphics when Filtering
  • Clearing Only Filtering Settings
  • Putting Addresses on State-Specific Worksheets

Comment Tips

  • Viewing Comments
  • Keyboard Shortcut for Comments
  • Editing Comments
  • Managing Comments
  • Printing Comments
  • Adding a Comment to Multiple Cells
  • Linking Comments to Multiple Cells
  • Counting Comments in a Worksheet
  • Copying Comments to Cells
  • Inserting Workbook Comments Into a Cell

Date and Time Tips

  • How Excel Stores Dates and Times
  • Changing Excel's Starting Date
  • Entering Dates in Excel
  • Quickly Entering Dates and Times
  • Entering Dates without Separators
  • Entering or Importing Times without Colons
  • Rounding Time
  • Displaying a Result as Minutes and Seconds
  • Working with Elapsed Time
  • Calculating Elapsed Time with Excluded Periods
  • Calculating Business Days
  • Calculating Future Workdays
  • Calculating a Date Five Days before the First Business Day
  • End-of-Month Calculations
  • Automatically Converting to GMT
  • Setting a Default Date Format
  • Forcing Dates Forward
  • Automatically Advancing by a Month
  • Every Second Tuesday
  • Calculating an Age On a Given Date
  • Backwards Date Parsing
  • Tombstone Date Math
  • Converting Numeric Values to Times
  • Using Excel for Timing
  • Combining and Formatting Times
  • Counting Dates in a Range
  • Counting Times within a Range

Graphics Tips

  • Selecting Drawing Objects
  • Changing a Shape
  • Changing the Size of a Graphic
  • Cropping Graphics
  • Getting Rid of Fixed Objects
  • Pop-Up Comments for Graphics
  • Adding Text to a Drawing Shape
  • Setting Default Attributes for Lines and Arrows
  • Inserting a Watermark Behind Merged Cells
  • Deleting Graphics when Deleting a Row
  • Placing Textbox Text Into a Worksheet
  • Inserting Video into Worksheets
  • Taking a Picture

Charting Tips

  • Specifying Chart Sizes
  • Formatting the Border of a Legend
  • Adding Text Boxes to Charts
  • Labeling X-Y Scatter Plots
  • Colorizing Charts
  • Controlling the Plotting of Empty Cells
  • Using Chart Titles
  • Adding Data Labels to Your Chart
  • Adjusting Trendlines in a Chart

Printing Tips

  • Setting Up Your Printer
  • Setting Page Margins
  • Setting the Print Area
  • Copying Print Areas when Copying Worksheets
  • Locking the Print Area
  • Printing a Portion of a Worksheet
  • Printing Multiple Worksheet Ranges
  • Printing Multiple Selections
  • Printing Based on Cell Contents
  • Printing All or Nothing
  • Setting Print Titles
  • Centering Your Worksheet
  • Scaling Your Printing
  • Changing Orientations within a Single Printout
  • Massive Printouts
  • Printing Row Numbers
  • Printing a Worksheet List
  • Changing Paper Size for a Complete Workbook
  • Print Quantity is Stuck
  • Using Multiple Print Settings
  • Protecting Print Settings
  • Preparing a Chart Sheet for Printing

Workbook and File Tips

  • Creating Default Formatting for Workbooks and Worksheets
  • Comparing Workbooks
  • Duplicate Workbooks Opening
  • Limiting Who Can Delete Data
  • Opening a Workbook to a Specific Worksheet
  • Open Workbooks Don't Display
  • Calculating Only the Active Workbook
  • Automatically Hiding Personal.xlsm
  • Personal Workbook Fails to Load
  • CSV File Opens with Data in a Single Column
  • Saving in Two Locations
  • Locked File Puzzle
  • Using Your Own File Extensions
  • Loading Unwanted Files at Startup
  • File Formats that Include Field Formats
  • Converting PDF to Excel
  • Don't Update Links to Other Programs
  • Finding the Parent Folder
  • Importing Many Files Into Excel
  • Avoiding Scientific Notation on File Imports
  • Creating Individual Workbooks
  • Invalid Names when Opening Workbook
  • Accessing Old Excel Data

Tools Tips

  • Using Data Validation
  • Setting Data Validation Input Messages
  • Specifying a Data Validation Error Message
  • Stopping Validated Data from being Overwritten
  • Contingent Validation Lists
  • Importing Custom Lists
  • Watching Cell Values
  • Using AutoCorrect
  • Converting Imported Information to Numeric Values
  • Understanding Views
  • Using Stored Views
  • Deleting a View

Macro Tips

  • Understanding Variables in VBA Macros
  • Understanding Subroutines
  • Understanding Functions in Macros
  • Understanding the If ... End If Structure
  • Understanding the Select Case Structure
  • Exiting a For ... Next Loop Early
  • Determining the Length of a String
  • Comparing Strings
  • Pulling Apart Characters in a Long String
  • Using the Status Bar
  • Disabled Macros
  • Retrieving Drive Statistics
  • Extracting Proper Words
  • Documenting Changes in VBA Code
  • Copying Pictures with a Macro
  • Determining If a Number is Odd or Even
  • Getting User Input in a Dialog Box
  • Waiting for Update Completion
  • Selecting a Specific Cell in a Macro
  • Selecting a Cell in the Current Row
  • Selecting a Range of Cells Relative to the Current Cell
  • Finding the Last-Used Cell in a Macro
  • Self-Aware Macros
  • Page Numbers in VBA
  • Getting a File Name
  • Automating Copying Macros
  • Filling a Range of Cells with Values
  • Automatically Loading Add-ins
  • Converting Phone Numbers
  • Item Not Available in Library
  • Switching Windows in a Macro
  • Creating and Naming a Worksheet Using a Macro
  • Transferring Data between Worksheets Using a Macro
  • Generating Unique, Sequential Names
  • Replacing Some Formulas with the Formula Results
  • Selecting Columns in VBA when Cells are Merged
  • Displaying the Selected Cell's Address
  • Displaying the First Worksheet in a Macro
  • Selecting All Visible Worksheets in a Macro
  • Telling which Worksheets are Selected
  • Copying Worksheets in a Macro
  • Naming Tabs for Weeks
  • Sheets for Days
  • Generating Unique Numbers for Worksheets
  • Preparing Data for Import into Access
  • Converting to ASCII Text
  • Putting an X in a Clicked Cell
  • Deleting Unwanted Styles
  • Turning Off Track Changes without Unsharing
  • Forcing a Worksheet to be Protected Again
  • Detecting Hidden Rows
  • Out of Memory Errors when Accessing the VBA Editor
  • Independent Radio Buttons

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.

Archive Year Dates Covered Tips CD Download
ExcelTips Menu 2011
(for Excel 97, 2000, 2002, and 2003 users)
1 Jan 11 — 31 Dec 11 424 tips Buy on CD
(487 pages)
$32.99
Buy Download
(6.2 MB)
$24.99
ExcelTips Ribbon 2011
(for Excel 2007 and 2010 users)
1 Jan 11 — 31 Dec 11 424 tips Buy on CD
(492 pages)
$32.99
Buy Download
(8.5 MB)
$24.99
ExcelTips Menu 2012
(for Excel 97, 2000, 2002, and 2003 users)
7 Jan 12 — 29 Dec 12 416 tips Buy on CD
(455 pages)
$32.99
Buy Download
(5.4 MB)
$24.99
ExcelTips Ribbon 2012
(for Excel 2007 and 2010 users)
7 Jan 12 — 29 Dec 12 415 tips Buy on CD
(482 page)
$32.99
Buy Download
(8.9 MB)
$24.99
ExcelTips Menu 2013
(for Excel 97, 2000, 2002, and 2003 users)
5 Jan 13 — 28 Dec 13 415 tips Buy on CD
(474 pages)
$32.99
Buy Download
(5.5 MB)
$24.99
ExcelTips Ribbon 2013
(for Excel 2007, 2010, and 2013 users)
5 Jan 13 — 28 Dec 13 416 tips Buy on CD
(490 pages)
$32.99
Buy Download
(6.1 MB)
$24.99
ExcelTips Menu 2014
(for Excel 97, 2000, 2002, and 2003 users)
4 Jan 14 — 27 Dec 14 312 tips Buy on CD
(357 pages)
$32.99
Buy Download
(4.4 MB)
$24.99
ExcelTips Ribbon 2014
(for Excel 2007, 2010, and 2013 users)
4 Jan 14 — 27 Dec 14 415 tips Buy on CD
(524 pages)
$32.99
Buy Download
(8.2 MB)
$24.99
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
Buy Download
(3.4 MB)
$24.99
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
Buy Download
(6.1 MB)
$24.99

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

Links and Sharing
  • Ask a Question
  • Make a Comment
  • Free Calendars
  • Share