How To Find Out What Version Of Excel I Have
Every version of Excel brings with it new features while making some older features obsolete.
Every bit such, we often demand to know exactly which version of Excel we are using, to see if a detail characteristic is bachelor on our current Excel version or non.
Finding out your Excel version is quite like shooting fish in a barrel. However, the version information is attainable in unlike ways for different Excel interfaces.
In this tutorial, we will show you lot how to find out what version of Excel you currently have used unlike Excel interfaces.
In the cease, we volition besides provide a curt VBA script that yous can run to notice out what version of Excel y'all're running.
How to Find What Version of Excel yous Have using Excel Menus
The Excel version that you are using can be found easily, although the procedure to find this information is different on each Excel version. Here is a quick guide.
For Latest Excel Versions (2013, 2016, 2019, and Microsoft 365)
If yous're on ane of the newer Excel versions, follow these steps to find out all information most your Excel version.
In some cases, you can even run across the total version number, including the build number, the blazon of installation, and if it's a 32-fleck or 64-bit version.
- Select the File menu.
- Navigate to Account
- On the correct-hand side, you should see Production information, under which you'll find your Office product proper noun and Activation status.
- Click on the 'About Excel' button under Production Information.
- This will open up the About Microsoft Excel dialog box, which should display the full Excel version, your Product ID, and copyright information.
For Excel 2010
In the Excel 2010 interface, the way to find out version information is a little different. Here are the steps:
- Select the File card.
- Navigate to Help.
- On the right-hand side, you should see your Function product proper noun and Activation status.
- Nether the About Microsoft Excel category, you will detect the full version, product ID, and a link to the copyright data.
For Excel 2007
For older Excel versions (2007 and before), here are the steps you need to follow in order to find out your Excel version information:
- Click the Role button
- Select Excel Options from the bottom of the window that appears.
- This volition open the Excel Options dialog box.
- Click Resources from the sidebar on the left
- On the right-paw side, under Microsoft Function Excel 2007, you should meet your full Excel version information.
Using VBA to Find out What Version of Excel you Have
If you prefer working with VBA, so here'south a quick manner, using only 3 lines of code to discover out what version of Excel you accept.
The code is shown below:
Sub ExcelVersion() MsgBox Application.Version End Sub
To enter the above code, re-create information technology and paste it into your developer window.
Here's how:
- From the Developer menu ribbon, select Visual Bones.
- One time your VBA window opens, you lot volition see all your files and folders in the Project Explorer on the left side. If you don't see Projection Explorer, click on View->Projection Explorer.
- Make sure 'ThisWorkbook' is selected under the VBA project with the aforementioned name as your Excel workbook.
- Click Insert->Module. You should see a new module window open up.
- Now you can start coding. Re-create the above lines of lawmaking and paste them into the new module window.
- Run the code by pressing the Run button from the toolbar on top of the window.
- You should see a popup message box that tells you your Excel version number.
The higher up steps would show a message box with a number, and you can refer to the tabular array below to notice out what version of Excel you're using.
| VBA Msg | Excel Version (Windows and Mac) |
| 8 | Excel 97 (Mac: 98) |
| 9 | Excel 2000 (Mac: 2001) |
| 10 | Excel 2002 |
| 11 | Excel 2003 (Mac: 2004) |
| 12 | Excel 2007 (Mac: 2008) |
| 14 | Excel 2010 (Mac: 2011) |
| xv | Excel 2013 (Mac: 2016) |
| 16 | Excel 2016 |
Note: If you tin't meet the Programmer ribbon, from the File menu, go to Options. Select Customize Ribbon and check the Developer option from Main Tabs. Finally, click OK.
In this tutorial, I showed you two ways that y'all can use to find out what version of Excel yous are using.
The first method can vary depending on whether you are using a newer or older version of Excel.
The second method, on the other paw, can be used on any Excel version, on whatever motorcar.
Although it involves the use of VBA script, information technology's quite simple and quick, and even someone who is not familiar with VBA can easily apply it.
We hope this tutorial has been helpful to you lot.
Other Excel tutorials you may like:
- Why does Excel Open on Startup (and How to Stop it)
- How to Remove Macros from Excel?
- How to Disengage in Excel (2 Piece of cake Ways)
- Best Excel Books (that will make you an Excel Pro)
- How to Open Excel File [xls, xlsx] Online
- How to Showtime Excel in Safe Way (3 Piece of cake Ways)
- How to Brand Excel File Read Merely
Source: https://spreadsheetplanet.com/find-version-of-excel/
Posted by: davisexter1987.blogspot.com
0 Response to "How To Find Out What Version Of Excel I Have"
Post a Comment