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 |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext