One particularly noteworthy improvement to formatting is how Styles now respond to changes within your worksheet. In Excel 2003, you could apply a "green bar" effect so that the background color in rows alternated between green and white. However, once you added a row, the pattern was interrupted, and you needed to reapply the AutoFormat, a clumsy and awkward procedure.
In Excel 2007, that same pattern is adjusted whenever you add one or more rows. (Styles are equally smart when you add columns, for patterns that alternate between columns.) Styles will even adjust when you filter or hide rows or columns.
Themes, new to Office 2007, are style collections that include a color scheme, font, fill effects and more. Shared by several Office 2007 applications, themes can be applied to charts, tables and PivotTables in Excel, giving your work a consistent look and feel. That's especially useful when you're creating a chart that you want to copy to PowerPoint or Word.
To use Themes, select the Page Layout tab and click the Themes button to choose a new theme. You can also customize any theme or create new ones. One important caveat: Be aware that Themes only work if you're using Word's new Office XML format; they won't work on old-style .xls files.
The Ribbon interface also makes it more enjoyable to work with charts. Excel's charts have a whole new look, thanks to the new graphics engine in all Office 2007 applications. The layouts use different color palettes and fonts, but the important difference is the ability to more easily apply graphical effects, such as bevels and shadows, to individual elements (such as columns or pie slices).
The Ribbon has a Chart Tools group (with tabs for Design, Layout and Format) to put more charting options at your fingertips and eliminate most of the right-clicking you had to do to adjust charts in previous versions: switching rows and columns, controlling gridlines and axes, and adding trend lines.
Excel's new table features make it less likely you'll have inconsistent formulas. Once you identify a contiguous range of cells as a table, Excel provides calculated columns. For example, if you add a column to the right of your table and enter a formula in any row, the formula will be copied to all cells in that new column, saving the time of executing a copy/paste command.
Even smarter, add a row and Excel is sure to include it in a total on the bottom row. (In previous versions of Excel, adding a row at the top or bottom of a range meant you risked omitting cells in that row from the sum formula.)
Furthermore, options on the Table Tools Design context-sensitive tab let you toggle the formatting of the first column or the first row. One click and you can add a Total row (though Excel lacks a similar command to add a Total column), then change what each column in that row computes (total, average, minimum and so on).
In addition, as you scroll down through a lengthy table, Excel replaces the column headings (the gray boxes with A/B/C above the columns) with values from the table's header row -- a subtle improvement, to be sure, but it's a more efficient technique than having to freeze rows to see column headings.
Finally, the new Table Gallery makes it easy to select and apply a sophisticated look.
- HTTP Status Code Cheat Sheet Look at the Graph, Find the Code and Boom - You're Solving Problems. Identifying and understanding common HTTP status codes can go a...
- Architects lead the next generation of data-driven applications Read this whitepaper to find out how application architects can quickly and confidently deliver long-lasting applications that minimize cost, complexity, and risk while...
- Considerations For Effective Software License Management For many reasons, software license management has become a critical issue for many IT organizations and enterprise's alike. With many licensing options, hurdles...
- eBay uses 100% OpenSource WSO2 ESB to process more than 1Billion transactions a day Along with eBay's success comes a huge demand to ensure reliable, 24x7 availability of the services that enable these transactions. For eBay, that...
- It's not too late...Get Your Mobile Questions Answered Live! How can IT provide seamless and secure mobile communications and collaboration for all? Join this live Webcast as IDG asks an expert panel...
- Why do you need an enterprise mobile platform? Today companies must offer great apps that run on a range of devices, and connect to an exploding set of backend data. Appcelerator... All Desktop Apps White Papers | Webcasts