Flash Fill in Microsoft Excel
GPTKB entity
Statements (25)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
gptkb:software
|
| gptkbp:activatedBy |
Ctrl+E shortcut
Data tab > Flash Fill |
| gptkbp:category |
data manipulation
productivity tool |
| gptkbp:developer |
gptkb:Microsoft
|
| gptkbp:documentation |
https://support.microsoft.com/en-us/office/using-flash-fill-in-excel-3f2e4da7-0dce-4b94-8c5b-2d9b6b6b6bc5
|
| gptkbp:function |
automatically fills in values based on patterns
|
| https://www.w3.org/2000/01/rdf-schema#label |
Flash Fill in Microsoft Excel
|
| gptkbp:introducedIn |
gptkb:Excel_2013
|
| gptkbp:limitation |
does not update dynamically
may not recognize complex patterns |
| gptkbp:partOf |
gptkb:Microsoft_Excel
|
| gptkbp:platform |
gptkb:Windows
Mac (limited support) |
| gptkbp:relatedTo |
gptkb:Power_Query
Formulas Text to Columns |
| gptkbp:requires |
pattern recognition
|
| gptkbp:uses |
combining columns
extracting substrings formatting data splitting columns |
| gptkbp:bfsParent |
gptkb:Sumit_Gulwani
|
| gptkbp:bfsLayer |
6
|