How to Copy Sum from Status Bar in Excel (With Easy Steps)

Microsoft Excel has a tremendous feature to collect data without applying any formulas which are the status bar. A status bar in excel helps you visualize and gather data like sum, average, minimum, and maximum from the bar. You just have to copy data from the status bar in the excel workbook. In this article, I am going to share with you how to copy sum from status bar in excel.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


What Is the Status Bar in Excel?

The status bar in excel displays data at the bottom area for the worksheet or selected cells. It can also be customized according to the user’s choice of which values the user wants to be displayed. It actually gives a short description of the current page number, the sum of selected cells, average values, count of cells, etc. A user can customize the status bar just by clicking the right button on the mouse holding the arrow over the bar. Various data will be shown in the new window. Just check mark the option to get a shortcut view at the status bar.


Step-by-Step Procedures to Copy Sum from Status Bar in Excel

In this following article, I am describing a step-by-step procedure to copy the sum from the status bar in excel. Suppose, we have a dataset with some Employee Names in our workbook. Now, we will collect their Sales Volume and copy the Total Sales Volume from the status bar.

Copy Sum from Status Bar in Excel


Step 1: Prepare Dataset

  • Firstly, we will prepare the dataset by collecting the sales volume every month.
  • Here, we have “Sales of January” for each employee.

  • Similarly, we collected sales data for February and March.

  • After collecting all the data, the final dataset will look like the below screenshot.

Copy Sum from Status Bar in Excel


Step 2: Make SUM Data Visible in Excel Status Bar

  • Although after selecting data from the table you won’t find the desired value in the status bar.
  • Generally, this can be solved just by clicking the right button of the mouse and holding the cursor over the status bar.

Copy Sum from Status Bar in Excel

  • Later, A new window will pop up with options.
  • Hence, checkmark an option of your choice. Here, I have selected “Sum” to view in the bar.


Step 3: Copy the Data to Clipboard

  • Therefore, after selecting cells the total sum value of those chosen cells will appear in the status bar.
  • Later, select the value by left-clicking the mouse button and it will be automatically copied.

Copy Sum from Status Bar in Excel


Step 4: Paste the Value into Excel Sheet

  • Finally, choose a cell in your workbook. In this workbook, I have selected cell (C11).
  • Hence, Press Ctrl+V to paste the sum value.

  • As a result, we have successfully copied the sum value from the status bar in our desired cell.

Copy Sum from Status Bar in Excel


Things to Remember

  • As you can customize the data which appears in the status bar, you must choose the proper item from the list by right-clicking on the status bar.

Conclusion

In this article, I have tried to cover all the simple steps to copy sum from status bar in Excel. Take a tour of the practice workbook and download the file to practice by yourself. Hope you find it useful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.

Wasim Akram

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo