The Microsoft Office productivity suite for Microsoft Windows was made available for retail sale on June 15, 2010, while the production release of Microsoft Office 2010 800px-Microsoft Office 2010.svg.png (codenamed Office 14) occurred on April 15, 2010. It is both Microsoft Office 2013’s predecessor and the replacement for Microsoft Office 2007. Office for Mac 2011, the macOS version, was made available on October 26, 2010.
In addition to other user interface improvements, Office 2010 has a Backstage view that centralizes document management activities. The primary user interface for all programs is the ribbon, which was first introduced in Office 2007 for Access, Excel, Outlook, PowerPoint, and Word. Office 2010 offers complete customization of the ribbon. Additional new features include expanded file format support, co-authoring tools that let multiple users collaborate on and edit documents at the same time, OneDrive and SharePoint integration, and security upgrades like Protected View, an isolated, read-only sandbox environment that shields users from potentially harmful content. Office Online, originally known as Office Web Apps, introduced a collection of free web-based versions of Word, Excel, OneNote, and PowerPoint. Microsoft Works was replaced by Office Starter 2010, a new version of Office. Microsoft’s mobile productivity suite, Office Mobile 2010, was updated on May 12, 2010, and is now available as a free upgrade through the Windows Phone Store for Windows Mobile 6.5 devices that already have an older version of Office Mobile installed.
The IA-32 and x64 versions of Office 2010 are available for the first time, although the x64 version is incompatible with Windows XP and Windows Server 2003. Additionally, it is the first version to demand product activation for editions with bulk licenses. Office 2010 may be installed on previous service packs of Windows XP via a registry vulnerability, although it only supports Windows XP SP3, Windows Server 2003 SP2, Windows Vista SP1, or a later version. As its replacement, Office 2013, does not support these operating systems, it is the final version of Microsoft Office that is compatible with Windows XP, Windows Vista, Windows Server 2003, and Windows Server 2008.
Office 2010 had a generally good response, with reviewers appreciating the redesigned Backstage view interface, the additional ribbon customization possibilities, and the ribbon’s inclusion in all programs. Office 2010 was a triumph for Microsoft and broke all prior adoption, deployment, and revenue records despite initial sales being lower than those of its predecessor. Before Office 2010 was discontinued on January 31, 2013, over 200 million licenses had been purchased as of December 31, 2011.
Office 2010’s mainstream support ended on October 13, 2015, and its extended support will do the same on October 13, 2020.
Microsoft Office 2010 (Office 14) was published on June 15, 2010. Pre-Office 2013 Microsoft. Office 2011 for Mac launched Oct. 26.
Backstage consolidates document handling in Office 2010. Access, Excel, Outlook, PowerPoint, and Word 2010 ribbons are customisable. New features include increased file format compatibility, co-authoring, OneDrive and SharePoint integration, and Protected View, a read-only sandbox environment. Excel, OneNote, PowerPoint, and Word are free online. Works superseded Office Starter 2010. Free update to Office Mobile 2010 for Windows Mobile 6.5 devices.
Office 2010 x64 isn’t compatible with XP or 2003. Volume licensing debut. Windows XP SP3, Server 2003 SP2, Vista SP1 or later are supported by Office 2010. It can infect XP service packs. Office 2013 isn’t compatible with Windows XP, Vista, Server 2003, or Server 2008.
The revamped Backstage interface, ribbon customization, and ribbon integration were praised. Office 2010 broke adoption, deployment, and revenue records despite lower initial sales. 200 million Office 2010 licenses were sold by 12/31/11. Office 2010 support ends in 2020.
SharePoint and Web 2.0 inspired Office 2010’s applications and Internet deployment.
Office 2010 is “role-based,” including R&D, sales, and HR features.
Behind-the-scenes Backstage Info in Word 2010 shows document overview and administrative tasks.
Office 2007’s Backstage view consolidated document management and sharing. Backstage is where behind-the-scenes operations and preparations begin; Backstage view provides an interface for such chores before saving or sharing a document. Left navigation and main pane. The navigation pane provides typical directions to access or save files and tabs that reveal document management duties and context. Recent papers are displayed in the navigation pane.
Each tab in the main pane provides context-specific program, file, and task information. Prepare for Sharing group in Word’s Info tab displays document metadata to alert users of potentially personal information before sharing a file. Help gives Office version and license information. Office 2007 separated this information. Users may access open Excel, PowerPoint, and Word document updates from the Info tab. Backstage view combines the Print tab’s print and print preview functions, including printer tasks, settings, and a zooming user interface to preview the active page.
Developers can add commands, tabs, tasks, and information to the Backstage view ribbon.
The new File tab replaces Office 2007. Fitts’ rule required that the former Office button, a circular button with the Microsoft Office logo, be positioned apart from the ribbon tabs in Office 2007. Microsoft argues this button enhances Office’s usability, but many users regard it as “branding, not a button.” Office 2010 replaced it with a File tab in the ribbon. App-specific tab coloring (e.g., it is colored orange in Outlook). File opens Backstage.
Office 2010 replaces the Paste Special dialog box and Paste Recovery feature with a Pasting Options gallery. When users hover over an option in the gallery, a tooltip with an explanation and keyboard shortcut appears. The remainder of the context menu becomes invisible when a user hovers over a gallery item to prevent disturbing document previews. Use arrow keys or Ctrl after Ctrl+V to navigate the paste gallery. Clipboard and app determine gallery options.
Office 2010’s ribbon is totally customizable.
Users may rename and add to tabs and groups, and hide unwanted tabs. Ribbon customizations may be exported, imported, deployed, shared, or reset. Ribbon may be minimized to show tabs.
Microsoft gave free downloads of customizable ribbons with a new “Favorites” page after the launch of Office 2010 based on consumer input. Access, Excel, InfoPath, OneNote, Outlook, PowerPoint, Project, Publisher, Visio, and Word have configurable ribbons.
Office 2010’s default color palette is silver instead of blue to improve readability.
Office 2010 redesigned app icons. The new icons are color-coded and accent app letters.
Unlike Office 2007, Office 2010’s splash screen is animated.
Equation Tools is a tab in OneNote and PowerPoint.
PowerPoint and Publisher provide grid guidelines.
Office XP’s smart tags are named Actions and appear in the context menu.
Office 2010 supports OOXML ISO/IEC 29500:2008.
Office 2010 supports ISO/IEC 29500 Transitional and Strict. Pre-release Office 2010 supported only Transitional, not Strict.
Office 2010 supported OpenDocument Format (ODF) 1.1, a joint OASIS/ISO/IEC standard (OpenDocument v1.1)
Excel Web App, OneNote Web App, PowerPoint, and Word clients may co-author SharePoint 2010 and OneDrive documents.
Office 365-compatible. Co-authoring begins when many people open the same document. Excel, OneNote, PowerPoint, and Word users may save documents to remote locations from Backstage. Microsoft account needed for Office 2010 OneDrive. Excel Web App, OneNote Web App, and OneNote store co-authored documents after each edit in near real-time. PowerPoint and Word changes must be saved manually.
Excel Web App, PowerPoint, and Word show co-authors on the progress bar. This PowerPoint and Word icon gives contact information, including co-authors; similar information is on the Info tab in Backstage view. If Skype for Business is installed on each computer, co-authors can exchange e-mails or start IM conversations by clicking each other’s names. Before publishing to the server, sharers can accept or reject PowerPoint or Word modifications.
In OneNote Web App and OneNote, users may view co-authors’ identities and edits in a shared notebook or create individual page versions. Since a notebook was last opened, revisions and author initials are underlined. Co-authors can find co-revisions in OneNote’s client version. Windows Phone 7 users of Office Mobile 2010 may share OneNote notebooks. If shared notebooks employ the OneNote 2007 file format, 2007 and 2010 users can co-author. No co-author search, page versioning, or OneNote Web App compatibility.
Office 2010 Home and Student, Home and Business, and Starter have a novel Click-to-Run installation method based on Microsoft App-V streaming and virtualization technologies. Click-to-Run programs install in a virtualized environment—a Q: partition—that downloads features in the background. Optimized broadband downloads
Microsoft announced a Product Key Card licensing method for Office 2010 that allows customers to purchase a single license to activate Home and Student, Home and Business, and Professional editions preloaded on PCs.Single-machine Product Key Cards exist.
Activate Office 2010 volume licenses. OEM and retail Office2007 needed activation.
Office File Validation, formerly exclusively in Publisher 2007 for PUB files, is available in Excel, PowerPoint, and Word in Office 2010. (e.g., DOC, PPT, and XLS). When users view a document, its file format is assessed to verify it complies with XML schema requirements. If a file fails validation, it will be opened in Protected View, a new read-only, isolated sandbox environment. Users may physically check invalid documents. Microsoft claims papers can falsify validation. To enhance Office File Validation, Office 2010 records information about rejected files and prepares copies for optional submission to Microsoft. After a failed validation, users are contacted every two weeks to submit files. Prompts offer a list of Microsoft-submitted files and demand user consent. Disable data submission.
Microsoft backported Office File Validation to 2003 and 2007 on December 14.
Office File Validation was backported as an add-in on April12, 2011. Microsoft Office 2003 and 2007 lack Protected View, therefore file validation differs from Office 2010. Before opening a failing document, users must accept a warning. These two editions only give Windows Registry setting options, whereas Office 2010 adds Group Policy.
Excel, PowerPoint, and Word now have Protected View. When a document is accessed via the Internet or as an e-mail attachment, or if it passes Office File Validation, it is opened in Protected View, which prevents potentially risky documents from changing system components, files, and other resources. Protected View can be opened manually. Users may see, copy, and paste a Protected See document, but not alter, save, or print it. Disabled: ActiveXcontrols, database connections, hyperlinks, and macros. Office users can open documents outside of Protected View by choosing “Enable Editing.” Active content in a potentially problematic document stays disabled after exiting Protected View until a user clicks “Enable Content” on the message bar, which certifies the document as a trusted document so users are not prompted in the future.
Protected View is a child process in Excel, PowerPoint, and Word. Each app’s primary process receives the user’s access token and contains Office UI components like the ribbon. Protected View parses and renders document content with limited rights. The primary process handles separate-process requests. Mandatory Integrity Control and User Interface Privilege Isolation restrict Windows Vista and later. Windows XP with Office 2010 has a less robust version of Protected View.
Office 2010 enables users label individual documents as trustworthy, enabling all active content to run; trusted documents don’t open in Protected View. Users are alerted if a remote document is trusted. TEMP directory documents and Temporary Internet Files aren’t secure. Trust records offer the whole path to trusted documents to protect users from social engineering.
Office 2010 natively supports DEP (DEP).
Office 2010 applications comply with DEP regulations and allow disabling via the UI or Group Policy.
Office’s new ActiveX kill bit allows customizing controls without damaging IE.
Excel, PowerPoint, and Word File Block Group Policy choices.
Cryptography enhancements in Access, Excel, InfoPath, OneNote, PowerPoint, and Word; Suite B support; encrypted file integrity checking.
Domain-based password policies.
Visual art Excel, Outlook, PowerPoint, and Word have glass, paint stroke, pastel, and pencil drawing effects.
Microsoft Research-based background removal tools are now in Excel, Outlook, PowerPoint, and Word. The Remove Background command appears when a picture is selected. This command displays a Background Removal contextual tab and a magenta selection rectangle. The selection rectangle decides, based on an algorithm, the picture region to be kept after background removal. Users may manually adjust the selection rectangle and designate picture areas to preserve or discard. Marks can be erased after an unintentional selection or unwanted consequence. After removing the background, users may apply visual effects or wrap text around the image; they can even crop it because removing the background doesn’t reduce its size.
Excel, PowerPoint, and Word 2010 crop images. The crop selection rectangle now grays out image portions to be removed during a crop process and displays the result area in color, instead of removing all image portions outside of the selection rectangle from view as in previous Office versions. Images can now be repositioned underneath the selection rectangle while it is active. A new Aspect Ratio option under the Crop command on the ribbon presents a drop-down menu for both landscape and portrait page orientations to customize the aspect ratio of the selection rectangle before cropping an image, which automatically resizes the selection rectangle when users start the crop process; users can manually resize the selection rectangle and preserve its aspect ratio by resizing it from its corners while pressing the Shift key. Publisher supports cropping.
Previous versions of Office replaced Picture Shape with Crop to Shape, which enables users modify and alter the selected shape during cropping. Office 2010 auto-resizes pictures in forms whose aspect ratio changes. Imported form images may now be cropped, resized, and Fit & Filled. Both options maintain the image’s aspect ratio. First option resizes image to fill crop selection rectangle or shape; second option displays whole image. SmartArt diagrams can edit pictures.
Excel, PowerPoint, and Word support bevels, gradient fills, glows, and shadows. Publisher and Word support Calibri, Cambria, Corbel, and Gabriola fonts with OpenType kerning, ligatures, stylistic sets, and text figures.
Excel, PowerPoint, and Word support DirectX 9.0c GPUs with 64 MB video RAM. PowerPoint features hardware-accelerated animations, transitions, video playback, and effects; slideshow components are generated as sprites and composited with Pixel Shader 2.0 fades and wipes. Office 2010 supports Direct3D SmartArt and WordArt. Competent hardware speeds up background removal, brightness, and contrast.
Excel, Outlook, PowerPoint, and Word enable users insert screenshots without keeping them. New Screenshot command on Insert ribbon tab. The first option displays open windows as thumbnails on the ribbon and inserts a screenshot of the selected window into the active app, while the second minimizes the active app, dims the screen, and presents a selection rectangle for users to create a screenshot by holding the main mouse button, dragging the selection rectangle to a desired area of the screen, and then releasing the button to automatically insert the selection as an image. Capture just maximized windows. Edit a screenshot after inserting it.
Excel, Outlook, PowerPoint, and Word SmartArt diagrams in Office 2007 feature new effects, options, and interfaces. New ribbon commands restructure SmartArt text pane content. SmartArt diagrams trim photographs to retain aspect ratio and allow image movement. SmartArt diagrams lock form layouts during cropping to prevent user error. New 50-schematics. New Picture and Organization Chart categories both have over 30 diagrams.
SmartArt’s Convert tool now supports Excel and PowerPoint. Office 2007 SP2’s Convert to Shapes context menu option is now on both apps’ ribbons. PowerPoint’s Transform to Text feature can bullet SmartArt diagrams.
Check accessibility In Excel, PowerPoint, and Word, Office 2010’s Accessibility Checker looks for problems that might impact visually impaired readers. The button opens a window with accessibility problems and solutions. Backstage view shows accessibility concerns in Prepare for Sharing so they may be solved. Group Policy allows admins regulate this info’s visibility.
Access, Excel, OneNote, Outlook, PowerPoint, Project, Publisher, Visio, and Word’s Backstage view use Language Preferences.
The revised UI shows installed language packs and their components, download links, and a ScreenTip Language feature to change tooltip language.
Mini Translator translates OneNote, Outlook, PowerPoint, and Word. Phrase or word translations are given in a tooltip, from which users may hear a text-to-speech audio pronunciation, copy the translation to the clipboard, or study an online definition if the chosen text is a word. Speak can be accessed separately from the Mini Translator (e.g., added to the ribbon), but only if a text-to-speech engine matching the selected text is installed. Microsoft downloads text-to-speech. Windows XP Office 2010 lacks Speak.
Windows XP SP3 (excluding x64 editions), Windows Server 2003 SP2 with MSXML 6.0 (excluding x64 editions)
Windows Vista SP1, Windows 7, Windows 8, Windows 10; Windows Server 2008, Windows Server 2008 R2, Windows Server 2012
500 MHz (1 GHz for Outlook with Business Contact Manager)
256 MB (1 GB for Outlook with Business Contact Manager)
3 GB of free space (3.5 GB for Professional, Professional Academic, Professional Plus)
1024×768 (XGA) (1024×576 (WSVGA) for Home and Student, Home and Business)