Help snippets directly in spreadsheets
You shouldnât have to interrupt your work to figure out how to build a particular formula, which is why weâre bringing help documentation directly into Google spreadsheets.
As soon as you start typing a formula into a cell, youâll notice an auto-suggest box with the name and syntax of the function you might be looking for. Mouse over any of the suggested functions, and youâll see a description that explains the function, its syntax, and how itâs used. Youâll also see links to related content and a link to the complete list of functions.
Auto-suggest displays syntax and help documentation for all 300+ available functions and even recognizes nested functions, making it easier to build complex formulas.
Revamped help documentation in the Google Docs Help Center
Weâve also completely rebuilt our help documentation for Google spreadsheet functions with invaluable input from some of our most active forum users such as ahab, yogia1, Ted J, A.P.L, MarinusP, and other forum Top Contributors. Hereâs a look at whatâs new:
- A completely new table for browsing help documentation for all 300+ Google spreadsheets functions. This table is easy to browse, sort or search. To view the table, you can visit the Google Docs Help Center, click the complete list of functions link in the auto-suggest help snippets, or select Help > Function list in any Google spreadsheet.
- Help documentation for nearly 60 new functions and formulas.
- More detailed help documentation, including better instructions for some of our most sophisticated and complex functions.
Posted by: Michael Schidlowsky, Software Engineer