What Version Of Excel Do I Have

broken image


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.

Jan 10, 2017 The About Word (or Excel, PowerPoint, etc.) dialog box displays, listing the current version number and the build number. If you see Version 15.x, you're using Office for Mac 2016. If you see Version 14.x, Office for Mac 2011 is what you're using. Excel comes with the OS (operating system) you already have, if it is Microsoft. If you use Microsoft, it should be on your computer, just search for it in the Start Menu. If you are using a Mac, you will not find 'Microsoft Excel', but a program similar to it.

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, how you determine your version depends on the version of Excel you are using. (That sounds rather circular, doesn't it?)

Take a look at the top of your screen. Assuming you can see the ribbon up there (it has words on it like Home, Insert, Page Layout, etc.), you can take a first pass at determining your version by looking at the left end of the ribbon. If you see a File tab, then you are using Excel 2010, Excel 2013, Excel 2016, Excel 2019, or Excel in Office 365. (More on that it a moment.) If you, instead, see a round Office button at the top-left corner of the screen, then you are using Excel 2007.

Assuming you see a File tab, you can further narrow down your version by clicking that File tab. If you continue to see the ribbon tabs at the top of the screen, you are using Excel 2010. If the ribbon tabs disappear and you instead see (at the upper-left corner of the screen) a round circle containing a left-pointing arrow, then you are using Excel 2013 or a later version.

If you want to get even more detailed information about your version—information that includes the specific build number of your version—then how you find that out varies widely depending on your general version of Excel. (You might need the detailed build information to provide to Microsoft technical support, for instance.)

Excel 2007

What Version Of Excel Do I Have

If you want to determine more detail about your version number, then you should follow these steps if you are using Excel 2007:

  1. Click the Office button then click Excel Options. Excel displays the Excel Options dialog box.
  2. At the left side of the dialog box, click Resources.
  3. Click the About button. Excel displays the About Microsoft Office Excel dialog box. (See Figure 1.)
  4. Figure 1. The About Microsoft Office 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.

Excel 2010

If you want to determine more detail about your version number and you are using Excel 2010, getting to the info is much easier than in Excel 2007. Start by clicking the File tab of the ribbon and then click Help at the left side of the screen. You'll see all the version information appear at the right side of the screen.

Excel 2013, Excel 2016, Excel 2019, and Excel in Office 365

Starting with Excel 2013, Microsoft moved where the version information is located, and it can be a bit tricky to locate. The reason is because these later versions are delivered electronically, via download, instead of from physical media like a CD or DVD.

Click the File tab of the ribbon and then, at the left side of the screen, click Account. (Yes, Account. Go figure!) At the right side of the screen you'll see a large heading that says Office Updates or Office (depending on which version of Excel you are using). Under this heading you can find the version information for your copy of the program. In my version of Excel in Office 365, the version information is listed under the About Excel subheading. (See Figure 2.)

Figure 2. The Product Information section of the Account tab on the File tab of the ribbon.

You can find even more detailed version information if you double-click on the About Excel icon to the left of the About Excel subheading.

Finding Information in a Macro

If you need to know the version number and build number in a macro you are creating, you can use the .Version property (for the version) and the .Build property (for the build number). Both properties should be used with the Application object, in this manner:

In these examples, sVersion will contain the version number and sBuild the build number. The version number will be '12.0' for Excel 2007, '14.0' for Excel 2010, '15.0' for Excel 2013, or '16.0' for Excel 2016 and later versions. (It is unclear if the Version property returns something other than '16.0' for Excel 2019, but it definitely returns '16.0' for Office 365.)

The build number will be a string of numbers interspersed with periods; the string corresponds to what you see if you follow the steps described earlier in this tip. For example, if you follow the instructions for Excel in Office 365, earlier, and you see a version number of '16.0.12130.20232', then when you execute the above code, sVersion would be '16.0' and sBuild would be '12130.20232'.

Sit down and relax while ASAP Utilities does the rest!

Who are our clients?

Our list of clients exceeds 22,000 organizations in more than 140 countries.

Choose from 10 languages

With clients in over 140 countries, ASAP Utilities is available in:
  • Deutsch (German)
  • Español (Spanish)
  • Français (French)
  • Italiano (Italian)
  • Nederlands (Dutch)
  • Português do Brasil (Portuguese (Brazil))
  • Русский (Russian)
  • 中文(简体) (Chinese (Simplified))
  • 日本語 (Japanese)
You can change the language to your preferred language at any time from within the application.

Supported Excel versions

ASAP Utilities 7.8 works with the Windows editions of:
  • Excel 2000
  • Excel 2002/XP
  • Excel 2003
  • Excel 2007
  • Excel 2010 (32- and 64-bit)
  • Excel 2013 (32- and 64-bit)
  • Excel 2016 (32- and 64-bit)
  • Excel 2019 (32- and 64-bit)
  • Excel 365 Desktop (32- and 64-bit)

Pricing & Ordering

Buy your license(s) today. It's only USD 49.00 for a single user license, or save up to 86% with volume discounts.

Upgrading

How to upgrade to the latest version of ASAP Utilities.

Version history

A history of the various updates and improvements throughout the years

User Guide

The ASAP Utilities User Guide is a practical manual that will show you how to get the best out of this excel add-in

Upgrade policy for the free Home and Student edition

Since 2001 it's our policy to require users of the free/unregistered 'Home and Student' edition to upgrade (free) once a year to make sure they are always using latest version and thus reduce support questions to us.

Information about your Excel version

What version of excel do i have 2016

If you want to determine more detail about your version number, then you should follow these steps if you are using Excel 2007:

  1. Click the Office button then click Excel Options. Excel displays the Excel Options dialog box.
  2. At the left side of the dialog box, click Resources.
  3. Click the About button. Excel displays the About Microsoft Office Excel dialog box. (See Figure 1.)
  4. Figure 1. The About Microsoft Office 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.

Excel 2010

If you want to determine more detail about your version number and you are using Excel 2010, getting to the info is much easier than in Excel 2007. Start by clicking the File tab of the ribbon and then click Help at the left side of the screen. You'll see all the version information appear at the right side of the screen.

Excel 2013, Excel 2016, Excel 2019, and Excel in Office 365

Starting with Excel 2013, Microsoft moved where the version information is located, and it can be a bit tricky to locate. The reason is because these later versions are delivered electronically, via download, instead of from physical media like a CD or DVD.

Click the File tab of the ribbon and then, at the left side of the screen, click Account. (Yes, Account. Go figure!) At the right side of the screen you'll see a large heading that says Office Updates or Office (depending on which version of Excel you are using). Under this heading you can find the version information for your copy of the program. In my version of Excel in Office 365, the version information is listed under the About Excel subheading. (See Figure 2.)

Figure 2. The Product Information section of the Account tab on the File tab of the ribbon.

You can find even more detailed version information if you double-click on the About Excel icon to the left of the About Excel subheading.

Finding Information in a Macro

If you need to know the version number and build number in a macro you are creating, you can use the .Version property (for the version) and the .Build property (for the build number). Both properties should be used with the Application object, in this manner:

In these examples, sVersion will contain the version number and sBuild the build number. The version number will be '12.0' for Excel 2007, '14.0' for Excel 2010, '15.0' for Excel 2013, or '16.0' for Excel 2016 and later versions. (It is unclear if the Version property returns something other than '16.0' for Excel 2019, but it definitely returns '16.0' for Office 365.)

The build number will be a string of numbers interspersed with periods; the string corresponds to what you see if you follow the steps described earlier in this tip. For example, if you follow the instructions for Excel in Office 365, earlier, and you see a version number of '16.0.12130.20232', then when you execute the above code, sVersion would be '16.0' and sBuild would be '12130.20232'.

Sit down and relax while ASAP Utilities does the rest!

Who are our clients?

Our list of clients exceeds 22,000 organizations in more than 140 countries.

Choose from 10 languages

With clients in over 140 countries, ASAP Utilities is available in:
  • Deutsch (German)
  • Español (Spanish)
  • Français (French)
  • Italiano (Italian)
  • Nederlands (Dutch)
  • Português do Brasil (Portuguese (Brazil))
  • Русский (Russian)
  • 中文(简体) (Chinese (Simplified))
  • 日本語 (Japanese)
You can change the language to your preferred language at any time from within the application.

Supported Excel versions

ASAP Utilities 7.8 works with the Windows editions of:
  • Excel 2000
  • Excel 2002/XP
  • Excel 2003
  • Excel 2007
  • Excel 2010 (32- and 64-bit)
  • Excel 2013 (32- and 64-bit)
  • Excel 2016 (32- and 64-bit)
  • Excel 2019 (32- and 64-bit)
  • Excel 365 Desktop (32- and 64-bit)

Pricing & Ordering

Buy your license(s) today. It's only USD 49.00 for a single user license, or save up to 86% with volume discounts.

Upgrading

How to upgrade to the latest version of ASAP Utilities.

Version history

A history of the various updates and improvements throughout the years

User Guide

The ASAP Utilities User Guide is a practical manual that will show you how to get the best out of this excel add-in

Upgrade policy for the free Home and Student edition

Since 2001 it's our policy to require users of the free/unregistered 'Home and Student' edition to upgrade (free) once a year to make sure they are always using latest version and thus reduce support questions to us.

Information about your Excel version

In Excel menu go to the 'Help' menu and then click on 'About Microsoft Excel'. (If you do not see this option in the menu you are probably using Excel 2007 or 2010.)
About Microsoft Excel'>

What Version Of Excel Do I Have On This Pc


When you click on 'About Microsoft Excel' you will see some information on your Excel version with at the top the version number.
In this example the version is Excel 2003:

What Version Of Excel Do I Have Installed


In this example the version is Excel 2002 with service pack (SP) 3 installed:
In this example the version is Excel 2000 with service release (SR) 1 installed:

Excel 2007/2010

If the Excel menu looks similar like the following you are using Excel 2007 or 2010. The menu is now called 'ribbon' by Microsoft.

What Version Of Excel Do I Have

To find the version information you need to:
Click on the Office-logo or 'File' at the top-left, then click on the 'Excel options' button, then choose 'Resources' in the left menu and then click on the 'About' button.





broken image