Making drop down menus in excel for mac 2011

#Making drop down menus in excel for mac 2011 full#
#Making drop down menus in excel for mac 2011 windows#

Creating tables is as simple as selecting your data and choosing a layout from the Ribbon (or from the menus).

#Making drop down menus in excel for mac 2011 full#

Tables (previously known as lists) have similarly gotten a full makeover in Excel 2011. You can even include formulas based on data on other worksheets. You can also easily rearrange existing rules-a most welcome improvement. You can now pick from four predefined conditional formats (including data bars, color scales, and special icons), or set the format based on a formula (as before). The archaic editor in prior versions of Excel has been replaced with a larger and more intuitive interface. No longer are you restricted to three conditional formatting rules per cell the limit now depends only on your available RAM. Creating sparklines is as easy as selecting some data, choosing a menu item, and clicking a destination cell.Д¬onditional formatting, long one of my favorite ways of spotting key values in a large data stream, is greatly improved in Excel 2011. Instead of building a full chart to look for a trend in your data, you can often use a sparkline to show what you need to see in a simpler and quicker manner. One of Excel 2011вЂ™s innovative new features is sparklines, which are simply graphs of data values that appear within a single cell. Tiny, yet helpful: The new sparklines provide useful insight in a single cell. Although it doesnвЂ™t contain a ton of stock templates, you can browse a huge online template collection directly from the gallery window. Right up front, youвЂ™ll notice a new Workbook Gallery (similar to the Template Choose feature in Numbers вЂ09 ) that appears when you launch the application. Working with spreadsheetsД«eyond the visual overhaul, Excel 2011 provides many new or improved ways of working with spreadsheets and the data they hold. UI overhaul: ExcelвЂ™s new all-in-one-window interface with the Chart ribbon open. There is some lag when you live-resize windows, even on current hardware, but the delay is bearable.

For the most part these new features work quite well. A media browser provides fast access to photos, audio, movies, clip art, symbols, and shapes. SmartArt has over 150 pre-made templates (up from 80-ish), all of which you can customize. Drag-resizing a window now updates it in real time, instead of merely dragging an outline. ThereвЂ™s a full 32-bit color palette instead of 40 colors. Now each workbook has its own formula bar. For example, you previously couldnвЂ™t compare formulas between workbooks, because the formula bar existedВ onlyВ once for every open workbook. With the interface now contained in a single window, working with multiple workbooks at once is simpler. As a result, the new ExcelвЂ™s work area doesnвЂ™t feel smaller than that of the older versions. The RibbonвЂ™s tabs are compact, and the Ribbon itself can collapse to a single row of tabs when not in use.

#Making drop down menus in excel for mac 2011 windows#

A couple of optional floating windows remain, but theyвЂ™re not required in most typical spreadsheet work. The Ribbon and toolbars are now integrated in each Excel window, so thereвЂ™s nothing floating around outside your workspace. For example, if you double-click an image, the Ribbon will open to a greatly improved set of image-editing commands. ItвЂ™s context sensitive, so it changes to match the task at hand. You can customize the Ribbon, or even disable it if you wish. Gone are the numerous floating toolbars and the floating formatting palette.Д®xcel 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. Some uneven performance issues and a lack of Mac-standard features, however, prevent this version from Excel from attaining perfection.Д®xcel 2011 looks much different than its 20 predecessors. The big news for power users is the return of macro support (more on that later), but thereвЂ™s good stuff to be found for Excel users of all levels. There are literally hundreds of improvements, some very noticeable, others not quite as much so. Microsoft Excel for Mac 2011 represents the largest step forward for serious Mac spreadsheet jockeys in many years, more so than either Excel 2004 ( ) or Excel 2008 ( ).