Excel 12 Formula Autocomplete

Did you see the latest entry at David Gainer’s blog? Formula Autocomplete.

Finally, it will be possible to write a SUBTOTAL formula without consulting the Help! But one of the commenters makes a good point about the SUBTOTAL function:

So… please help me understand why you’re using a function number rather than just the name of a function. When we’re skimming through a sheet, or looking at a print out of formula view, we’ll have to have learned which numbers refer to which functions, won’t we? Or am I missing the point completely?

Posted in Uncategorized

3 thoughts on “Excel 12 Formula Autocomplete

  1. A meaningful string would be nice but it needs to stay a number for backward compatibility – otherwise open an Excel 12 wb in a previous version and subtotals would fail.
    cheers
    simon

  2. “A meaningful string would be nice but it needs to stay a number for backward compatibility – otherwise open an Excel 12 wb in a previous version and subtotals would fail.”

    yeah but when the work book was save in a old format excel could convert the formula!


Posting code? Use <pre> tags for VBA and <code> tags for inline.

Leave a Reply

Your email address will not be published. Required fields are marked *