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.

Excel Tips……..

• The clipboard can be very useful when using Excel, as you often need to cut or copy and paste information from one part of a sheet to another, or between different sheets and workbooks. The chances are that you'll need to repeatedly copy and paste different items at different times, depending on the complexity of the task in hand.
   
• You can make this easier by opening the clipboard pane as it enables you to handle multiple clipboard items at the same time. On the Home tab of the ribbon, click the arrow button to the bottom right of the Clipboard group to toggle it open or closed.