« Your Assignment: Create A Simple Invoice App
Excel Jobs »

Excel 12 Formula Autocomplete

19th October 2005, 07:18 pm by John Walkenbach

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?

Category: Excel12  |  Comment (RSS)  |  Trackback

3 Comments

  1. Mike Alexander:

    Intellisense in the formula bar is a brilliant development! Very interested to see the new formulas, if any.

    Mike

    19 October 2005, 9:28 pm

  2. Simon Murphy:

    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

    20 October 2005, 3:43 pm

  3. ross:

    “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!

    12 December 2005, 8:58 am

Certain comments are subject to moderation and may not appear immediately. You can use HTML tags in your comment. If you include a greater-than or less-than sign or anything else that could be interpreted as HTML, your comment won't look nice. You need to escape those characters. To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].

Leave a comment