New Excel Status Bar Feature Coming Soon! Copying from the status bar in to Excel

New Excel Status Bar Feature Coming Soon – did you know you will be able to copy information from your Excel status bar into your spreadsheet?

New Excel Status Bar Feature: Excel iconThis week’s hint and tip is on a new Excel status bar feature coming soon. The status bar is a useful feature in Excel that a lot of people don’t realise is there. When highlighting data in your spreadsheet, it can be used to quickly find out the SUM and AVERAGE of it amongst other information. In a future update coming soon, there is an addition to this feature where you can copy information from this status bar! As this feature isn’t out yet, we decided to do a hint and tip on it. We are going to go through it now below.

 

Status Bar in Excel

The status bar in Excel can be found at the bottom of the spreadsheet and can show lots of information. You can customise what is shown on this bar so that you can decide how much information you have on it. To customise what is shown, you just right hand click onto it and a menu will come up with options that you can customise. These options will be available for you to add or remove from the bar and you will see if they are on there or not by whether there is a tick next to them.

 

Copying from the Status Bar in Excel

To use this feature, firstly make sure that you have the options you want to copy on your Status Bar. This will then allow you to copy the values that you want into a cell in your spreadsheet.

Once you have the options on the Status Bar, to use the feature follow these steps:

  1. Make sure that you have some numbers/data in your spreadsheet
  2. Select/highlight the numbers that you want to know something about
  3. Highlighting these will bring up information in the Status Bar. This could be the SUM, AVERAGE, MAX, etc.
  4. Hovering your cursor over these will bring up a message saying that you can click to copy the value
  5. Click on the option that you want on the Status Bar. This will copy it to the clipboard
  6. You can now click on the cell that you want the value in and paste it
  7. This will just paste the value, not the formula itself

 

The video below goes through how to use this function in your spreadsheet. We hope that you find the video useful and enjoy learning about it!

Take a look below at the video to find out more!

We hope you liked this hint and tip on the new Excel Status Bar feature, why not take a look at our previous one on the Excel function called UNIQUE?

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We use cookies to give you the best online experience.

Please let us know if you agree to all of these cookies.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy