Excel Tips……..

Customise the Quick Access Toolbar

The Quick Access Toolbar appears in the top-left corner of the Excel window in Excel 2007 and 2010. By default, it contains buttons to save your work and undo or redo/repeat the last action. You can customise what appears here, and it's a very useful place to dock your most commonly used tools.

Click the 'Office' button followed by 'Excel Options' and 'Customize' in Excel 2007. In Excel 2010, choose 'File | Options | Quick Access Toolbar'. Select a tool that you want to add in the left-hand column and click 'Add'. Change the available commands using the dropdown list labelled 'Choose commands from'. Click 'OK' to save your changes.