The Spreadsheet Page: Site Map
This document lists all of the content available at this site.
Downloads
-
General Files
- An Animated Hypocycloid Chart
- Analog Clock Chart
- Animated Color Scales
- Array Formula Calendar
- Climate Data Workbook
- Custom Number Formats
- Dice Roller
- Display Disk Drive Information
- Employee Time Sheet
- Excel 2007 Function List
- Excel Doodle Pad
- Functions To Quantify Color Contrast
- Gantt Chart Demo
- Generate A Word Frequency List
- Generate Meeting Bingo Cards
- Guitar Scales And Modes
- Hangman Game
- Keno For Excel
- King James Bible
- Mail Merge Demo
- MP3 File Lister
- Slide Show Demo
- Smiley Chart
- The Bible, In Excel
- Tony Gwynn's Hit Database
- Word Clock
- Yearly Calendar - With Holidays
- Yearly Calendar Workbook
-
Developer Files
- A Class Module to Manipulate a Chart SERIES
- A Color Picker Dialog Box
- AcitveX Control Demo
- An Animated Hypocycloid Chart
- Analog Clock Chart
- Clickable ImageMap Demo
- Climate Data Workbook
- Dice Roller
- Display Charts In A UserForm
- Display Disk Drive Information
- Displaying Help Topics
- Functions To Quantify Color Contrast
- Generate A Word Frequency List
- GetOption Function
- Light Box Demo
- Mail Merge Demo
- Menu Maker
- MP3 File Lister
- Multiple UserForm Buttons With One Procedure
- Permutation Demo
- Progress Indicator Demo
- Range Selection Demo
- Slide Show Demo
- Soundex Demo
- Toolbar Calculator
- Unique Items In A ListBox
- UserForm Hyperlink Demo
-
Add-Ins
Enhanced Data Form
Excel Blog Headlines
Excel Experts E-Letter
-
All
- Issue No. 01 (March 16, 1999)
- Issue No. 02 (April 1, 1999)
- Issue No. 03 (April 15, 1999)
- Issue No. 04 (April 30, 1999)
- Issue No. 05 (May 15, 1999)
- Issue No. 06 (June 1, 1999)
- Issue No. 07 (June 15, 1999)
- Issue No. 08 (July 1, 1999)
- Issue No. 09 (July 15, 1999)
- Issue No. 10 (August 1, 1999)
- Issue No. 11 (September 15, 1999)
- Issue No. 12 (October 1, 1999)
- Issue No. 13 (October 15, 1999)
- Issue No. 14 (November 1, 1999)
- Issue No. 15 (December 22, 1999)
- Issue No. 16 (January 31, 2000)
- Issue No. 17 (March 1, 2000)
- Issue No. 18 (April 1, 2000)
- Issue No. 19 (June 1, 2000)
- Issue No. 20 (July 8, 2001)
Excel Oddities
-
General Weirdness
- A Range Name Is Really A Named Formula
- A Sheet Named History
- An Unusual Excel 2007 Help Topic
- BAHTTEXT?
- Click What Button?
- Copying And Pasting A Multiple Selection
- Data Entry Quirks
- Excel As A Drawing Tool?
- Excel Easter Eggs
- Excel Gradually Deletes Multiple Extraneous Plus Signs
- Hijri Dates
- How Big Is A Worksheet?
- How To Screw Up Your AutoFormat Dialog Box
- Moving Data Validation Messages
- Obscure Shortcut Keys And Mouse Clicks
- Options, Options, And More Options
- Sorting Oddity/Bug
- The 256-Column Limitation
- The Camera Tool
- The DATEDIF Function
- The Intentional Date Bug
- Two Types Of Security Warnings In Excel 2007
- What Is Truth?
- Who Last Opened That File?
-
VBA Weirdness
- A Dangerous SpecialCells Bug
- A User-Define Function Can't Change The Worksheet. Oh Yeah?
- Gaps In The Excel Object Model
- Makes You Want To Say, "Hmmmmmm...."
- Something Gets Forced
- The Elusive Formula1 Property For Conditional Formatting
- What Is Truth?
- When A Sheet Turns Into A Button
- Worse Than A Fatal Error?
- XLM Rears Its Ugly Head - -And Crashes Excel
Excel Resources
Excel Tips
-
General
- Change The Color Of Worksheet Tabs
- Changing The Number Of Sheets In A New Workbook
- Clearing The Text To Columns Parameters
- Close All Workbooks Quickly
- CommandBar Calculator
- Create A Drop-Down List Of Possible Input Values
- Creating A Database Table From A Summary Table
- Excel 2007 Upgrade FAQ: Charts And Graphics
- Excel 2007 Upgrade FAQ: Formatting And Printing
- Excel 2007 Upgrade FAQ: General
- Excel 2007 Upgrade FAQ: User Interface
- Extended Date Functions
- Getting A List Of File Names
- Getting A List Of Files Names - Another Method
- Importing A Text File Into A Worksheet
- Making A Worksheet Very Hidden
- Making An Exact Copy Of A Range Of Formulas
- Making An Exact Copy Of A Range Of Formulas, Take 2
- Navigating Excel's Sheets
- Old-Style Menus In Excel 2007
- Override Excel's Text Import Wizard
- Protecting Cells, Sheets, Workbooks, And Files
- Resize Excel's Sheet Tabs
- Restrict Cursor Movement To Unprotected Cells
- Sharing Autocorrect Shortcuts
- Solving Common Setup Problems
- Spreadsheet Protection FAQ
- Unlinking A Pivot Table From Its Source Data
- Using A Workspace File
- Using Custom Number Formats
-
Formatting
- Alternate Row Shading Using Conditional Formatting
- Change The Formatting Of Your Subtotal Rows
- Changing The Default Cell Comment Formatting
- Comparing Two Lists With Conditional Formatting
- Display Text In Multiple Lines
- Duplicate Repeated Entries In A List
- Excel 2007 Upgrade FAQ: Formatting And Printing
- Fix Incorrect Decimal Places During Data Entry
- Quantifying Color Choices
- Removing Or Avoiding Automatic Hyperlinks
- Text Effects In Text Boxes
- Unlinking A Pivot Table From Its Source Data
- Using Conditional Formatting
- Working With Fractions
-
Formulas
- A Formula To Calculate A Ratio
- Alternatives To Nested IF Functions
- Automatic List Numbering
- Avoid Error Displays In Formulas
- Calculate The Day Of The Year And Days Remaining
- Calculate The Number Of Days In A Month
- Calculating A Conditional Average
- Calculating Easter
- Cell Counting Techniques
- Change Cell Values Using Paste Special
- Chart Trendline Formulas
- Compare Ranges By Using An Array Formula
- Comparing Two Lists With Conditional Formatting
- Converting Non-numbers To Actual Values
- Converting Unix Timestamps
- Count Autofiltered Rows
- Counting Distinct Entries In A Range
- Creating A "Megaformula"
- Creating A List Of Formulas
- Dealing With Negative Time Values
- Delete All Input Cells, But Keep The Formulas
- Display Text And A Value In One Cell
- Displaying Autofilter Criteria
- Force A Global Recalculation
- Formulas To Perform Day Of Month Calculations
- Hiding Your Formulas
- Identify Formulas By Using Conditional Formatting
- Is A Particular Word Contained In A Text String?
- Locate Phantom Links In A Workbook
- Making An Exact Copy Of A Range Of Formulas
- Making An Exact Copy Of A Range Of Formulas, Take 2
- Naming Techniques
- Perform Two-Way Table Lookups
- Referencing A Sheet Indirectly
- Round Values To The Nearest Fraction
- Rounding To "n" Significant Digits
- Sum The Largest Values In A Range
- Summing And Counting Using Multiple Criteria
- Summing Times That Exceed 24 Hours
- Transforming Data With Formulas
- Using Data Validation To Check For Repeated Values
- Working With Pre-1900 Dates
-
Charts & Graphics
- A Class Module To Manipulate A Chart Series
- A Quick And Dirty Slideshow Macro
- Animated Hypocycloid Charts
- Chart Trendline Formulas
- Creating A Clickable Image Map
- Creating A Linked Picture Of A Range
- Creating A Non-Graphic Chart Directly In A Range
- Creating A Splash Screen For An Excel Workbook
- Creating A Thermometer Style Chart
- Creating A Transparent Chart Series
- Creating Combination Charts
- Display Multiple Charts On A Single Chart Sheet
- Displaying A value in an AutoShape
- Excel 2007 Upgrade FAQ: Charts And Graphics
- Format Cells To Display In Thousands
- Handle Missing Data In A Line Chart
- Interactive Chart With No Macros
- Layouts For Column Charts
- Pasting An Image To A UserForm Control
- Removing Lines From A Surface Chart
- Rotating Text With An AutoShape
- Saving A Chart As A GIF FIle
- Saving A Range As A Graphic File
- Unlink A Chart Series From Its Data Range
- Update Charts Automatically When You Enter New Data
-
Printing
-
General VBA
- A Class Module To Manipulate A Chart Series
- A Macro To Count Word Frequencies
- A Quick And Dirty Slideshow Macro
- Animated Hypocycloid Charts
- Automatically Resetting The Last Cell
- Clearing The Advanced Filter Dialog Box
- Clearing The Text To Columns Parameters
- Controlling User Scrolling
- Creating A Clickable Image Map
- Creating A List Of Formulas
- Creating A Splash Screen For An Excel Workbook
- Creating A Usage Log
- Creating A Worksheet Map
- Deleting All Empty Rows
- Determining If Access To The VB Project Is Allowed
- Determining The Number Of Printed Pages
- Developer FAQ - Add-Ins
- Developer FAQ - Functions
- Developer FAQ - General Questions
- Developer FAQ - Objects, Properties, And Methods
- Developer FAQ - Subroutines
- Developer FAQ - Visual Basic Editor
- Displaying Help
- Dual Monitors And UserForms
- Ensuring That Data Validation Is Not Deleted
- Excel 2007 Upgrade FAQ: Macros
- Generating Permutations
- Handling The Workbook Beforeclose Event
- Is A Particular Word Contained In A Text String?
- Looping Through A Range Efficiently
- Mail Merge - Without Word
- Making An Exact Copy Of A Range Of Formulas
- Maximize Excel Across All Monitors
- Pausing A Macro To Get A User-selected Range
- Playing MP3 Files From Excel
- Playing Sound From Excel
- Referring To Ranges In Your VBA Code
- Removing Lines From A Surface Chart
- Restrict Cursor Movement To Unprotected Cells
- Saving A Range As A Graphic File
- Selecting All Unlocked Cells
- Selecting The Maximum Value In A Range
- Sending Personalized Email From Excel
- Sharing Autocorrect Shortcuts
- Spreadsheet Protection FAQ
- Synchronizing Sheets In A Workbook
- The Value, Formula, and Text Properties
- Understanding Object Parents
- Understanding The IsDate Function
- Using "Strong Arm" Tactics In Excel
- Using Auto List Members In The VB Editor
- Using Controls On Worksheets
- Using Object Variables
- VBA Debugging Tips
- Working With Names In VBA
- Working With Variable-Size Ranges
-
CommandBars & Menus
-
UserForms
- Adding A Hyperlink To A Userform
- Creating A Color Picker Dialog Box
- Creating A Userform Programmatically
- Developer FAQ - UserForms
- Disabling A Userform's Close Button
- Displaying A Chart In A Userform
- Displaying A Menu Of Worksheets To Print
- Displaying A Progress Indicator
- Displaying Help
- Dual Monitors And UserForms
- Filling A Listbox With Unique Items
- General Userform Tips
- Handle Multiple Userform Buttons With One Subroutine
- Importing And Exporting Userforms
- Pasting An Image To A UserForm Control
- Selecting A Directory
- Using Controls On Worksheets
-
VBA Functions
- A Custom Function For Relative Sheet References
- A VBA Function To Get A Value From A Closed File
- Determining If A Range Is Contained In A Range
- Determining If A Worksheet Or Workbook Has Code
- Determining The Data Type Of A Cell
- Determining The Drive Type
- Determining The Last Non-empty Cell In A Column Or Row
- Determining The User's Video Resolution
- Determining When A File Was Created
- Developer FAQ - Functions
- Extended Date Functions
- Extracting An Email Address From Text
- Getting A List Of File Names Using VBA
- Getting A List Of Installed Fonts
- Identifying The Newest File In A Directory
- Identifying Unique Values In An Array Or Range
- Looping Through Ranges Efficiently In Custom Worksheet Functions
- Multifunctional Functions
- Playing A Sound Based On A Cell's Value
- Quantifying Color Choices
- Removing Or Avoiding Automatic Hyperlinks
- Retrieving The Computer Name Or Logged-in User Name
- Searching Using Soundex Codes
- Some Useful VBA Functions
- The Versatile Split Function
- Undoing A VBA Subroutine
- User-Defined Function Argument Descriptions In Excel 2010
- Using The GetSetting & SaveSetting Functions
John's Books
-
Excel 2013
-
Excel 2010
-
Excel 2007
-
Excel 2003
-
Older Excel
- Excel 2000 Bible
- Excel 2000 Bible, Gold Edition
- Excel 2000 For Windows For Dummies Quick Reference
- Excel 2000 Power Programming With VBA
- Excel 2000 Programming For Dummies
- Excel 2002 Bible
- Excel 2002 for Dummies Quick Reference
- Excel 2002 Formulas
- Excel 2002 Power Programming With VBA
- Excel 5 For Windows Power Programming Techniques
- Excel 97 Bible
- Excel 97 For Windows For Dummies Quick Reference
- Excel 97 Programming For Windows For Dummies
- Excel Charts
- Excel For Dummies Quick Reference
- Excel For Dummies Quick Reference, 2nd Edition
- Excel for Windows 95 Bible
- Excel For Windows 95 For Dummies Quick Reference
- Excel for Windows 95 Power Programming With VBA
- Excel Programming For Windows 95 For Dummies
- Microsoft Excel 2000 Formulas
- Microsoft Office 2000 9-in-1 For Dummies Desk Reference
- PC World Excel 4 for Windows Handbook
- PC World Excel 5 for Windows Handbook
-
Non-Excel
- 1-2-3 97 For Dummies Quick Reference
- 1-2-3 97 For Windows For Dummies
- 1-2-3 For Dummies Quick Reference
- 1-2-3 For Windows 5 For Dummies Quick Reference
- 1-2-3 For Windows For Dummies, 2nd Edition
- Developing Applications With Quattro Pro for Windows
- Lotus 1-2-3 Millenium Edition For Dummies
- PC World 1-2-3 for Windows Complete Handbook
- Quattro Pro 6 For Windows For Dummies
- Quattro Pro For DOS For Dummies
- VBScript For Dummies
PUP Mac
PUP v6
PUP v7
-
All
- PUP v7 Documentation
- PUP v7 FAQ
- PUP v7 Features
- PUP v7 Home
- PUP v7 Home MSO
- PUP v7 Other Features
- PUP v7 Purchase
- PUP v7 Removed Features
- PUP v7 Source Code License
- PUP v7 Technical Support
- Pup v7 Trial
- PUP v7 Updates
- PUP v7 User License
- PUP v7 Utilities
- PUP v7 VBA Source Code
- PUP v7 Worksheet Functions
Site Information
Spreadsheet Jokes
-
General
- 256 Columns
- Another View Of Charting
- Are You A Spreadsheet Junkie?
- Cannibal Joke
- Cheney's OK
- Ellen Feiss Uses Excel
- Excel And Football
- Excel Is Also A Spreadsheet?
- Excel Pay-Per-Use
- Excel's Hidden Dialog Box
- Famous Cells And Ranges
- Genie In A Lamp
- If Excel Were A Car
- Lotus Cartoon
- Microsoft Banner Ads
- Pilot Joke
- Regretful Tattoo
- Rude Warning Mode
- Scientists Tell Us
- Shakespeare's Favorite Formula
- Spreadsheet Anagrams
- Spreadsheet Consultant
- Spreadsheet Glossary
- Spreadsheet Poems
- Spreadsheet Riddles
- Spreadsheet Taglines
- Test Your Knowledge Of Excel Pivot Tables
- The Aspiring Writer
- The Best Spreadsheets
- The Wife Vs The Mistress
- Top-10 Signs That You Purchased A Bad Spreadsheet
- VBA Humor
Spreadsheet Page Blog
-
What's New?
- A Function To Extract Email Addresses Posted
- Analyzing Free Money With A Pivot Table
- Buzzword Bingo Card Generator Posted
- Calendar With Holidays Posted
- Color Contrast Functions Posted
- Color Scales Conditional Formatting
- Copying A Range As A Graphic
- Data Entry Oddity Posted
- Disk Drive Functions Posted
- Displaying An Annual Calendar
- Easter Formula
- Enhanced Data Form Date Problem Fixed
- Excel 2007 Security Oddity Posted
- Excel 2007 Upgraders FAQ
- Excel 2010 VBA Enhancements
- Extraneous Plus Sign Removal
- Fixing Excel's Dual Monitor Problem
- ForceFullCalculation Oddity Posted
- Formula To Convert Unix Timestamps
- Improving A Function
- IsDate Tip Posted
- Maximizing Excel On Your Virtual Screen
- Missing File Posted
- MP3 File Lister Posted
- New Feature: Excel Blog Headlines
- New Tip Posted
- New Tip: Listing File Names In A Range
- New Tip: Searching For Words
- New Tip: Understanding Three Properties
- New Version Of Bible Is Available
- Nth *Day Of The Month Tip Posted
- Posted: Light Box Demo
- Posted: Old-Style Menus In Excel 2007
- Posted: Unlinking A Pivot Table
- PUP v7 Currency Conversion Fixed!
- Simple Ribbon Example Posted
- Slide Show Demo Posted
- Sorting Oddity Posted
- Sub Subscripts
- The Bible Is Here
- Tip Posted: Resetting The Text To Column Delimiters
- Using Notepad To Copy Formulas
- Using The Enter Key In The Enhanced Data Form
- Word Clock Posted
- Word Frequency Generator Posted
- Workbook Taskbar Add-In Posted
-
Books
- A Book In A Blog Post
- Adjusted For Inflation
- Back To Work
- Bad Book Reviews
- DataPig's Book Is #1 At Amazon
- Excel 2007 Book Excerpts Are Available
- Excel 2007 Books For Sale
- Excel 2010 Book List Updated
- Excel Books For Kindle
- Excel Cat
- How Many Books?
- I Think It's Finished
- Kindle Book Pricing And Document Titles
- Mini Books
- Missing File Posted
- More Translated Books
- My First Kindle Book
- New Advertising Campaign?
- Poor Guy
- That Chart Looks Familiar
- The Book Winners
- Two New Translations
- Updated Book List
-
PUP
- Announcing: PUP/Mac
- Another PUP Sale
- Attention 64-Bit Excel 2010 Users
- Cleaning Up Data
- Do You Hate Mailing Stuff?
- Favorite PUP Features?
- Fixing Excel's Dual Monitor Problem
- Free PUP Source Code
- Free Upgrades?
- Get The PUP Functions
- PUP Blowout Sale On Tuesday
- PUP Compatibility With Excel 2013
- PUP Customer Names
- PUP Sale Coming Up - Two Hours Only
- PUP Sale Phase II
- PUP Sale Phase II: Details
- PUP Sale Was Successful
- PUP v7 Currency Conversion Fixed!
- PUP v7.1 Is Available
- PUP v7.1 Is Coming
- PUP v7.1 Revisited
- PUP v7.2 is Available
- Why PUP Is Modular
-
Enhanced Data Form
-
General
- 29 Years Of Spreadsheets
- 30 Years Of 1-2-3
- 35 Years Of Microsoft
- 3D Charts
- 44 Excel Blogs
- A Bingo Weekend
- A Break From Excel
- A Cheap Version Of Office 2007
- A Crush On Excel
- A Functional IMAGINARY Tale
- A Google-O-Meter
- A Very Polite Add-In
- AC/DC Video In Excel
- Accelerating Excel?
- Ad-Supported Office?
- Adventures In Book Marketing
- Advice From WikiHow
- An Ad Campaign About Nothing?
- Annoying Date Entry Behavior
- Annoying Window Behavior
- Another Excel Artist
- Another Excel Blog
- Arranging Your Data
- Attention Excel 2003 Users
- Automatic TRIM Patented
- Bad Charts On Wikipedia
- Barbecue Worksheet
- Blogs As Range References
- Calculating In The Pre-Excel Days
- Celebrities Use A Spreadsheet
- Chart Changes Chronicled
- Chess Game Viewer
- Climber Brings Excel Sign
- Cloud Stats
- Colorful UserForm
- Contest: Show Us Your Spreadsheets Challenge
- Creative Charts
- Dart Chart Art
- Data Query Tip
- Day 40,000
- Detect And Repair
- Dynamic Range Names?
- Elevens
- Entering Times
- Equation Editor
- Excel 15
- Excel 15 Features
- Excel 2007 Book Excerpts Are Available
- Excel 2007 Help Updated
- Excel 2007 Is Confused
- Excel 2007 VBA Challenge
- Excel 2010 vs 2013 Speed Benchmark
- Excel 2013 Charting Notes
- Excel 2013: Finalized
- Excel 25th Anniversary Article
- Excel 4.0 First Look
- Excel And AV Software
- Excel And Scotch
- Excel Champ
- Excel Drawing
- Excel Function Names
- Excel Guru
- Excel Hero
- Excel In A Browser
- Excel Version Poll
- Excel's VBA Undo Problem
- Excel-Related Problem At Barclays
- Exploring Theme Colors
- Follow On Twitter
- Free Stuff From Deb
- Function Dictionary Updated
- Google Plus
- Google Suggestions
- Happy Spreadsheet Day
- Hiding & Unhiding With Shortcut Keys
- How Fast Is Your System?
- How To Be Employable
- How To Pronounce It
- Hyperlink Misinformation
- I Don't Like This
- I Made A Simple Task Pane App
- I Understand
- Little Pie Charts
- Lots Of Toolbars
- Make Your Office Button Flash
- Making A Living From Excel
- Microsoft Has A Download Store
- Microsoft Office Is Obsolete?
- Microsoft Office Labs
- Microsoft Patenting Sparklines?
- Microsoft Retires Two Excel RSS Feeds
- Misinformation From TechRepublic
- More On Office 2007 Colors
- More Ribbon-Based Apps
- Music Theory And Excel
- Musical Resignation Letter
- MVP-dom Continues
- My Interview
- New Excel Blogs
- New Feature Coming: Chart Doctor
- New Shortcut Key Discovered
- New Units For the CONVERT Function
- No Ads In Office 14 Client Aps
- No Excel 13?
- No Google Stock Info
- No Office 14 In 2009
- No Wonder People Hate Microsoft
- Office 14
- Office 14 Screen Shots
- Office 2010 Beta Is Now Available
- Office 2010 Leaked
- Office 2010 News
- Office 2013 RIBBON TABS
- Office 365 Preview
- Office Clip Art
- Office Offline
- Official Office 2010 Blog Launched
- Old Dog Learns New Trick
- Old Spreadsheet Ads
- Olympics Job For Excel User
- On This Day
- One Less Excel Blog
- Problems With Euro Currency Tools Add-In
- Progress Bars: The Movie
- Public Data Explorer
- Questions For Me?
- Recycling Calendars
- Show Us Your Spreadsheets Contest Results
- Slave Wages
- Small Basic
- Spreadsheet Cartoon
- Spreadsheet Diva
- Spreadsheet In A Phone
- Spreadsheets Are No Good?
- Still An MVP
- Ten Years Ago
- The End Of PC Magazine
- The Great Excel Spreadsheet Saga
- The Making Of The Office 2007 UI
- The Research Behind Flash Fill
- Today Is Spreadsheet Day
- Too Easy To Lose Your Macros
- Try This DatePicker Task Pane App
- Twelves
- U.S. Tax Forms In Excel
- VBA Coding Contest
- VBA Macro Person
- VBA Speed Results
- Web Sites That Suck
- What Excel Users Buy
- What's New In Excel 2010?
- What's Up With Don Reisinger?
- When A Tip Is Not A Tip
- Windows 7 Name Announced
- World Excel Champ
- Your Most Recent Excel Task?
-
Fan Mail
-
Site News
The Spreadsheet Page
Welcome to The Spreadsheet Page for Microsoft Excel.
Blog
For the latest news, check here:
Products
I sell a few Excel add-in products. Go here to buy one:
Random Book
Here's one of my recent books, selected randomly just for you:
A guide to VBA programming for Excel 2007 | Other Excel 2007 books | Amazon link: Excel 2007 Power Programming with VBA
Surprise Me
Change of Address
If you are using a coupon from one of my older books to get a
discounted copy of PUP, please use this new address:
J-Walk & Associates
P.O. Box 68797
Tucson, AZ 85737
Visit me on G+