- What Version Excel Am I Running
- Microsoft Excel Versions
- How To Tell My Version Of Excel
- What Version Of Excel Do I Have 2019
- What Version Of Excel Do I Have 2016
First, select “File” from the main menu. The select “Account” from the left menu. The Excel version is displayed in the section called “About Excel”. In the example below the version is 2008. We know that Microsoft Excel has different features across different versions and there are several Excel version, like Excel 2003, 2007, 2010, 2013, 2016, 2.
At the time of this writing, there have been 30 versions of Excel that stretch from 1985 to the current year, running on three different operating systems. Each version might be slightly or significantly different than the last.
If you’re working with Excel, just learning it, or troubleshooting an issue, it’s important to know which version you are using. There are also some tips and tricks to upgrade versions, work between different versions, and deal with compatibility issues.
This piece should clear up any differences between the major releases of Excel, how file compatibility works between versions, and what you can do to upgrade. If you have more questions about Excel, a live chat session with Excelchat can provide the answers.
Learn about the different versions of Excel and how to upgrade your software.
Which Excel Version Do I Have?
Some of the major Excel versions that you’ll probably run across include Excel 2003, 2007, 2010, 2013, 2016, and Excel365. But, which version are you currently working with? Depending on your version, here are the actions to take:
- In Excel 2003, go to the Help tab, and click on About Microsoft Excel.
- In Excel 2007, click on the rounded Microsoft icon in the top left corner, and click on Excel options > Resources > About.
- In Excel 2010, click on File > Help > About Microsoft Excel.
- In Excel versions 2013 and 2016, go to File > Account > About Excel.
About the Different Excel Versions
There are too many versions of Excel to list and outline, but here are some of the major releases and what you need to know.
- Excel 2003. This was the first version of Excel to offer tables and the first to have the “WIMP” (Windows, Icons, Menus, Point) interface. It was released for both Windows and Mac operating systems.
- Excel 2007. This release was only provided for Windows and it was the first Excel version to have the Ribbon interface. It also changed the file format from .xls to .xlsm and .xlsx files. This expanded the number of rows that a file could hold to 1 million and improved file security.
- Excel 2010. This version was also only released for Windows. Some of the new features included Ribbon customizations, multi-threading support, and sparklines.
- Excel 2013. This version was only available for Windows and features included Slicers, Flash Fill, and dozens of new functions.
- Excel 2016. This version was released for both Windows and Mac, and it includes regular feature updates released online.
- Excel365. This is a subscription-based version of Excel 2016 that is 100% online and regularly updated. You don’t need to do anything to make this happen.
How to Update Excel
If you have an older version of Excel and want to update it, how you do this will depend on which version you are currently running. Support has ended for Office 2003 and 2007, so it would be a good idea to buy and install the latest version.
If you have Excel 2010, go to File > Help > Check for Updates. If there are updates available, choose Install Updates.
If you have Excel 2013, go to File > Account. Choose Update Options under Product Information. Select Enable Updates. Click Update Now to check for and install any updates.
How to Use Excel Files Created from Earlier Versions of Excel
Once you’ve installed a new version of Excel or upgraded, you might want to know how this is going to impact your existing files. When you have files that were created in an earlier version of Excel, backward compatibility will work in various ways:
- Use compatibility mode. Compatibility Mode allows you to open and work with Excel files that were created in earlier versions than the one you have. However, this isn’t available for Excel 2007 files.
- Download a file converter. You can use a file converter to download and open Excel files in earlier versions of Excel.
Versions 2010 and later of Excel allow you to open files that were created in 97-2003 versions in compatibility mode. This should be automatic. However, any new features that were created in Excel after the file was created will not be available in this mode.
If you don’t want to work on a workbook in compatibility mode, you have the option to convert the file to a format that is consistent with the new version of Excel.
If you have an Excel file that is from Excel 97-2003 and you try to open it in a later version, you might be prompted to “convert” the file. Assuming the file is in .xls format, and you don’t plan to work on it in that format again in the future, you can convert it to an XML format (.xlsx, .xltm, .xlsb, .xltx, .xlsm).
After the conversion, you’ll have access to the new features and functions of your current Excel version. To convert a workbook, take the steps:
- Open the workbook (this will happen in compatibility mode).
- Go to File > Info > Compatibility Mode > Convert.
- Click OK.
If you want to have copies of the old file format and convert to the new file format, simply go to File > Save As. Keep the same file name if you wish but choose a new extension under Save as type. Click Save.
Hopefully, you found the information you were looking for regarding working with different versions of Excel. If you still need to troubleshoot a particular issue, or want one-on-one training in Excel, find out how Excelchat can help.
Our friendly Excel experts are available 24/7 to give you the assistance you need. Just open a live chat window to get started. Your first session is always free.
What Version Excel Am I Running
Right now you might be wondering to yourself, “how do I find what version of Excel do I have?”
It’s a good question too, because Microsoft Excel has been around since 1985! Now this guide is going to assume you aren’t chugging along with the 1985 version, but we will show you how to find the most popular versions still in use today.
Microsoft Excel Versions
You will find the ‘file’ menu in all Microsoft Office programs. It will usually be the first tab on the top bar- on the top left. See the below graphic for more information.
The file menu is home to a lot of powerful features, whether you are using Excel 2016 or Excel 2007. I would recommend looking for more information in the file tab.
Once you've found the 'Account' menu, click on 'About Excel'
The account menu also includes information about Excel version updates, and allows you to change your Office theme. The Office theme I use is the dark theme as you can see in the screenshots. It’s much easier on the eyes when you work with these programs all of the time!
And there it is! Your version of Microsoft Excel. Again, if you have Excel through a Microsoft Office Suite, then you will see the same across all of your Office programs. Looking at mine below, I am using Office 365, the 32-bit version.
What does it all mean? Well, because I am using Office 365, which is a cloud based subscription service that stores most of Office in the Cloud and Onedrive, We can see that version listed here. Let’s break it down bit-by-bit to make it easier to understand.
Microsoft Excel for Office 365 is the program and service I’m using.
MSO stands for Microsoft Office
(16.0.11929.20708) is the version number and shows if there have been any updates or not. You can install the latest Microsoft Office updates here.
How To Tell My Version Of Excel
The end will either be 32-bit or 64-bit. Here’s a quick summary of the differences. The 32-bit version is lighter weight and can run on 32-bit system (or older systems to put it simply) and 64-bit means it can run and use more memory, which is great when dealing with large amounts of data. For most people, 32-bit will do the trick, but consider upgrading it to 64-bit if you think you might need the extra oomph!
Probably not! If you do not see this menu you probably have an older version. In that case follow the below steps:
- Go to the ‘help tab’ on the top bar
- Choose the last menu option ‘About Microsoft Excel’
- It will display your current version!
Alright, then you may have Excel 2007 or 2010. In that case follow the below:
What Version Of Excel Do I Have 2019
- Click the Office button in the top left on the top bar. It looks like this:
- Then click ‘Excel Options’
- Then click ‘Resources’
- Then click ‘About’
- And you should see your version number!
Alright, if you STILL DON’T See your version number, then I’m impressed! You’ve navigated to this site with a dinosaur of a device. But hey, it’s possible. I’m not going to go in to detail on how to find those version numbers, but I recommend upgrading if possible as the new Excel’s have A TON OF POWERFUL FEATURES that will make your life so much easier. But if you do need help still, leave a comment and I’ll make sure to find it out for you!
What Version Of Excel Do I Have 2016
Hi Everyone! I’m an IT manager and I’ve noticed that there are a lot of problems out there that just do not have clear and concise language for solving daily IT issues! On this channel, I hope to help you fix your IT issues and make life easier for you, whether you work in IT or if you just have something that needs fixing!