How to use the COUNT function in Microsoft Excel
Web agency » Digital news » How to copy values ​​from status bar in Microsoft Excel

How to copy values ​​from status bar in Microsoft Excel

Microsoft Excel's status bar lets you quickly see the average, sum, or count of selected cells. But what's better than seeing these values ​​is being able to use them. Here's how to copy directly from the status bar.

Notes: As of this writing in April 2022, the ability to copy values ​​from the status bar is slowly rolling out to Excel on Windows users starting with Office Insiders. So if you don't see the feature yet, you should soon.

Choose your status bar calculations

Since you can customize which items appear in Excel's status bar, you'll need to confirm that the ones you want to display and copy are selected.

RELATED: How to Customize and Use Status Bar in Excel

Right-click on the status bar in Excel to see available items. Those that are checked are those visible in the status bar. So if you want to see the average, for example, be sure to select it to put that checkmark next to it.

Calculations selected in the status bar

Select cells to display calculations

Calculations like average, sum, minimum, maximum, and others only appear in the status bar when they apply. This means that you will need to select the cells in your sheet to display these calculations.

RELATED: How to calculate the mean in Microsoft Excel

Select a range of cells and when you look at the status bar you will see the values ​​of the calculations you have selected.

Status bar calculations

Copy values ​​from status bar

Once you have selected the cells and seen the calculations at the bottom, just click on the desired value in the status bar. This puts it in your clipboard. You can then paste it directly into your sheet or another application.

RELATED: How to Paste Text Without Formatting Almost Anywhere

To paste it into your spreadsheet, select the cell where you want the value, then 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.

Paste a value from the status bar

Sometimes small updates to the apps we use daily like Microsoft Excel are the best. This handy feature makes adding calculations to your spreadsheets easier than ever.

★ ★ ★ ★ ★