Tips for using Microsoft Excel

Search through the list below to find a tip that will help you use Microsoft Excel:

• Filtering unique entries
• See the limits of a selected range
• Scroll wheel and the ribbon
• Exit Excel 2007
• Data validation error
• Zoom selection
• Fraction format
• Colour code sheet tabs
• Data entry shortcut
• Hiding gridlines
• Wrapping text
• Linking content
• Data forms
• File pinning
• Cell drop down
• Page break view
• Drawing tools
• Using dates in headings
• Merge and centre warning
• Flow charts
• Customise colours
• Formula bar extended
• Calculate part of a formula
• Go to dialog
• Dragging weekdays only
• Name box extension
• ABS
• Ctrl + Enter
• Format painter
• See all menu options
• The F4 function key
• The Alt + Enter method
• Double click shortcuts
• Create an organisation chart

View more tips on how to use Microsoft Excel, taken from the regular Excel Yourself column in INTHEBLACK.

Neale Blackwood is a senior business analyst with Access Analytic Solutions, which provides financial modelling, management reporting services as well as advanced Excel training. You can email Neale at nblackwood@accessanalytic.com.au

This page is available online at:
http://www.cpaaustralia.com.au/cps/rde/xchg/cpa/hs.xsl/877_28580_ENA_HTML.htm