OfficeTips Home || VBA Section || General Section ||  Download Section  ||  Privacy Policy

Excel formula helper

In our everyday usage of excel, we often come across a situation where we know which worksheet function to use however we don't know the function arguments properly. We therefore make use of the either the Paste function  or locate the appropriate function in the Excel Help file by pressing F1. Excel also provides another neat feature the Excel Formula Helper which saves quite a bit of time. Let us see how to use it...

Type the  name of the function like this "=IF" (Please do not include the quotation marks), press Ctrl+Shift+A. Excel will automatically display the function arguments required. Just replace these with the required cell addresses/values

 

Copyright 1999-2014 (c) Shyam Pillai. All rights reserved.