Powerful Excel e-Books
Tips.Net provides a variety of ExcelTips e-books. Solve a pesky problem, learn a new skill, or enhance your existing knowledge. Tips.Net e-books provide something for everyone!
- ExcelTips: Serioius Sorting Take control of your data by putting it in the order you want. Powerful sorting techniques help you discover new ways to see your data.
- ExcelTips Premium Twice the tips every week, great graphics, plus huge discounts on ExcelTips archives and e-books. Step up to a Premium subscription!
- ExcelTips Archives Full Excel information at your fingertips! The ExcelTips Archives provide all you need to become an Excel expert. Available on CD-ROMs or convenient downloads.
- Excel Graphics and Charts Dress your Excel data up by adding graphics and charts. Uncover the tools, tips, and guidance you need in this handy volume.
- More e-books>>
Shipping Info
If you order a product that requires shipping, please note that all Tips.Net shipping is done via US Mail. Shipments will be sent either First Class or Media Mail, as appropriate.
We try very hard to ship orders by the next business day after receipt. Most of the time we are successful, but not always.
Our goal is to keep shipping and handling costs as low as possible. The cost will vary, depending on the number of shippable items you order. For example, if you order a single CD item, the cost will be approximately $4.34. Each additional CD item in the same order will add approximately $0.65 to the shipping and handling costs. Thus, two CD items would be $4.99, three would be $5.64, etc.
If you have any questions about shipping or handling charges, please feel free to contact us at 801-607-2035 prior to placing your order.
ExcelTips 2001 Archive
The ExcelTips 2001 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
- Determining Your Serial Number
- Determining Your Version of Excel
- Understanding R1C1 References
- Keeping Help Visible
- Printing Out a Help Topic
- A Ruler in Excel
- Scrolling Up and Down
- Annoying Excel Cuts and Copies
- Controlling Display of Page Breaks
- Finding and Deleting Links
- Appearance of Excel on the Taskbar
- Random Resetting of the Standard Toolbar
- Backing Up Your Customized Toolbars
- Moving and Selecting Sheets With the Keyboard
- Sorting Worksheets
- Splitting Your Spreadsheet Window Into Panes
- Protecting Worksheets
Customizing Tips
- Cycling Through Colors
- Understanding Manual Calculation
- Changing the Shortcut Menu
- Colors and Fonts for Worksheet Tabs
- Controlling the Display of Toolbars
- Displaying a Toolbar
- Specifying the Behavior of the Enter Key
- Controlling How Excel Interprets Percentages
- Controlling the Behavior of the Mouse Wheel
- Turning Off Names
Editing Tips
- Highlighting the Rows of Selected Cells
- Quickly Updating Values
- Copying Cells to Fill a Range
- Displaying a Hidden First Column
- Additional Ways of Displaying a Hidden First Column
- How Many Rows and Columns Have I Selected?
- Copying Values
- Quick AutoFill Variations
- Zooming In On Your Worksheet
- Copying a Cell without Formatting
- Merging Cells
- Controlling Where You Edit Cell Contents
- Easily Entering Dispersed Data
- Turning Off AutoFill for a Workbook
- Sequentially Inputting Information
- Forcing Input to Uppercase
- Displaying Row and Column Labels
- Typing Check Marks into Excel
- Editing the Same Cell in Multiple Sheets
- Inserting Large Numbers of Checkboxes
- Generating Unique Sequential Numbers
- Entering the Current Time
- Canceling an Edit
- Picking a Contiguous Range of Cells
- Picking a Group of Cells
- Limiting Input to a Format
- Easily Changing Links
Formatting Tips
- Changing the Color of a Cell Border
- Changing the Comment Font
- Saving Custom Formats
- Defeating Automatic Date Parsing
- Changing the Font Size in Combo Boxes
- Understanding Underlines
- When is Currency Not Currency?
- Understanding Cell Indenting
- Referencing External Cell Colors
- Adjusting Row Height for Your Text
- Copying Formats to a New Worksheet
- Double-Clicking to Widen Columns Won't Work
- Specifying Superscript Text
- Problems with Custom Views
- Embedding Fonts in Excel
- Displaying Zeros
- Converting Text Case
- Formatting Raw Data
Formula Tips
- Counting Cells with Specific Characters
- Deriving a Secant and Cosecant
- Converting Julian Date Formats
- Adding Ordinal Notation to Dates
- Inserting Tomorrow's Date
- Totaling Across Worksheets
- Retrieving the Last Value in a Column
- Counting Employees in Classes
- Finding the Directory Name
- Getting Rid of Negative Zero Amounts
- Pulling Formulas from a Worksheet
- Displaying Letter Grades
- Segregating Numbers According To Their Sign
- Combining Cell Contents
Functions Tips
- Using the WEEKNUM Function
- Returning the Left-most Characters
- Phantom Counts
- Calculating Fractions of Years
- Calculating Months of Tenure
- Understanding the VLOOKUP Function
- Returning a Weight and a Date
- Using the XIRR Function
- Converting Units
Tools Tips
- AutoFill with Random Numbers
- Understanding Outlining
- Hiding Outline Symbols
- Sorting Dates by Month
- Sorting Dates by Month, Take Two
Files Tips
- Setting a Default File Format
- Creating a Workbook Clone
- Setting Your Default Directory
- Accessing Old Excel Data
- Saving Worksheets in Lotus 1-2-3 Format
- Creating a CSV File
- Correctly Saving Delimited Files
- Handling Leading Zeros in CSV Files
- Appending to a Non-Document Text File
- Protecting Excel Files from Word
- Grabbing the MRU List
- Turning Off the MRU List
Graphics Tips
- Hiding Graphics
- Duplicating Drawing Objects
- Quickly Duplicating Drawing Objects
- Nudging a Graphic
- Changing Line Color in a Drawing Object
- Positioning Graphics Evenly
- Drawing Simple Objects
- Adding a Drop Shadow to a Text Box
- Positioning Graphics Evenly
- Deleting All Graphics
- Changing How Arrows Look
- Specifying an Order for Drawing Objects
- Using a Graphic for a Background
- Exporting a Graphics Group
Charting Tips
- Negatives in Pie Charts
- Moving a Chart's Legend
- Turning the Legend On and Off
- Formatting the Border of a Legend
- Creating a Log/Log Chart
- Deleting a Chart
- Changing Chart Type
- Changing the Axis Scale
- Controlling Chart Gridlines
- Using Dynamic Chart Titles
- Changing the Pattern Used in a Data Series
- Using Graphics to Represent Data Series
- Smoothing Out Data Series
- Unselecting a Chart Item
- Formatting Axis Patterns
- Changing Axis Tick Marks
- Identifying Scatter Plot Points
- Creating Charts in VBA
- Adjusting Your View of 3-D Graphs
- Using the Mouse to Adjust Your View of 3-D Graphs
Header and Footer Tips
- Default Headers and Footers
- Positioning Headers and Footers
- Putting Cell Contents in Footers
- Putting Headers and Footers On Multiple Worksheets
- Adding Page Numbers
- Putting Spreadsheet Names in Headers or Footers
- Full Path Names in Headers or Footers
Printing Tips
- Printing a Range of Pages
- Clearing the Print Area
- Adding the Set Print Area Tool
- Printing a Draft of a Worksheet
- Printing Workbook Properties
- Using Less Paper on Printouts
- Specifying an Order for Page Printing
- Printing a Chart Across Multiple Pages
- Printing without Opening
- Resetting Page Setup
- Disabling the Print Option
- Fitting Your Printout on a Page
- Automatically Printing a Range
- Selecting a Paper Source
Macros Tips
- Saving Information in a Text File
- Determining the Length of a Text File
- Controlling the Printer in a Macro
- Getting Big Macros to Run
- Using a Progress Indicator in Macros
- Using Seek In a Macro
- DOS From Macros
- Making a Cell's Contents Bold within a Macro
- Deleting a File in a Macro
- Swapping Two Numbers
- Assigning Macros to Graphics
- Detecting Types of Sheets in VBA
- Determining the Day of the Month
- Determining If a File Exists
- Determining Differences Between Dates
- Turning Off Screen Updating
- Changing the Default Drive
- Easily Adding Blank Rows
- Determining the Hour of the Day
- Quickly Dumping Array Contents
- Setting Row Height in a Macro
- Running Macros on Hidden Worksheets
- Easily Changing the Default Drive and Directory
- Pausing Macros for User Input
- Conditionally Displaying a Message Box
- Determining the Current Directory
- Expiration Date for Excel Programs
- Setting Column Width in a Macro
- Moving Macros from the Personal Workbook
- Making a Cell's Contents Italics within a Macro
- Removing a Macro from a Shortcut Key
- Self-Aware Macros
- Running a Macro When a Worksheet is Activated
- Waiting for Update Completion
- Adding Leading Zeroes to ZIP Codes
- Develop Macros In Their Own Workbook
- Getting Rid of the "Enable Macros" Notice
- Unhiding Multiple Worksheets
- Controlling Display of Toolbar Buttons
- Counting Colors of Cells
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.
NOTE: Beginning with the ExcelTips 2003 archives, the year's issues of ExcelTips Premium are available only on the CD-ROM, not in the download. ExcelTips Premium is published weekly in PDF form, and the download of 52 of those issues at once is simply too large. If you want back issues of ExcelTips Premium in your archive, make sure you order it on CD-ROM (left column).