Tip of the Day | Monday November 24th, 2025

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

Copy Average of Selected Cells to Clipboard

This tool copies the calculated average of the visible cells in your selection directly to the clipboard.

Use this when you want to:

Get the average of visible values without inserting a formula

Exclude hidden or filtered-out data from the calculation

Paste the result into other applications (e.g., Word, Outlook, Teams)

Note:
In 2024, Excel introduced the ability to copy averages from the status bar. However, that average includes values in hidden columns and manually hidden rows. Our tool calculates the average using only visible cells, making it more accurate when working with filtered or partially hidden data.

Starting this tool

Click ASAP Utilities › Export › 7. Copy Average of Selected Cells to Clipboard
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Export › Copy Average of Selected Cells to Clipboard

Choose your language preference below

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Yesterday's Tip

Tomorrow's Tip

Download

©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.