HomeTechnologyNewsHow to Copy Status Bar Values ​​in Microsoft Excel

How to Copy Status Bar Values ​​in Microsoft Excel

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.

Selected Status Bar Calculations

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.

Status bar calculations

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.

Paste a value from the status bar

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.

Must Read

%d bloggers like this: