With the status bar in Microsoft Excel, you can quickly see the average, sum, or number of selected cells. But what could be better than looking at those values, being able to use them. Here’s how to copy directly from the status bar.
Remark: At the time of writing in April 2022, the ability to copy values from the status bar is slowly rolling out to Excel for Windows users, starting with Office Insiders. So if you don’t see the feature yet, you need to do it soon.
Choose your status bar calculations
Because you can customize the elements that appear in the Excel status bar, you must confirm that the elements you want to view and copy are selected.
RELATED: 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 in the status bar. So, for example, if you want to see the average, make sure you select it to put that check next to it.
Select the cells to view the calculations
Calculations such as average, sum, minimum, maximum, and others are only displayed in the status bar if they are applicable. This means that you must select the cells in your worksheet to display those calculations.
RELATED: How to Calculate Average in Microsoft Excel
Select a range of cells, and if you look at the status bar, you’ll see the values for the calculations you’ve selected.
Copy the status bar values
After you select the cells and see the calculations at the bottom, simply click on the desired value in the status bar. This will put it on your clipboard. You can then paste it directly into your sheet or other application.
RELATED: Paste text without formatting almost anywhere
To paste it into your spreadsheet, select the cell where you want the value and do one of the following:
- Right click and choose ‘Paste’.
- Go to the Home tab and click “Paste” in the Clipboard section of the ribbon.
- Use the keyboard shortcut Ctrl+V.
Sometimes small updates to applications we use every day, like Microsoft Excel, are the best kind. This handy feature makes it easier than ever to add calculations to your spreadsheets.