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?
This 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:
- Make sure that you have some numbers/data in your spreadsheet
- Select/highlight the numbers that you want to know something about
- Highlighting these will bring up information in the Status Bar. This could be the SUM, AVERAGE, MAX, etc.
- Hovering your cursor over these will bring up a message saying that you can click to copy the value
- Click on the option that you want on the Status Bar. This will copy it to the clipboard
- You can now click on the cell that you want the value in and paste it
- 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?