One really disconcerting change to Excel 2007 is the disappearance of the toolbars. Features you use all the time seem to have disappeared back to into the menus.
People with prior versions of Excel usually have two toolbars permanently on display – Standard and Formatting.
Your Standard Toolbar has now been replaced by the Quick Access toolbar.
When you install Excel 2007, the Quick Access toolbar appears at the top of the screen. It only contains one or two icons such as Save, Undo and Redo, and is easy to overlook.
When Excel 2007 is installed, the Quick Access toolbar is virtually empty. Fill it up immediately so that it becomes equivalent to your Standard toolbar
To do this, right click anywhere on the ribbon, select Customise Quick Access toolbar. Add these icons:
Insert Sheet Rows, Insert Sheet Columns, New, Print Preview, AZ, ZA.
In fact, you can add ANY icon to your Quick Access toolbar by simply right clicking on it.
Add the Autosum (big sigma) icon this way. Go into Home - find the Sigma at far right - right click on it – Add to the Quick Access toolbar.
Related material in ExcelZone
Excel 2007 tips - find your way around the new version
Excel 2007 - Get ahead with conditional formatting
Excel 2007 Tables - Not just a pretty format
Excel 2007 - A new approach to PivotTables
Excel 2007 SUMIFS(): The accountant's favourite Excel function gets an overhaul
New Range Name features in Excel 2007
Focus on Excel 2007
The Excel Compendium - Excel 2007
Subscribe to the ExcelZone newswire
To keep up with all our Excel 2007 news, tips and tutorials, click the graphical button to subscribe to the free fortnightly ExcelZone newswire. The subscribe function will take you back to the AccountingWEB home page after it adds your name to the subscription list.