How to Find the Version of Excel with VBA Code
Press Alt + F11 to open the Microsoft Basic for Applications window. Copy and paste the below VBA code into the Module window, and then press the F5 key to run the code. Then a Microsoft Excel dialog box pops up with the version number displaying.
When I was writing we ran into the question “How do I know what version of Excel I am running?”.
For more information, click on About Excel. A dialog box opens, showing the full version number and bit version ( 32-bit or 64-bit ). Click on the Excel tab from the menu on top of your screen.
You can do as follows to find the version of Excel 2013/2016. See screenshot: 2. Then you will find out your Excel version in the About Microsoft Excel dialog box. For Excel 2010, please do as follows.
How do I find what edition of Excel Am I using?
This article discusses how to find what edition of Microsoft Excel you are using. Select the File tab from the Excel ribbon and then select Account > About Excel. The version and bit-level of Excel will be displayed in the top line of the window: Your version and bit-level of Excel will appear under About Microsoft Excel.
Here is what I learned. under Product Information, you’ll find your Excel version name and, in some cases, the full version number. For more information, click on About Excel. A dialog box opens, showing the full version number and bit version (32-bit or 64-bit). Click on the Excel tab from the menu on top of your screen.
Find the version of Excel 2007 . In the Excel Options dialog box, click Resources in left pane, then you can see the Excel version in the about Microsoft Office Excel 2007 section.
Besides the above methods, you can also find Excel version with VBA code. Press Alt + F11 to open the Microsoft Basic for Applications window.
Click on Excel on the Mac Menu Bar and then select About Microsoft Excel. In the About Excel dialog box, all details will be displayed! So, you can either look at the starting screen of the application, the menu ribbon, or the help/about option in Excel to get information like product version, build number, etc.
How do I find the bit version of an Excel file?
For more information, such as the bit-version, choose About Excel. A dialog box opens, showing the full version number and bit version (32-bit or 64-bit). Open any Office application, such as Word and create a new document.
A dialog box opens, showing the full version number and bit version ( 32-bit or 64-bit ). Click on the Excel tab from the menu on top of your screen.
How do I know if Excel 2019 is installed?
The first thing you’ll most likely notice is the fact that Excel 2019 has a solid, green header interface. This is called the ribbon header, where you’ll find all the tools in Excel. If this bar is a solid green color, you’re most likely on the latest version.
How do I Find my Microsoft Excel license number?
2 Click on the Excel tab from the menu on top of your screen. 4 In the new dialog window that opens, you can see the version number as well as the license type.