The powerful Excel spreadsheet app lets you create, view, edit, and share your files with others quickly and easily. It also lets you view and edit workbooks attached to email messages. Work in accounting, auditing, finance, or other fields, with anyone, anywhere with confidence.
With Excel, your Office moves with you and can implement the most complex formulas, with amazing features. Review your work or start a budget on the go.
Customize your spreadsheet your way with robust formatting tools and great features. Excel lets you build your spreadsheet to meet your specific needs.
Create, calculate, and analyze with confidence Jump-start your budget, task list, accounting, or financial analysis with Excel’s modern templates. Use familiar formulas to run calculations and analyze your data. Rich features and formatting options make your workbook easier to read and use.
All spreadsheet features, formats, and formulas operate the same way — no matter the device you use. Review, edit, and work anywhere Review your Excel files from any device. Edit your data or update your task list from anywhere.
Features like sort and filter columns help focus your review. Create, duplicate, hide, and unhide sheets easily. Tell a story with your data Insert common charts to bring your data to life. Use features like add and edit chart labels to highlight key insights in your data.
The Scroll Lock setting here doesn't control Scroll Lock, it only displays Scroll Lock status. Once you make sure that the Scroll Lock status is on, look for the Scroll lock message in the lower left. Yes, Scroll Lock is turned on. On a Mac, as far as I know, Scroll Lock status will not appear in the status bar of Excel 2011. (I haven't checked.
Draw and annotate with ink Make notes, highlight portions of your worksheet, create shapes, or write math equations using the draw tab feature in Excel on devices with touch capabilities. Sharing made easy Share your files with a few taps to quickly invite others to edit, view, or leave comments directly in your workbooks. Copy the content of your worksheet in the body of an email message with its format intact or attach or copy a link to your workbook for other sharing options.
To create or edit documents, sign in with a free Microsoft account on devices with a screen size of 10.1 inches or smaller. Unlock the full Microsoft Office experience with a qualifying Office 365 subscription (see for your phone, tablet, PC, and Mac. Office 365 subscriptions purchased from the app will be charged to your App Store account and will automatically renew within 24 hours prior to the end of the current subscription period unless auto-renewal is disabled beforehand.
You can manage your subscriptions in your App Store account settings. This app is provided by either Microsoft or a third-party app publisher and is subject to a separate privacy statement and terms and conditions. Data provided through the use of this store and this app may be accessible to Microsoft or the third-party app publisher, as applicable, and transferred to, stored, and processed in the United States or any other country where Microsoft or the app publisher and their affiliates or service providers maintain facilities.
Please refer to the Microsoft Software License Terms for Microsoft Office. See “License Agreement” link under Information. By installing the app, you agree to these terms and conditions.
That Maurer Kid, Not for Engineering I use my iPad Pro for everything college. Literally everything. I type papers on the Microsoft Word app, make Power Points on Microsoft’s PowerPoint app, take notes, do online assignments, play games, listen to music, watch school related videos WHILE taking notes, etc etc. I do know that some features are left out on Microsoft apps since I’m using an Apple product and they DO NOT go unnoticed.
Such features I have been able to go without and many people probably don’t use them often. When it comes to Microsoft’s Excel app, too many features are left out and the app is almost rendered useless for engineering work. I need to be able to manipulate line graphs, scatter plots, and data and this app doesn’t allow me to do so. If I have 2 columns of data, I need to plot one versus the other, and this app doesn’t allow me to do so. Then once I do that, I need to be able to see all the data that comes with the graph that is generated, like the r^2 value and setting tolerances for trend lines etc. Maybe it was a far fetched idea in the first place to think I could use an iPad for all my college engineering work, but its frustrating when I can do literally everything else on my iPad faster, easier, and more convenient than with a laptop, EXCEPT for Microsoft Excel.
Literally the only drawback I have with my iPad. I get Office 365 through college so I’m still paying Microsoft for ALL of its features, but not getting them.
That Maurer Kid, Not for Engineering I use my iPad Pro for everything college. Literally everything. I type papers on the Microsoft Word app, make Power Points on Microsoft’s PowerPoint app, take notes, do online assignments, play games, listen to music, watch school related videos WHILE taking notes, etc etc. I do know that some features are left out on Microsoft apps since I’m using an Apple product and they DO NOT go unnoticed. Such features I have been able to go without and many people probably don’t use them often.
When it comes to Microsoft’s Excel app, too many features are left out and the app is almost rendered useless for engineering work. I need to be able to manipulate line graphs, scatter plots, and data and this app doesn’t allow me to do so.
If I have 2 columns of data, I need to plot one versus the other, and this app doesn’t allow me to do so. Then once I do that, I need to be able to see all the data that comes with the graph that is generated, like the r^2 value and setting tolerances for trend lines etc.
Maybe it was a far fetched idea in the first place to think I could use an iPad for all my college engineering work, but its frustrating when I can do literally everything else on my iPad faster, easier, and more convenient than with a laptop, EXCEPT for Microsoft Excel. Literally the only drawback I have with my iPad. I get Office 365 through college so I’m still paying Microsoft for ALL of its features, but not getting them. ABelieber, You will lose your work!!! Don’t buy Bought the subscription to Office 365 because I wanted to use Microsoft Excel. First 2 projects I worked on went fine. My 3rd project was a huge one (a $800 fee for me).
I worked on it for 6 hours when suddenly my work vanished. Disappeared right in front my eyes!
I tried everything, but I could not get the document back. Came to the realization that while the “auto-save” feature was “on”, the app was not saving any of the work!! The Microsoft cloud had nothing!
Made a quick research and found that this type of complaint has been posted by others going back to 2014!!! IT HAS NOT BEEN FIXED??!! Clients have had the same 2 bad experiences (failure by the auto-save and the document disappearing) AND MICROSOFT HAS NOT ADDRESSED THIS ISSUE.
So, despite buying the iPad Pro intending to use Excel, I now will have to buy a Window base laptop. ABelieber, You will lose your work!!! Don’t buy Bought the subscription to Office 365 because I wanted to use Microsoft Excel. First 2 projects I worked on went fine. My 3rd project was a huge one (a $800 fee for me). I worked on it for 6 hours when suddenly my work vanished. Disappeared right in front my eyes!
I tried everything, but I could not get the document back. Came to the realization that while the “auto-save” feature was “on”, the app was not saving any of the work!! The Microsoft cloud had nothing!
Made a quick research and found that this type of complaint has been posted by others going back to 2014!!! IT HAS NOT BEEN FIXED??!! Clients have had the same 2 bad experiences (failure by the auto-save and the document disappearing) AND MICROSOFT HAS NOT ADDRESSED THIS ISSUE. So, despite buying the iPad Pro intending to use Excel, I now will have to buy a Window base laptop. Batgirl0520, Love Excel, despise recent changes At one time I would have given 5 stars as Excel is one of my favorite programs. But some recent changes have made this app almost unusable for me.
I'd rather turn on my computer and wait to use that Excel instead of the app. If I try to scroll up and down with the key pad open, it usually closes the keypad on me. Opening it again every time is a pain. When I enter a number in a column and hit return, the keypad automatically reverts back to the text keys instead of the numbers. If you are entering numbers in a column, chances are you will want to keep entering numbers. Having it go back to text every time is obnoxious and totally a waste of time!
If I select a cell with my finger, it is basically impossible to then select an adjacent cell. I need to tap one away from the one I actually need first and then go back. Developer Response, Hi You can quickly go to editing a cell by double tapping it or by tapping edit in the context menu. If you want to add a lot of numbers please use the special excel number keyboard (tap the keyboard icon beside the formula bar) that will preserve the keyboard even after pressing enter. We also have special keys like Tab that help you navigate faster when entering data. Batgirl0520, Love Excel, despise recent changes At one time I would have given 5 stars as Excel is one of my favorite programs. But some recent changes have made this app almost unusable for me.
I'd rather turn on my computer and wait to use that Excel instead of the app. If I try to scroll up and down with the key pad open, it usually closes the keypad on me. Opening it again every time is a pain.
When I enter a number in a column and hit return, the keypad automatically reverts back to the text keys instead of the numbers. If you are entering numbers in a column, chances are you will want to keep entering numbers.
Having it go back to text every time is obnoxious and totally a waste of time! If I select a cell with my finger, it is basically impossible to then select an adjacent cell. I need to tap one away from the one I actually need first and then go back.
Developer Response, Hi You can quickly go to editing a cell by double tapping it or by tapping edit in the context menu. If you want to add a lot of numbers please use the special excel number keyboard (tap the keyboard icon beside the formula bar) that will preserve the keyboard even after pressing enter. We also have special keys like Tab that help you navigate faster when entering data.
Boy, Excel for Mac can be a real pain in the butt sometimes. In particular, refreshing data within a Mac Excel spreadsheet is near impossible. This is an issue that many of our users run into. Thankfully, we've got two simple solutions for you, and this blog walks you through each one step by step. If you want a quick, easy fix - use Method #1.
It will, however, require you to follow the process each and every time you want to refresh your data. If you have 5 minutes, scroll down to Method #2. This method will help you create a button, and it's as simple as that. To refresh your spreadsheet data, at any time - just click the button.
Remember, our team is always available via chat if you run into problems. We are here to help. Method #1 Run the IntrinioRefresh Macro. At the top of the screen, click on 'Excel' then 'Preferences' 2.
Double click on 'Ribbon & Toolbar' 3. On the right hand side, check the box next to 'Developer' 4. Click 'Save' in the bottom right hand corner 5. You should now see a tab at the top of the Excel spreadsheet called 'Developer'.
On the left hand side, you should see a button called 'Macros' with a bright green arrow. A prompt will pop up. In the top where it says 'Macro Name', type 'IntrinioRefresh' 8. In the bottom right hand corner, click run. Your data will update in the spreadsheet!
Method #2 Create a Macro Button in Your Toolbar. At the top of the screen, click on 'Excel' then 'Preferences' 2. Double click on 'Ribbon & Toolbar' 3. On the right hand side, at the bottom, click the + button 4. Click 'New Tab' 5. Click on the 'New Tab (Custom)' that shows up 6.
Click the settings symbol at the bottom, and click 'Rename.' Name this tab 'Intrinio' and click 'Save' 8. Underneath your new tab, click 'New Group (Custom)' 9. On the left hand side, click 'Choose commands from', and select 'Macros' 10. Scroll down and select 'IntrinioRefresh' 11. Click the right-facing arrow in the middle 12.
You should see 'IntrinioRefresh' show up underneath your new custom group on the right. Click 'Save' 14. Now, at the top of your workbook, you should see a tab called 'Intrinio'. Click on that. Underneath it should be a button called 'IntrinioRefresh'. Now, every time you click that button, the data in your spreadsheet will refresh. You're an Excel Guru.