|
Excel 2007 includes several new and improved features that make it much easier for you to preview and apply formatting to your spreadsheets. These include Live Preview, style galleries, and additions and enhancements to cell styles.
Live Preview
The new Live Preview feature in Excel 2007 enables you to format worksheets much easier than in previous versions. Live Preview works with all the style galleries as well as the Font and Font Size pull-down menus in the Font group on the Home tab. It enables you to see how the data in the current cell selection would look with a particular formatting, font, or font size before you actually apply the formatting to the range. All you have to do is mouse over the thumbnails in the drop-down menu or gallery to see how each of its styles will look on your actual data.
As an extra nice feature, many of the larger style galleries sport spinner buttons that enable you to bring new rows of thumbnails in the gallery into view so that you can preview their styles without obscuring any part of the cell selection (as would be the case if you actually open the gallery by clicking its More drop-down button).
 | When you see the formatting that fits your data to a tee, all you have to do is click its thumbnail to immediately apply it to the selected cell range. |
Style galleries
Excel 2007 is jammed full of different style galleries that make it a snap to apply new, sophisticated (and, in many cases, very colorful) formatting to tables and lists of data, charts, and various graphics you add to your worksheets. Coupled with the Live Preview feature, Excel's style galleries go a long way toward encouraging you to create better-looking, more colorful, and interesting spreadsheets.
Cell styles
Excel 2007 offers more than 40 colorful readymade styles, compared to only six bland cell styles offered in previous versions of Excel. These are styles you can preview in the worksheet with Live Preview to see how they look on the data before you apply them. You apply a cell style to the cell selection by quickly and easily clicking its thumbnail in the Cells Styles gallery.
| 
