Tap into powerful analysis features that were previously available only by installing the Power Pivot add-in. Review and edit documents from anywhere with the Office mobile apps. Excel recommends the best ways to present your data based on the context and recent work patterns. New bars, colors and icons help to highlight trends.
Microsoft plans include premium versions of these applications plus other services that are enabled over the Internet, including online storage with OneDrive and Skype minutes for home use.
Microsoft plans are available as a monthly or annual subscription. Learn more. See system requirements for compatible versions of Windows and macOS, and for other feature requirements. Documents that you have created belong fully to you. If you cancel your subscription or it expires, you can still access and download all your files by signing in to OneDrive directly using the Microsoft account you used to set up Microsoft You do lose the additional storage that comes with your subscription, so you must save your files elsewhere or buy more OneDrive storage if your OneDrive account exceeds the free storage quota.
If you purchase an auto-renew subscription, your subscription starts when you complete your purchase. You can purchase auto-renew subscriptions from Microsoft If you purchase a pre-paid subscription, your subscription starts when you activate your subscription and land on your My Account page. You can purchase pre-paid subscriptions from a retailer or reseller, or a Microsoft support agent. If you have an active Microsoft Family subscription, you can share it with up to five members of your household six total.
When you use cloud-based services, your IT infrastructure resides off your property off-premises , and is maintained by a third party hosted , instead of residing on a server at your home or business on-premises that you maintain. With Microsoft , for example, information storage, computation, and software are located and managed remotely on servers owned by Microsoft.
Office is designed to integrate with the cloud—with SkyDrive and SharePoint, in particular. If you use SkyDrive, the account details will appear in the top left corner of all the application screens, as well as on their start screens.
Click your account details to switch accounts and to manage them. When you save a document, worksheet, or presentation, the application will default to saving to your SkyDrive account, but you can save to your local disk if you wish.
In addition, Word, Excel, and PowerPoint will save the last location where you were working before you saved—down to the letter, cell, or image. This feature makes it easier to pick up where you left off working, even if you open the file on a different device than you last used.
Some new Office features are designed to make working with a touchscreen easier. The new Read Mode in Word opens a document in reading view, which lets you scroll through the document by swiping horizontally with your finger. On a desktop with a touchscreen monitor, you can change this behavior back to the more traditional page navigation mode if you wish. Click the Touch Mode button on the Quick Access Toolbar—to the right of the program logo of each application—and the ribbon toolbar spreads its icons further apart for easier access to fingers.
Quickly type a formula that returns multiple values, and they'll automatically spill into the neighboring cells. Get started. What's new in Excel for Microsoft Latest updates for Excel for Windows Desktop There is nothing new in Find your Office version Note: If you use Office at work, the availability of the features above may vary based on your company's update policies.
Enjoy an improved scrolling experience Scrolling through your sheet just got smoother when navigating large or very wide cells. Want new features first? More about releases When do I get new features? Previous releases. Here's what's new in Version Office has a fresh look The new visual refresh is modern and new, designed to make it simple, intuitive, and seamless experience across all your Office apps.
Get control over the first two query steps that automatically promote column headers and change data types By default, Power Query promotes a first row to a column header and converts the Any data type to a specific data type, but you can control this with a Query option. Linked data types: Real data for real life New linked data types bring you facts and data on hundreds of subjects to help you accomplish your goals right in Excel. A new way to reach the Accessibility tools The Accessibility ribbon puts all the tools you need to create accessible content in one place.
Improved Conditional Formatting dialogs Conditional Formatting dialogs are now resizable, and now you can duplicate the rule with a single click. Unhide many sheets at the same time No need to unhide one sheet at a time anymore -- unhide multiple hidden sheets at once. Create a custom data type in Power Query Use any data source to create a custom data type that lets you load multiple related pieces of information into one column.
Switch Office themes automatically Office can automatically switch themes to match your Windows 10 theme settings. Save shapes as pictures In just a few clicks, save a shape, icon, or other object as a picture file so you can reuse it elsewhere. Make polished Visio diagrams in Excel Create data-driven diagrams like flowcharts or organizational charts from data in a worksheet.
Help protect your data from malicious files Application Guard helps protect you from malware by letting you read, print, and save Office files in an isolated container. Make quick edits using the Excel pen With the action pen, you can directly handwrite in the cells, jot down data with ink that gets automatically converted to Excel data.
Create variables to use in formulas Improve performance, readability, and composability with the LET function. Filter and sort without disrupting others Sort and filter your Excel file while collaborating with others with Sheet View. Here's what's new in Version Build Save to your pinned folder Pinned folders stay near the top of your Save locations so you can quickly access the folder you need.
New images to bring your documents to life Thousands of royalty-free stock images, icons, and stickers you can use in your documents. Ask Excel: Excel Ideas allows you to ask questions about your data - no need to spend time writing formulas. Tame your big workbook Cells, formulas, charts, tables Jazz up your files and email Give your presentations, documents, and email messages more flair with free, high-quality stock images and backgrounds.
Pick your perfect color Use hex color codes to choose exactly the color you want for your font, text highlight, and more. Automatically use new data types When you type a data value that resembles a stock or a geographic location, Excel offers to convert it to the right connected data type - Stocks or Geography.
More insight from your data Get a deeper understanding of your data using the new data profiling views in Power Query Editor. See what's new for you in Version Build Read and reply on the fly Respond to comments and mentions right from email without opening the workbook. Convert files to improve accessibility Upgrade your files to the modern format to make them more accessible for everyone. Search and enjoy We've added Search to Insert Icons to make it easy to find the icon you want.
Focus on what's left to do Select Resolve to collapse comments and make open items stand out. Code quickly with Power Query enhancements Get to code completion quickly with auto-complete and syntax coloring.
No more bouncing to the browser You decide how links to Office documents open: in the browser or in the app. More icons to match your mood We've added over new icons. Switch seamlessly The new account manager shows all of your Microsoft work and personal accounts in one place.
Save your changes as they happen Upload your files to OneDrive to make sure all your updates are saved automatically. Collaborate effectively with comments and mentions Keep the conversation going right in your worksheet with the built-in reply box and let co-workers know that you need their input by using mentions.
See what's new in the October update, Version Reveal what's behind a picture Put a picture on a slide, worksheet, document, or message, pick a pre-set, and watch the transparency change.
Your ribbon icons have a new look Don't worry, everything works the same. Chat with co-authors while you edit Collaborate more effectively by chatting with your co-authors without leaving the app. One-click fixes for accessibility issues The Accessibility Checker is better than ever with updated support for international standards and handy recommendations to make your documents more accessible.
Add visual impact Bring visual interest to your documents, worksheets, and presentations by inserting Scalable Vector Graphics SVG that have filters applied to them. Break the language barrier Translate words, phrases or sentences to another language with Microsoft Translator. Precision selecting Ever selected too many cells or the wrong ones? Find your Office version Digital Pencil Write or sketch out ideas with our new pencil texture. Find your Office version Insert 3D models to see all the angles Use 3D to increase the visual and creative impact of your workbooks.
New ink effects Express your ideas with flair using metallic pens and ink effects like rainbow, galaxy, lava, ocean, gold, silver, and more. Collaborative editing Work with others at the same time in your workbook. Helpful sounds improve accessibility Turn on audio cues to guide you as you work. Customizable, portable pen set Create a personal set of pens to suit your needs. Quick access to superscript and subscript Keep the superscript and subscript commands at your fingertips by adding them to the Ribbon or Quick Access Toolbar.
Latest updates for Excel for Mac There's nothing new for you Version Get in control with new data source settings on Excel for Mac Get in control with new data source settings on Excel for Mac. Unhide Many Sheets at the Same Time No need to unhide one sheet at a time anymore—unhide multiple hidden sheets at once.
Watch Your Formulas Watch cells across multiple sheets and books in a single pane or window. Jazz up Your Files Give your documents, slides and spreadsheets more flair with free, high-quality stock images, icons, and stickers.
Make Polished Visio Diagrams in Excel Create data-driven diagrams like flowcharts or organizational charts from data in a worksheet. Filter and Sort Without Disrupting Others Create your own views while collaborating with others in Excel, so you can filter and sort without disrupting what others see.
Pull Data from a Photo Add table data from pictures, from the Insert tab or directly from your iPhone. Tell it like you mean it Got a question about your data? In Excel Ideas, enter a question and we'll get you the answer. January 11, , update for Project Server KB Need more help? Expand your skills. Get new features first.
A subscription to help make the most of your time. For up to 6 people. Premium apps. Try 1 month free. Was this information helpful?
0コメント