Loading
Excel.Tips.Net ExcelTips (Menu Interface)

Determining Your Version of Excel

Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Determining Your Version of Excel.

The instructions for some of the tips you see featured in ExcelTips vary depending on the version of Excel you are using. If you are a relative newcomer to Excel, you may not know exactly how to determine which version you are using.

There are a couple of ways you can figure out which version you are using. The first is to watch Excel as you start the program. Depending on the speed of your system, you may notice the version in the splash screen that appears as Excel starts up. (I say that this depends on the speed of your system because I've seen some systems that are so fast, the splash screen is gone before anyone can fully see everything that is on it.)

Once you have started Excel, there is a better way to figure out your version: Choose About Microsoft Excel from the Help menu. Excel displays the About Microsoft Excel dialog box. (See Figure 1.)

Figure 1. The About Microsoft Excel dialog box.

Note that near the top of the dialog box you can see the version number you are using. When you are through reviewing the information, click OK to close the dialog box.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2959) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Determining Your Version of Excel.

Related Tips:

A Picture is Worth Thousands! Your worksheets are not limited to holding numbers and text. You can also add graphics or easily create charts based on your data. Excel Graphics and Charts, available in two versions, helps you make your graphics and charts their absolute best. Check out Excel Graphics and Charts today!

 

Comments for this tip:

R    09 Jan 2014, 05:04
No Allen, I had input my correct e-mailid for subscription. But it failed on submit. Server denied to accept it as a valid format. My input was r.rare.pal.ly+xltps@gmail.com
awyatt    08 Jan 2014, 08:45
R: You must have typed something wrong into your e-mail address. What you put here is a valid e-mail format, and testing shows it to work just fine.

-Allen
Michael (Micky) Avidan    07 Jan 2014, 15:27
Another opetion is to run a single command in VBA.
----------------------------
MsgBox Application.Version
----------------------------
Will return:
8.0 for Exel 97
9.0 for Excel 2000
10.0 for Excel 2002
11.0 for Excel 2003
12.0 for Excel 2007
14.0 for Excel 2010
15.0 for Excel 2010
Michael (Micky) Avidan
“Microsoft® Answers" - Wiki author & Forums Moderator
“Microsoft®” MVP – Excel (2009-2014)
ISRAEL


R    07 Jan 2014, 00:04
Tried to subscribe for xl tips. It rejected my email id format. Ridiculous!
Gerry Mills    12 Dec 2013, 12:17
There is no about Excel in the help (?) on my version of excel. How do I tell what version I am running?
William Lefbom    10 Dec 2013, 16:00
This doesn't work for current EXCEL versions
awyatt    26 Oct 2012, 16:27
Follow the link at the end of the tip -- it takes you to the version for the newer versions.

-Allen
Pia    26 Oct 2012, 15:55
This only works in old versions of excel. Where do I find this information in the newer versions?

Leave your own comment:

*Name:
Email:
  Notify me about new comments ONLY FOR THIS TIP
Notify me about new comments ANYWHERE ON THIS SITE
Hide my email address
*Text:
*What is 3+4? (To prevent automated submissions and spam.)
 
          Commenting Terms
 
 

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us

 

Advertise with Us

Our Privacy Policy

Our Sites

Tips.Net

Beauty and Style

Cars

Cleaning

Cooking

DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2013)

Gardening

Health

Home Improvement

Money and Finances

Organizing

Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2013)

Our Products

Premium Newsletters

Helpful E-books

Newsletter Archives

 

Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2014 Sharon Parq Associates, Inc.