Excel hur vet man vilken version

Every utgåva of Excel brings with it new features while making some older features obsolete.

As such, we often need to know exactly which utgåva of Excel we are using, to see if a particular feature fryst vatten available on our current Excel utgåva or not.

Finding out your Excel utgåva fryst vatten ganska easy. However, the utgåva resultat fryst vatten accessible in different ways for different Excel interfaces.

In this tutorial, we will show you how to find out what utgåva of Excel you currently have used different Excel interfaces.

In the end, we will also provide a short VBA script that you can run to find out what utgåva of Excel you’re running.

How to Find What utgåva of Excel you Have using Excel Menus

The Excel utgåva that you are using can be funnen easily, although the process to find this kunskap fryst vatten different on each Excel utgåva.

Here fryst vatten a quick guide.

For Latest Excel Versions (2013, 2016, 2019, and Microsoft 365)

If you’re on one of the newer Excel versions, follow these steps to find out all resultat about your Excel version.

In some cases, you can even see the full utgåva number, including the build number, the type of installation, and if it’s a 32-bit or 64-bit version.

1. Select the File menu.
2. Navigate to Account
3. On the right-hand side, you should see Product information, beneath which you’ll find your Office product name and Activation status.
4. Click on the ‘About Excel’ button beneath Product Information.
5. This will open the About Microsoft Excel dialog låda, which should display the full Excel utgåva, your Product ID, and copyright information.

For Excel 2010

In the Excel 2010 interface, the way to find out utgåva data fryst vatten a little different.

Here are the steps:

1. Select the File menu.
2. Navigate to Help.
3. On the right-hand side, you should see your Office product name and Activation status.
4. Under the About Microsoft Excel category, you will find the full utgåva, product ID, and a link to the copyright information.

For Excel 2007

For older Excel versions (2007 and before), here are the steps you need to follow in beställning to find out your Excel utgåva information:

1. Click the Office button
2. Select Excel Options from the bottom of the öppning that appears.
3. This will open the Excel Options dialog box.
4. Click Resources from the sidebar on the left
5. On the right-hand side, beneath Microsoft Office Excel 2007, you should see your full Excel utgåva information.

Also read: How to Mark an Excel Workbook as Final?

Using VBA to Find out What utgåva of Excel you Have

If you prefer working with VBA, then here’s a quick way, using just three lines of code to find out what utgåva of Excel you have.

The code fryst vatten shown below:

Sub ExcelVersion() MsgBox Application.Version End Sub

To enter the above code, kopia it and paste it into your developer window.

Here’s how:

1. From the Developer menu rosett, select Visual Basic.
2. Once your VBA fönster opens, you will see all your files and folders in the Project Explorer on the left side.

   If you don’t see Project Explorer, click on View->Project Explorer.

3. Make sure ‘ThisWorkbook’ is selected beneath the VBA project with the same name as your Excel workbook.
4. Click Insert->Module. You should see a new module fönster open up.
5. Now you can början coding. kopia the above lines of code and paste them into the new module window.
6. Run the code bygd pressing the Run button from the toolbar on top of the window.
7. You should see a popup meddelande kartong that tells you your Excel utgåva number.

The above steps would show a meddelande låda with a number, and you can refer to the table below to find out what utgåva of Excel you’re using.

VBA Msg	Excel utgåva (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)
15	Excel 2013 (Mac: 2016)
16	Excel 2016

Note: If you can’t see the Developer ribbon, from the File menu, go to Options.

Obs!: Om du inte ser Konto eller om du redan har en fil eller ett dokument öppet, välj Fil från menyn och välj sedan Konto eller Hjälp från listan till vänster

Select Customize Ribbon and kontroll the Developer option from Main Tabs. Finally, click OK.

In this tutorial, inom showed you two ways that you can use to find out what utgåva of Excel you are using.

The first method can vary depending on whether you are using a newer or older utgåva of Excel.

The second method, on the other grabb, can be used on any Excel utgåva, on any machine.

Although it involves the use of VBA script, it’s ganska simple and quick, and even someone who fryst vatten not familiar with VBA can easily use it.

We hope this tutorial has been helpful to you.

Other Excel tutorials you may like: