- #Microsoft excel versions how to#
- #Microsoft excel versions full version#
- #Microsoft excel versions full#
- #Microsoft excel versions code#
- #Microsoft excel versions series#
The second method, on the other hand, can be used on any Excel version, on any machine.Īlthough it involves the use of VBA script, it’s quite simple and quick, and even someone who is not familiar with VBA can easily use it. The first method can vary depending on whether you are using a newer or older version of Excel. In this tutorial, I showed you two ways that you can use to find out what version of Excel you are using. Select Customize Ribbon and check the Developer option from Main Tabs. Note: If you can’t see the Developer ribbon, from the File menu, go to Options. The above steps would show a message box with a number, and you can refer to the table below to find out what version of Excel you’re using.
#Microsoft excel versions code#
Run the code by pressing the Run button from the toolbar on top of the window.Copy the above lines of code and paste them into the new module window. You should see a new module window open up. Make sure ‘ThisWorkbook’ is selected under the VBA project with the same name as your Excel workbook.If you don’t see Project Explorer, click on View->Project Explorer. Once your VBA window opens, you will see all your files and folders in the Project Explorer on the left side.From the Developer menu ribbon, select Visual Basic.To enter the above code, copy it and paste it into your developer window. The code is shown below: Sub ExcelVersion() When it was ported to Windows 2.x, they started at version '2.0' to one up current Mac version. If you prefer working with VBA, then here’s a quick way, using just three lines of code to find out what version of Excel you have. Excel, from Microsoft, is a powerful spreadsheet application for Mac, Windows, and OS/2. Using VBA to Find out What Version of Excel you Have
#Microsoft excel versions full#
On the right-hand side, under Microsoft Office Excel 2007, you should see your full Excel version information.Click Resources from the sidebar on the left.This will open the Excel Options dialog box.Select Excel Options from the bottom of the window that appears.Under the About Microsoft Excel category, you will find the full version, product ID, and a link to the copyright information.įor older Excel versions (2007 and before), here are the steps you need to follow in order to find out your Excel version information:.On the right-hand side, you should see your Office product name and Activation status.In the Excel 2010 interface, the way to find out version information is a little different.
#Microsoft excel versions full version#
In some cases, you can even see the full version number, including the build number, the type of installation, and if it’s a 32-bit or 64-bit version. If you’re on one of the newer Excel versions, follow these steps to find out all information about your Excel version.
#Microsoft excel versions series#
The Excel version that you are using can be found easily, although the process to find this information is different on each Excel version. Microsoft Excel 2016 is the latest entry into Microsofts venerable Excel series of spreadsheet software, coming together with the rest of its Office 2016.
#Microsoft excel versions how to#
How to Find What Version of Excel you Have using Excel Menus