Similar to other software, Excel has numerous options depending on the needs of its users. As time passes, advancement occurs in each version of the applications. Most of the time, people want to know what features they can avail themselves in an application. Talking about Excel, you must want to know about what features and options it has so that you can have an idea whether this version of Excel can fulfill your requirements or not.
So basically, the question is how do you know what version of Excel do you have?
At times, it could be tricky to know what version of Excel you are using. Other than the launching year, you need to know about other features as well. For instance, Excel 2019 has two different versions for Office 365 and others. With the information about the exact version, you will be able to understand bug fixes as well as their new updates.
If you are aware of the different versions you are using, you can easily distinguish features and options among those versions. Let’s have a look at how you can find out what version of Excel do I have:
For Mac Users
Excel 2016, 2019, 2021 (Microsoft 365)
- Click on the Excel option and choose About Excel from the drop down menu.
- Abut Excel will show every detail about the version you are using.
- The version number is displayed inside the dialog box.
For Latest Excel Versions
In the latest Excel versions 2013, 2016, 2019, and Microsoft 365 are included. If you are using one of these versions, you may follow the steps given below to find out all details about the version.
Sometimes, you may get to know about the build number, the installation type, and the version if it is a 32-bit or 64-bit.
- Choose the File menu.
- Scroll down to the Account.
- See on the Right-hand side and choose Product Information. It will display the Office product name as well as Activation status.
- Under the Product Information option, you will see the “About Excel” button, click on it.
- Doing this will open up the About Microsoft dialog box, which will show the full Excel version including your Product ID and copyright information.
Excel 2010
For Excel 2010 users, here are the steps to follow:
- From the top menu, choose the File link.
- Now, choose Help given on the left-hand side menu.
- In the About Microsoft Excel menu on the right side, you will find the version of Excel. For more details about the version, you have to click on the Additional Version and Copyright Information link.
For Excel 2003 – 2007
Well, Excel 2003 is not an advanced version; however, it has several options for its users. The design of the window is mostly similar to the applications made for Windows XP. You will not see the exciting blue header and interface in the latest versions.
Undoubtedly, this version was famous at the time of its launch. However, today no operating system is compatible with this version. Also, it does not support highly important features that Microsoft launches later. It is truly recommended to upgrade your Excel version.
For Excel 2007 and earlier versions, you can follow the steps given below:
- Click on the Office button.
- From the bottom of the window, choose Excel Options.
- Doing this will help you open up the Excel Options dialog box.
- Now, click on the Resources option given on the left sidebar.
- The information about the version you need is given on the right-hand side under the heading Microsoft Office Excel 2007.
Find Out What Excel Version Do I Have with VBA
VBA users would like to know if they could find out details about what Excel version they have installed. Using three lines of coding will surely let you know all information:
Here is the code you can use:
Sub ExcelVersion()
MsgBox Application.Version
End Sub
You just need to copy and paste these three lines of code in the developer window.
Here is the step-by-step guide to follow:
- Choose the Visual Basic option given in the Developer menu section.
- On the left side of the Project Explorer, you will get all the files and folders when the VBA window is opened.
- Under the VBA project heading, ensure that “ThisWorkbook” is checked with the similar name given as your Excel workbook.
- Now, click on the Insert > Module and a new module window will pop up.
- Now is the right time for coding. Paste the above three lines that you have copied in the new module window.
- Click on the Run button to execute the coding. Run button is on the top window’s toolbar.
- A pop-up message box will show the Excel version number.
How do You Find the Exact Version of Excel?
Here is the guideline to follow for those who want to know the exact version number of Excel software.
For Windows Users
- Go to the Excel application and open the Account option.
Remember, if you don’t find the Account option, you need to select File from the bar and then choose the Account or Help option.
- Under the Product Information heading, the Excel version name along with the full version number is provided.
- Click on the About Excel option in case you need to find more information. A dialog box will open up that shows the full version number and the bit version 32-bit or 64-bit.
To Sum Up
Now, you understand how to find what version of Excel do I have. Whatever version you are using, the point is when you have full details about the application you are using, you can deal with its flaws and drawbacks. Other than fulfilling your needs, this software and applications help you polish your skills effectively.
Keep trying and keep exploring!