Although there are no designated superscript or subscript keys on the keyboard, you can use keyboard shortcuts to write them. When creating a spreadsheet in Microsoft Excel, you can use the available superscript button or keyboard shortcuts to write in superscript. If you’re working with Office 2011 for Mac, you’ll be glad to know that it’s easy to move your charts from Excel to Word and PowerPoint. You can even create a chart directly in Word 2011 for Mac and PowerPoint 2011 for Mac. Easy is good! The process of copying Excel charts into Word.

Excel 2011 replaces all of those floating bits with two toolbars (standard and formatting) and the Ribbon, a collection of small tabs that provide easy access to often-used commands. You can customize the Ribbon, or even disable it if you wish. It's context sensitive, so it changes to match the task at hand. For example, if you double-click an image, the Ribbon will open to a greatly improved set of image-editing commands. The Ribbon and toolbars are now integrated in each Excel window, so there’s nothing floating around outside your workspace. A couple of optional floating windows remain, but they’re not required in most typical spreadsheet work. The Ribbon’s tabs are compact, and the Ribbon itself can collapse to a single row of tabs when not in use.

Unfortunately, Excel doesn’t remember custom size/shape settings for any Ribbon-based windows, so you’ll have to resize them each time they’re activated. Improved filters: Excel 2011's filters are more in line with their Windows counterparts. People who rely on pivot tables will appreciate Excel 2011's automatic pivot table creation, a new PivotTable Builder to ease building and modification of pivot tables, and pivot table report designs, layouts, and styles.I found both building and manipulating pivot tables to be much simpler in Excel 2011 than in the 2008 version. Tables (previously known as lists) have similarly gotten a full makeover in Excel 2011. Creating tables is as simple as selecting your data and choosing a layout from the Ribbon (or from the menus). Once you've done that, it’s easy to filter and sort your data. Sorting and filtering in general is better in Excel 2011 than in Excel 2007 and 2010 for Windows.

This article is for people who use a screen reader program with the Office products and is part of the content set. For more general help, see. Many users find that using an external keyboard with keyboard shortcuts for Excel for Mac helps them work more efficiently. For users with mobility or vision disabilities, keyboard shortcuts can be easier than using the touchscreen and are an essential alternative to using a mouse. Best free email client for mac, ios, android. This article itemizes the keyboard shortcuts for Excel for Mac. Many of the shortcuts that use the Ctrl key on a Windows keyboard also work with the Control key in Excel for Mac.