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-2018 (c) Shyam Pillai. All rights reserved.