Why Excel VSTACK and HSTACK Are Missing in Office Home and Business 2021
Question details
The user needs to understand why the VSTACK and HSTACK functions are unavailable in Excel included with Office Home and Business 2021.
- Product
- Microsoft Office Home and Business 2021
- Device & OS
- not provided
- Scenario
- The user wants to combine ranges vertically or horizontally with VSTACK or HSTACK in Excel.
- Observed behavior
- Excel in Office Home and Business 2021 does not recognize or provide the VSTACK and HSTACK functions.
Confirm that your Excel license is Office Home and Business 2021 rather than a Microsoft 365 subscription. Check the version in Excel by selecting File > Account > About Excel.
Use Microsoft 365 or Excel for the web for VSTACK and HSTACK
Use this option when you need the native VSTACK and HSTACK functions, which were introduced after the perpetual Office 2021 release.
Office Home and Business 2021 is a perpetual-release product and does not receive every new Excel function released to Microsoft 365. VSTACK and HSTACK are available in supported Microsoft 365 Excel builds and Excel for the web.
In Excel, select File > Account and review Product Information. If it says Office Home and Business 2021, VSTACK and HSTACK are not included in that edition.
Go to Office.com, sign in with a Microsoft account, select Excel, and open or upload the workbook. Enter =VSTACK(...) or =HSTACK(...) in a worksheet cell.
Install and sign in to a Microsoft 365 version of Excel, then select File > Account > Update Options > Update Now to receive supported feature updates.
Use compatible formulas in Office Home and Business 2021
Use this option when you must keep using Excel 2021 and can recreate the result with manual range placement or older functions.
Work with Excel-compatible spreadsheets in WPS Office
If your current Microsoft Office 2021 installation lacks the functions or update channel you need, WPS Office provides a free, lightweight spreadsheet suite with a familiar interface. Open and edit your existing workbooks, review formula compatibility, and move between Office files with minimal disruption.
Frequently Asked Questions
Can I add VSTACK and HSTACK to Office Home and Business 2021 through updates?
No. VSTACK and HSTACK were released after Office 2021 and are not part of its perpetual feature set. File > Account > Update Options can update Office 2021, but it will not add these functions.
Which Excel versions support VSTACK and HSTACK?
These functions are available in supported Microsoft 365 versions of Excel and Excel for the web. They are not included in Office Home and Business 2021.
Why does a workbook show #NAME? for VSTACK or HSTACK in Excel 2021?
#NAME? appears because Excel 2021 does not recognize VSTACK or HSTACK as valid function names. Open the workbook in Excel for the web or a supported Microsoft 365 Excel version, or replace the formula with a compatible method.
What can I use instead of VSTACK in Excel 2021?
For a one-time result, copy each source range below the previous range. For repeatable table combinations, use Data > Get Data > From Table/Range and then choose Home > Append Queries in Power Query.
Will Excel for the web change my Office Home and Business 2021 installation?
No. Excel for the web runs in a browser and does not alter your installed Office 2021 apps. You can open the workbook online to use web-supported functions.
