--- description: If you want to quickly get the data size of each worksheet in an Excel workbook, you can refer to this article. Here we will share 2 handy methods with you. title: 2 Quick Ways to Get the Data Size of Each Worksheet in an Excel Workbook image: https://www.datanumen.com/blogs/wp-content/uploads/2018/06/copy-sheet.jpg --- - - - [Home](https://www.datanumen.com/blogs/) > [Solutions](https://www.datanumen.com/blogs/category/solutions/) > [Office Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/) > [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) > 2 Quick Ways to Get the Data Size of Each Worksheet in an Excel Workbook # 2 Quick Ways to Get the Data Size of Each Worksheet in an Excel Workbook [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) September 28, 2025 Share Now: - - - - - - - - *If you want to quickly get the data size of each worksheet in an Excel workbook, you can refer to this article. Here we will share 2 handy methods with you.* At times, when dealing with an Excel workbook which consists of a great amount of worksheets, you may want to get the data size of each worksheet. However, there is not a native feature for this requirement. So, you need to use some workarounds, such as the following Method 1. Or you can use the much smarter Method 2 to get all worksheets’ data sizes in bulk. ## Method 1: Get Worksheet Data Size One by One Manually 1. At first, open the specific Excel workbook. 2. Then, copy the contents of an Excel worksheet.![Copy Sheet Contents](https://www.datanumen.com/blogs/wp-content/uploads/2018/06/copy-sheet.jpg "Copy Sheet Contents") 3. Next, create a new workbook and paste the copied worksheet into Sheet 1.![Paste Copied Worksheet]( "Paste Copied Worksheet") 4. Later, save the new workbook to a Windows folder.![Save New Workbook]( "Save New Workbook") 5. Lastly, you can check the new workbook’s data size, equal to the worksheet’s data size, in Windows Explorer, as shown in the following screenshot.![Get Data Size in Windows Explorer]( "Get Data Size in Windows Explorer") 6. Now, you can use this way to get the data sizes of other worksheets one by one. ## Method 2: Batch Get the Data Sizes of All Worksheets via VBA 1. To begin with, open the Excel VBA editor according to “ [How to Run VBA Code in Your Excel](https://www.datanumen.com/blogs/how-to-run-vba-code-in-your-excel/)“. 2. Then, put the following code into a project or module. ``` Sub GetEachWorksheetSize() Dim strTargetSheetName As String Dim strTempWorkbook As String Dim objTargetWorksheet As Worksheet Dim objWorksheet As Worksheet Dim objRange As Range Dim i As Long Dim nLastEmptyRow As Integer strTargetSheetName = "Sheet Sizes" strTempWorkbook = ThisWorkbook.Path & "\Temp Workbook.xls" With ActiveWorkbook.Worksheets.Add(Before:=Application.Worksheets(1)) .Name = strTargetSheetName .Cells(1, 1) = "Sheet" .Cells(1, 1).Font.Size = 14 .Cells(1, 1).Font.Bold = True .Cells(1, 2) = "Size" .Cells(1, 2).Font.Size = 14 .Cells(1, 2).Font.Bold = True End With Set objTargetWorksheet = Application.Worksheets(strTargetSheetName) For Each objWorksheet In Application.ActiveWorkbook.Worksheets If objWorksheet.Name <> strTargetSheetName Then objWorksheet.Copy Application.ActiveWorkbook.SaveAs strTempWorkbook Application.ActiveWorkbook.Close SaveChanges:=False nLastEmptyRow = objTargetWorksheet.Range("A" & objTargetWorksheet.Rows.Count).End(xlUp).Row + 1 With objTargetWorksheet .Cells(nLastEmptyRow, 1) = objWorksheet.Name .Cells(nLastEmptyRow, 2) = FileLen(strTempWorkbook) End With Kill strTempWorkbook End If Next End Sub ``` ![VBA Code - Get the Data Size of Each Worksheet in an Excel Workbook]( "VBA Code - Get the Data Size of Each Worksheet in an Excel Workbook") 3. After that, press “F5” to run this macro right away. 4. Eventually, after macro finishes, back to the workbook. 5. You’ll see a new worksheet at the very beginning, which contains the size of each worksheet, like the following image.![New Sheet with Size Information]( "New Sheet with Size Information") ## Comparison |   | **Advantages** | **Disadvantages** | | --- | --- | --- | | **Method 1** | Easy to operate | Too troublesome if there are too many worksheets in the current workbook | | **Method 2** | Easy and convenient no matter how many worksheets exist in the workbook | Perhaps the above VBA code is a bit incomprehensible for newbies | ## Fix Exasperating PST Issues Users can encounter all kinds of disturbing troubles in MS Excel, ranging from unexpected shutdown or restart to severe [xlsx corruption](https://www.datanumen.com/excel-repair/). Unquestionably, the most knotty problem is damaged Excel file in that it cannot be resolved easily. It demands you to apply an external Excel fix tool, like DataNumen Excel Repair. ## Author Introduction: Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including [corrupt SQL Server](https://www.datanumen.com/sql-recovery/) and outlook repair software products. For more information visit [www.datanumen.com](https://www.datanumen.com/) Share Now: - - - - - - - - [← Previous post](https://www.datanumen.com/blogs/how-to-batch-save-all-attachments-in-an-outlook-task-to-a-windows-folder/) [Next post →](https://www.datanumen.com/blogs/6-handy-solutions-when-windows-gets-stuck-on-resetting-this-pc/) Comments are closed. ![Data Recovery Blog]() Follow or like us on Facebook, LinkedIn and Twitter to get all promotions, latest news and updates on our products and company. - - - ### Featured Products - [DataNumen Outlook Repair](https://www.datanumen.com/outlook-repair/) - [DataNumen SQL Recovery](https://www.datanumen.com/sql-recovery/) - [DataNumen Exchange Recovery](https://www.datanumen.com/exchange-recovery/) - [DataNumen Access Repair](https://www.datanumen.com/access-repair/) - [DataNumen Excel Repair](https://www.datanumen.com/excel-repair/) - [DataNumen PDF Repair](https://www.datanumen.com/pdf-repair/) - [DataNumen Word Repair](https://www.datanumen.com/word-repair/) - [DataNumen Zip Repair](https://www.datanumen.com/zip-repair/) ### Popular posts ```json {"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.datanumen.com\/blogs\/2-quick-ways-to-get-the-data-size-of-each-worksheet-in-an-excel-workbook\/#article","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/2-quick-ways-to-get-the-data-size-of-each-worksheet-in-an-excel-workbook\/"},"author":{"name":"AuthorCCW","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957"},"headline":"2 Quick Ways to Get the Data Size of Each Worksheet in an Excel Workbook","datePublished":"2018-06-06T02:53:51+00:00","dateModified":"2025-09-28T14:15:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/2-quick-ways-to-get-the-data-size-of-each-worksheet-in-an-excel-workbook\/"},"wordCount":411,"commentCount":11,"publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/2-quick-ways-to-get-the-data-size-of-each-worksheet-in-an-excel-workbook\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2018\/06\/copy-sheet.jpg","articleSection":["Excel Solutions"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.datanumen.com\/blogs\/2-quick-ways-to-get-the-data-size-of-each-worksheet-in-an-excel-workbook\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.datanumen.com\/blogs\/2-quick-ways-to-get-the-data-size-of-each-worksheet-in-an-excel-workbook\/","url":"https:\/\/www.datanumen.com\/blogs\/2-quick-ways-to-get-the-data-size-of-each-worksheet-in-an-excel-workbook\/","name":"2 Quick Ways to Get the Data Size of Each Worksheet in an Excel Workbook","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/2-quick-ways-to-get-the-data-size-of-each-worksheet-in-an-excel-workbook\/#primaryimage"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/2-quick-ways-to-get-the-data-size-of-each-worksheet-in-an-excel-workbook\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2018\/06\/copy-sheet.jpg","datePublished":"2018-06-06T02:53:51+00:00","dateModified":"2025-09-28T14:15:08+00:00","description":"If you want to quickly get the data size of each worksheet in an Excel workbook, you can refer to this article. Here we will share 2 handy methods with you.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.datanumen.com\/blogs\/2-quick-ways-to-get-the-data-size-of-each-worksheet-in-an-excel-workbook\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/2-quick-ways-to-get-the-data-size-of-each-worksheet-in-an-excel-workbook\/#primaryimage","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2018\/06\/copy-sheet.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2018\/06\/copy-sheet.jpg","width":776,"height":354,"caption":"Copy Sheet Contents"},{"@type":"WebSite","@id":"https:\/\/www.datanumen.com\/blogs\/#website","url":"https:\/\/www.datanumen.com\/blogs\/","name":"Data Recovery Blog","description":"Discuss every aspect of data recovery","publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.datanumen.com\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.datanumen.com\/blogs\/#organization","name":"Data Recovery Blog","url":"https:\/\/www.datanumen.com\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","width":296,"height":397,"caption":"Data Recovery Blog"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataNumen","https:\/\/x.com\/DataNumen","http:\/\/www.linkedin.com\/company\/datanumen","https:\/\/myspace.com\/datanumen\/","http:\/\/www.pinterest.com\/datanumen\/","https:\/\/www.youtube.com\/channel\/UCVIIuuKfUBHSJauUaVP13tw"]},{"@type":"Person","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957","name":"AuthorCCW","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","caption":"AuthorCCW"},"sameAs":["https:\/\/www.datanumen.com\/"]}]} ```