Updates
| 2007 | NUMBER OF FORMATS |
| In Excel 2003 there was a limit of 4,000 different types of formatting allowed in the same workbook. This is now unlimited. | |
| Excel 2007 supports up to 16 million colours (instead of being limited to 56). | |
| FORMAT CELLS DIALOG | |
| The position of the controls on the Border tab has changed slightly but the functionality is identical | |
| The Patterns tab has been renamed to Fill and the controls have changed | |
| SS | |
| The color palette has been removed and replaced with themes | |
| In 2003 the pattern style and colour was combined onto one drop-down. | |
| In 2007 this has been split up into two different drop-downs | |
| In 2003 you had to choose a colour from the paletter | |
| In 2007 you can choose any colour and even include a fill effect if you want | |
| The fill effects button allows you to add a fill effect | |
| The more colours button allows you to choose a colour that is not one of the theme colours | |
| CELL STYLES | |
| This has replaced the old Auto format dialog box | |
| SS | |
| Some cell styles and formatting is not supported and will be converted to the closest format. | |
| FONTS | |
| Default font is now Calibri 11 and not Arial 10. | |
| 6 modern new fonts | |
| You can use up to 512 different fonts in a workbook ? | |
| THEMES | |
| These let you change the overall design | |
| Cells can now be quickly formatting using themes and specific styles. | |
| Themes can be shared across Word and PowerPoint. | |
| A style is a pre-defined theme based format that you can apply to change the look of tables, charts, pivot tables, shapes and diagrams. | |
| SS | |
| You cannot create your own chart styles ?? | |
| LIVE PREVIEW | |
| In addition to the new gallery controls there is also a live preview to show the results of applying a feature to your document when you move the cursor over the gallery choices. | |
| This makes it very easy to experiment and a lot faster to achieve the desired results. | |
| When you hover your mouse over a gallery item you will see a preview of how that particular choice (or option) will affect your file | |
| GALLERIES | |
| A gallery opens up when you click on the more button located below any scroll bar on a tab. | |
| Each gallery is a collection of thumbnail graphics which provide you with a visual way of browsing choice (or options) | |
| Number of colours allowed increased from 56 (on colour palette) to 4.3 billion | |
| Total number of unique cell formats that can be used in a workbook increased from 4000 to 64,000 |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext