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

• 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