EXPAND Function in Excel: Syntax, Examples and Free Practice
EXPAND is an Excel Lookup & Reference function. Expands an array to a specified size, padding with a chosen value.
EXPAND syntax
Arguments
array: The range or array to evaluaterows: How many rows to return or generatecolumns: How many columns to return or generate (optional)pad_with: The value used to fill any extra space (optional)
When to use EXPAND
EXPAND is used to pull matching data from one part of a workbook into another.
Practice EXPAND online, free
Open the live Excel-style spreadsheet and try EXPAND yourself. No Excel install or sign-up needed to start.
Practice EXPAND now →More Lookup & Reference functions
Frequently asked questions
What does the EXPAND function do in Excel?
Expands an array to a specified size, padding with a chosen value.
What is the syntax of EXPAND in Excel?
The syntax is =EXPAND(array, rows, [columns], [pad_with]). array: The range or array to evaluate; rows: How many rows to return or generate; columns: How many columns to return or generate (optional); pad_with: The value used to fill any extra space (optional).
Where can I practice EXPAND online for free?
Open the free live spreadsheet on Cellgrids and try EXPAND yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Lookup and Reference functions · Excel case studies · Excel tutorials · Excel shortcuts