ExcelTips 2002 Archive

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

Introduction

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

General Tips

• Viewing Formulas versus Results
• Simultaneous Scrolling
• Countering Compressed Columns
• Precision in Excel
• Precision and Number Display
• Limiting Precision
• Thoughts and Ideas on Significant Digits in Excel
• Changing the Size of Spreadsheet Panes
• Making AutoComplete Work for an Entire Column
• Getting Rid of Spreadsheet Panes
• Working With Multiple Workbooks
• Forcing Manual Calculation For a Workbook
• Selecting Tabs in Dialog Boxes
• Controlling Display of the Status Bar
• Controlling Display of the Scroll Bars
• Disabling a Function Key
• Resetting Excel Menus
• Deleting Menu Items
• Getting Rid of the Startup Spreadsheet

Editing Tips

• Inserting the Date and Time
• Selecting a Word
• Using Overtype Mode
• Copying Subtotals
• Fast AutoFill
• Undoing an Edit
• Selecting a Row
• Moving Cells Using the Mouse
• Quickly Deleting Cells
• Quickly Switching Between Spreadsheet Windows
• Ensuring Unique Values in a Column
• Adding Comments
• Pasting Without Updating References
• Activating the Formula Bar with the Keyboard
• Automatically Protecting After Input
• Selecting an Entire Worksheet
• Working In Feet and Inches
• Transposing and Linking
• Using Excel for Timing
• Entering Large Time Values
• Entering Dates Without Separators
• Flipping Data
• How Operators are Evaluated
• Defining a Name
• Shortening ZIP Codes
• Suppressing Zero Values in Pivot Tables
• Retaining Formatting After a Paste Multiply
• Inserting and Copying Rows
• Understanding Names
• Defining a Name
• Maintaining Accuracy of Significant Digits
• Inserting Cells
• Shortcut for Pasting Only Values
• Inserting Symbols
• Understanding Operators
• Selecting a Column
• Finding the End of the Worksheet
• Dividing Values
• Keep Your Headings in View
• Using Named Formulas or Constants
• Uncovering and Removing Links
• Inserting a Row or Column
• Deleting Blank Columns
• Converting From Relative to Absolute
• Deleting Names
• Using the Same Range Name on Different Worksheets

Formatting Tips

• Copying Formatting
• Adding Borders to Cells
• Dealing With the Euro
• Conditional Formatting Based on Date Proximity
• Conditional Formatting
• Changing the Starting Page Number
• Changing the Default Font
• Forcing a Page Break
• Converting Forced Text to Numbers
• Highlighting Cells Containing Specific Text
• Formatting Canadian Postal Codes
• Fitting Your Information
• Using an Exact Number of Digits
• Better Use of Heading Space
• Formatting Currency
• Setting the Standard Column Width
• Changing Column Width
• Altering the Displayed Format of Numbers to the Nearest 100
• Too Many Cell Formats
• Using Custom Number Formats
• Understanding Number Formatting Codes
• Hiding Rows Based on a Cell Value
• Working with Fonts
• Changing Font Color
• Setting Text Attributes
• Centering Across Columns
• Wrapping Your Text
• Creating Styles
• Applying a Style
• Copying Styles
• Making Squares
• Converting From Numbers to Text
• Creating a Center Across Selection Button
• Creating Superscript and Subscript Buttons
• Changing Page Margins
• Superscripts in Custom Formats
• Removing Conditional Formats, but Not the Effects
• Changing an Existing Style
• Deleting a Style

Worksheet Tips

• Copying a Worksheet
• Quickly Copying Worksheets
• Moving a Worksheet
• Moving a Worksheet to Another Workbook
• Renaming Worksheets
• Setting the Number of Default Worksheets
• Displaying Two Worksheets At Once
• Locking Worksheet Names
• Synchronized Workbook and Worksheet Names
• Viewing Two Worksheets at Once
• Increasing Font Size In Worksheet Tabs
• Referencing Worksheet Tabs
• Selecting Combo Boxes in Locked Worksheets
• Protecting Individual Worksheets, by User

Worksheet Function Tips

• Understanding Functions
• Functions Within Functions
• Counting Displayed Cells
• Working with Roman Numerals
• Getting the Name of the Parent Workbook
• Using the SUBTOTAL Function

Formula Tips

• Converting Between Buddhist and Gregorian Calendar Systems
• Excluding Values from Averaging
• Converting UNIX Date/Time Stamps
• Converting Time Notation to Decimal Notation
• Finding Differences Between Lists
• Figuring Out the Low-Score Winner

Header and Footer Tips

• Creating a Header
• Deleting a Header
• Creating a Footer
• Deleting a Footer
• Copying Headers and Footers
• Inserting the Saved Date In a Header or Footer
• Header and Footer Data Codes
• Header and Footer Formatting Codes
• Dynamic Headers and Footers
• Multiple Line Headers and Footers
• Printing a Multi-Line Footer
• Graphics in Headers or Footers
• Putting a Graphic in a Header or Footer

Graphics Tips

• Reading Values from Graphs
• Adding AutoShapes
• Resizing a Picture
• Cropping Pictures
• Adjusting Picture Appearance
• Creating a Watermark
• Reordering the Display of a Data Series
• Positive and Negative Colors in a Chart

Printing Tips

• Selecting a Paper Size
• Changing Page Orientation
• Printing Just the Visible Data
• Printing Multiple Pages On a Piece of Paper
• Printing a Number of Different Pages
• Figuring Out a Page Number
• Printing an Entire Workbook by Default
• Using Multiple Print Settings

File Tips

• Opening a Recently Used Workbook
• Changing the MRU List
• Locked File Puzzle
• Opening Non-Excel Files
• Loading Unwanted Files at Startup
• Opening an HTML Page in Excel
• Special Characters In Hyperlinks
• Turning Off Hyperlink Activation
• Getting Rid of All Hyperlinks

Tools Tips

• Comparing Workbooks
• Spell Checking Your Worksheet
• Goal Seeking
• Sorting a Range of Cells
• Sorting by Columns
• Sorting by Fill Color
• Spell Checking Your Worksheet
• Toggling AutoFilter
• Adding and Using a Combo Box

Macro Tips

• Writing a Macro from Scratch
• Removing All Macros
• Assigning a Macro to a Keyboard Combination
• Generating a List of Macros
• Automating Copying Macros
• Understanding Phantom Macros
• Retrieving Drive Statistics
• Inserting the Current Time with Seconds
• Forcing a Macro to Run When a Worksheet is Recalculated
• Default Worksheet when Opening
• Counting Precedents and Dependents
• Automatically Loading Add-ins
• Sheets for Months
• Naming Tabs for Weeks
• Deriving the Worksheet Name
• Hiding Excel in VBA
• Working While a Macro is Running
• Macros in Template Files
• Creating Worksheets with a Macro
• Understanding the If ... End If Structure
• Understanding the For … Next Structure
• Jumping to Alphabetic Worksheets
• Unhiding or Listing All Objects
• Converting Cells to Proper Case
• Counting Shaded Cells
• Preserving the Undo List
• Stepping Through a Macro with a Worksheet Visible

Order Your ExcelTips Archives Today!

Each download item shown below (right column) 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 (left column).

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 at the right to get the latest version.

Archive	Dates Covered	Tips	Book Pages	CD		Download
ExcelTips 2001	6 Jan 01 through 29 Dec 01	207 tips	218 pages	$29.99		$22.99		(1.47 MB)
ExcelTips 2002	5 Jan 02 through 28 Dec 02	204 tips	222 pages	$29.99		$22.99		(1.59 MB)
ExcelTips 2003	4 Jan 03 through 27 Dec 03	410 tips	471 pages	$29.99		$22.99		(3.95 MB)
ExcelTips 2004	6 Jan 04 through 25 Dec 04	414 tips	428 pages	$29.99		$22.99		(4.17 MB)
ExcelTips 2005	1 Jan 05 through 31 Dec 05	423 tips	518 pages	$29.99		$22.99		(4.7 MB)
ExcelTips 2006	7 Jan 06 through 30 Dec 06	416 tips	493 pages	$29.99		$22.99		(7.6 MB)
ExcelTips 2007	6 Jan 07 through 29 Dec 07	414 tips	504 pages	$29.99		$22.99		(10.5 MB)
ExcelTips 2008	5 Jan 08 through 27 Dec 08	415 tips	514 pages	$29.99		$22.99		(10.6 MB)

You can also order ExcelTips archives by calling our order line: 801-607-2035.