'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Copy Sum or Average Missing from Excel Status Bar
Question details
The user is unable to copy calculation values like Sum or Average directly from the Excel status bar in their organization's Microsoft 365 installation.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Trying to quickly copy quick calculation values (Sum, Average, Count) from the bottom status bar in Excel without using formulas.
- Observed behavior
- The feature is unavailable or missing, often due to the specific Microsoft 365 update channel (e.g., Semi-Annual Channel) configured by the organization.
Verify your current Microsoft Office version and update channel by going to File > Account in Excel to understand which feature set you are currently assigned.
Request a Switch to the Microsoft 365 Current Channel
The copy from status bar feature is available to Current Channel users. Switching from the Semi-Annual Channel will restore this functionality.
Microsoft rolls out features based on specific update channels. If your organization relies on the Semi-Annual Enterprise Channel, newer features like copying from the status bar may be delayed or unavailable until a broader release.
Reach out to your organization's IT department or Microsoft 365 administrator to request an update channel change.
Ask them to change your Microsoft 365 update channel from 'Semi-Annual Enterprise Channel' to 'Current Channel'.
Once the change is approved and processed, open Excel and navigate to File > Account.
Click 'Update Options' and select 'Update Now' to download the latest Current Channel features.
Restart Excel, select a range of numbers, and left-click the Sum or Average on the status bar to verify it copies to your clipboard.
Use Standard Formulas to Copy Values
If you cannot change your update channel, you can temporarily use standard Excel formulas to generate the values for copying.
Try WPS Office for a Hassle-Free Spreadsheet Experience
If you are tired of missing out on handy features due to confusing Microsoft 365 update channel restrictions, WPS Office provides a lightweight, fully-featured alternative.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install and Open: Run the installer, open WPS Spreadsheet, and easily open your existing Excel files.
- 3. Calculate and Manage Data: Use standard formulas and real-time status bar summaries to manage your calculations without enterprise version limitations.
Frequently Asked Questions
Why did the status bar copy feature suddenly disappear from my Excel?
This often happens if your organization recently rolled back an update or switched your Microsoft 365 installation from the Current Channel to the Semi-Annual Channel, where the feature might not yet be fully deployed.
When was the feature to copy Sum and Average released?
The feature was initially available to Office Insiders in May 2021 (Version 2104) and officially released to the general Current Channel on June 29, 2022.
Can I manually add the copy feature to the status bar?
No, the ability to copy by clicking the status bar is a built-in feature dependent on your software version. You can customize which metrics appear (like Sum or Average) by right-clicking the status bar, but copying requires the correct Office update channel.
How do I check which Microsoft 365 channel I am on?
Open Excel, click on 'File' in the top-left corner, and select 'Account'. Under the 'About Excel' section on the right side, you will see your version, build number, and current update channel.
