Thread: Smart Tables with Microsoft Excel 2007

Since the early days of Microsoft Excel refused us tools to tables to make nice - and with a tenacity that suggests evil intentions. Charts exuded the muff of Windows 98 The color patterns offered quietschbunt made the tables. Even if you bring a little creativity, could despair of the design of an Excel spreadsheet. But that's past since Office 2007. With Office 2007, the rendering of fonts, graphics and all the documents has been improved dramatically.


The secret recipe is called "design". This is a feature that turns any table a neatly crafted document - at your fingertips. "Design" suggest how to combine colors, fonts, and effects of style. For example, if you want to change the color of a box, Excel will suggest at the top front of the colors that belong to the corresponding "design". Access to the writings that appear at first the combinations that best fit. Hard to believe but true.






Anyone who adheres to the following proposals will be rewarded with professional-looking documents. "Design" include not only fonts and colors, but all the elements of an Excel workbook, such as tables, charts and graphical forms. The trick: If you later decide for a different "design" are colored all the new elements. But it gets even better: every "design" without limitation, Word documents, PowerPoint presentations, even for mail templates in Outlook.


So you can be assured that your tables harmonize beautifully with your reports and presentations.Nevertheless, the "design" is not carved in stone. For example, if you find one that meets the terms of color appearance of your company, but used the wrong font, it can be changed with a few clicks.


The assignment of the desired "design" is one of the first actions you should perform at a new table. If you want to understand the following tips on the PC, you can create a "naked" Word 2007 template download . Click on the Ribbon of Excel Page Layout tab and displayed after the button designs A. Office, a 20 symbols, which already provide a foretaste of the different color and font combinations B. Choose one of which appeals to you. The result is sobering, because it only changes the font. But that was only the beginning.


Most of the tables does not pull back over thousands of cells, but are relatively compact structure. To improve the readability with a few clicks, you first select all the cells of the table.Now click on the ribbon bar, click the tab Start A, and then as a table format as a drop-down menu appears, which transformed the selected area radically tracks are greased, drawn lines between the cells and rows colored alternately. Now select a format and the desired color C. This opens a dialog D. Since the first line describes our marking the columns, we can leave "table has headers" on.Thus, the headline is emphasized