Microsoft Excel’s status bar allows you to quickly see the average, sum, or count of selected cells. But what better than visualizing those values is being able to use them. This is how you copy directly from the status bar.
Note: As of this writing in April 2022, the ability to copy status bar values is slowly rolling out to Excel for Windows users, starting with Office Insiders. So if you don’t see the feature yet, you should soon.
Choose your calculations from the status bar
Because you can customize the items that appear on the Excel status bar, you’ll need to confirm that the items you want to view and copy are selected.
RELATED: How to customize and use the status bar in Excel
Right click on the status bar in Excel to see the available items. The ones with check marks are the ones visible on the Status Bar, so if you want to see the average, for example, make sure you select it to put that check mark next to it.
Select cells to view calculations
Calculations such as average, sum, minimum, maximum, and others are only displayed in the status bar when applied. This means that you will need to select the cells on your sheet to display those calculations.
RELATED: How to Calculate Average in Microsoft Excel
Select a range of cells, and when you look down at the status bar, you’ll see the values for the calculations you’ve selected.
Copy the values from the status bar
Once you select the cells and see the calculations at the bottom, just click the value you want in the status bar. This will put it on your clipboard. You can then paste it directly into your sheet or another app.
RELATED: How to Paste Raw Text Almost Anywhere
To paste it into your spreadsheet, select the cell where you want the value, and then do one of the following:
- Right-click and select “Paste.”
- Go to the Home tab and click “Paste” in the Clipboard section of the ribbon.
- Use the keyboard shortcut Ctrl + V.
Sometimes the little updates to the applications we use every day, like Microsoft Excel, are the best. This handy feature makes it easier than ever to add calculations to your spreadsheets.