Finding the Size of Individual Worksheets in Excel

Have you ever found yourself wondering how much space each worksheet in your Excel workbook is taking up? Whether you’re working with a large dataset or just trying to optimize your file size, knowing the size of individual worksheets can be incredibly helpful. In this article, we’ll explore how to find the size of individual worksheets in Excel.

Step 1: Open the File Explorer

The first step is to open the File Explorer on your computer. You can do this by clicking on the folder icon in your taskbar or by pressing the Windows key + E on your keyboard.

Step 2: Navigate to the Excel File

Next, navigate to the Excel file that you want to check the worksheet sizes for. Once you’ve found the file, right-click on it and select “Properties” from the dropdown menu.

Step 3: Check the File Size

In the Properties window, you’ll see a tab labeled “General.” Click on this tab to view the file size. This will give you the total size of the Excel file, including all of the worksheets within it.

Step 4: Open the Excel File

Now that you know the total size of the Excel file, it’s time to open it up and check the size of individual worksheets. Double-click on the Excel file to open it in Excel.

Step 5: Check the Size of Individual Worksheets

Once you’ve opened the Excel file, navigate to the worksheet that you want to check the size of. Right-click on the worksheet tab and select “Move or Copy” from the dropdown menu.

In the “Move or Copy” window, you’ll see a checkbox labeled “Create a copy.” Make sure this checkbox is unchecked, then click on the “OK” button.

Next, right-click on the worksheet tab again and select “Rename” from the dropdown menu. In the “Rename” window, add the word “Temp” to the beginning of the worksheet name and click on the “OK” button.

Now, navigate back to the File Explorer and right-click on the Excel file again. Select “Properties” from the dropdown menu.

In the Properties window, click on the “Summary” tab. Here, you’ll see a section labeled “Total Editing Time.” The number listed here represents the size of the worksheet you just renamed with “Temp” at the beginning.

Repeat for Other Worksheets

To check the size of other worksheets in the Excel file, simply repeat the process above for each worksheet. Remember to rename each worksheet with “Temp” at the beginning before checking its size in the Properties window.


Knowing the size of individual worksheets in your Excel file can be incredibly helpful for optimizing your file size and managing large datasets. By following the steps above, you can easily check the size of each worksheet in your Excel file and make informed decisions about how to manage your data.


Did you find this article useful?

Share it with your friends or colleagues

About Aepoch Advisors

We are a boutique accounting and consulting firm servicing international businesses operating in China. We offers book keeping and business advisory service. We also help our clients select and implement SAAS business applications
Cloud technology significantly reduces cost foreign companies traditionally spent on tax compliance and ERP systems. Our cloud professionals can help with streamlining your management and controling structure, as well as advising you on how to reduce risks and maximize profits with software purposely built for Chinese business. Contact us today to learn more about our services.