There is a Status Bar in Microsoft Excel for those who might not have noticed it. In this post, we are going to discuss how to copy values from the Status Bar in Microsoft Excel. The task is very easy to accomplish, so we do not expect most folks to have a difficult time understanding it. Now, we should point out that this is a relatively new feature for Excel, therefore, it is highly possible some users have yet to receive this update.
How to copy values from the Status Bar in Excel
To copy values from the Status Bar in Microsoft Excel, you will have to follow these steps:
- Choose your preferred Status Bar calculations
- Choose the cells to look at the calculations
- Copy the Values from the Status Bar
1] Choose your preferred Status Bar calculations
The option is there to customize what appears on the Excel Status Bar, so before we get down to the nitty-gritty of this article, you must first choose the calculations you want to work with.
- View Status Bar items: Simply right-click on the Status Bar at the bottom of your Excel document to view all available items.
- Decide what is shown on the Status Bar: The options that are ticked are the ones you’ll find on the Status Bar, so go ahead and tick your preferred calculations to ensure they show up on the Bar right now. Next, you must tick the ones you are not interested in using.
2] Choose the cells to look at the calculations
From your Excel document, you are then required to select a range of cells to view the calculations. All you have to do is press and hold the left mouse button, then drag it to highlight the cells. Finally, look to your Status Bar and you should see the relevant calculations.
3] Copy the Values from the Status Bar
Now, the calculations done via the Status Bar can be copied and pasted to your Excel document with ease. All you have to do is click on the Value and right away the information is copied to the Clipboard. Finally, then, you can choose to paste it to any cell you wish.
Overall, we find this to be a great addition to Microsoft Excel, and we suspect many professionals will be drawn to it in the near future. Hopefully, the good folks at Microsoft will release more features such as this one to improve the ease of use of Excel.
Read: Excel not scrolling smoothly or properly?
What does the status bar tell you in Excel?
OK, so the Status Bar is located at the edge of your Worksheet window, and its purpose is to showcase various information about an Excel Worksheet. The option is there to configure the Status Bar to fit your liking, but there are limits to what users can do.
Why can’t I see the Status Bar in Excel?
There are three possible conditions why the Status Bar is not showing up.
- The Excel window is not maximized, and as such, the window has been moved, effectively pushing the Status Bar below the screen.
- Maybe you’ve turned the status bar off. Run the macro code below to turn it back on.
- Did you turn off the Status Bar using a macro? Run the macro code below to turn it back on.
In order to solve the above problems, you will want to use this macro –
Sub StatusbarOn() Application.DisplayStatusBar = True End Sub.