Others

How to Determine the File Size of Individual Excel Worksheets

Rana Garcia Oct 19, 2026 869 views

Question details

The user wants to know how to check or calculate the exact file size of a specific worksheet within an Excel workbook.

How to Find the File Size of a Specific Excel Worksheet

Product: Microsoft Excel
Device & OS: Windows
Scenario: Trying to identify which specific tab or worksheet is taking up the most storage space in a large Excel workbook.
Observed behavior: Excel does not offer a native tool or property window to display the individual byte size of a single worksheet within a larger workbook.

Before you start

Before extracting individual worksheets to check their sizes, ensure your main Excel workbook is fully saved and review your formulas to ensure exporting a sheet won't break critical workbook links.

Solution 1Recommended

Exporting the Worksheet to a New Workbook

Since Excel cannot show sheet sizes directly, creating a standalone workbook for the sheet allows you to view its approximate file size in your system's file manager.

This manual workaround isolates the data, formatting, and objects of a single worksheet. By saving it as its own file, the operating system can calculate its storage footprint accurately.

Open the Move or Copy menu

Right-click the specific worksheet tab you want to check at the bottom of the Excel window and select 'Move or Copy' from the context menu.

Create a new workbook copy

In the 'To book' dropdown menu, select '(new book)'. Make sure to check the box next to 'Create a copy' so you don't remove the sheet from your original file, then click 'OK'.

Save the new workbook

Press Ctrl + S to save the newly created workbook. Save it to an easily accessible location, such as your Desktop, using the standard .xlsx format.

Check the file size

Open Windows File Explorer, navigate to the saved file, right-click it, and select 'Properties' to view its exact file size on disk.

Exporting the Worksheet to a New Workbook

Approximate Size Indicator: This method provides an estimated size. The sum of all individually exported sheet sizes may be slightly larger than the original multi-sheet workbook due to redundant file metadata.

WPS Spreadsheet Solution

Easily Manage and Split Large Worksheets in WPS Office

WPS Spreadsheet provides a smooth, lightweight experience for handling heavy workbooks. You can easily copy worksheets to new files to measure their sizes and optimize your document storage.

1. Open your workbook: Launch WPS Office and open your large spreadsheet file in the WPS Spreadsheet application.
2. Right-click the sheet tab: Right-click on the specific sheet tab at the bottom of the workspace and choose 'Move or Copy Sheet'.
3. Export to a new file: Select 'new book' from the dropdown, check the 'Create a copy' box, and click 'OK'.
4. Save and check size: Save the new file to your computer and check its properties in your file explorer to see the exact size of the worksheet.

Free to download and use for personal and professional tasksFully compatible with Microsoft Excel (.xlsx, .xls) formatsLightweight software that quickly handles large spreadsheets without freezing

microsoft office alternative - wps office

Frequently Asked Questions

Why is my Excel workbook file size so large?

Large file sizes are often caused by invisible data, formatting applied to entire blank columns or rows rather than just used cells, high-resolution images, hidden pivot table caches, or complex array formulas.

Is there an automated way to find the size of each Excel worksheet?

Yes, advanced users can write a VBA macro that automatically splits each worksheet into a separate temporary file, measures the size of each file, and generates a summary report within the workbook.

Does deleting a worksheet immediately reduce the Excel file size?

Yes, deleting a heavily populated worksheet will reduce the overall file size, but the size reduction will only take effect in your file explorer after you save the workbook.

Office Quick Solutions