How to Check and Reduce Excel File Size: View Workbook Size and Details

Large Excel files open slowly, save poorly, and can crash. The file size grows from data, formatting, and hidden objects. This article explains how to find the file size and what makes it large.

You will learn to check the workbook size using Windows Explorer and Excel’s built-in tools. The steps will show you how to reduce the file size by removing unnecessary elements.

Understanding What Makes an Excel File Large

An Excel file is a container holding more than just the data you see. Every element adds to the total file size. The main contributors are worksheet data, cell formatting, and objects like charts or images.

Formulas, especially volatile ones like OFFSET or INDIRECT, require more memory than static values. PivotTable caches store data separately, which can duplicate information. The “used range” of a sheet often extends beyond your actual data due to deleted content or formatting applied to entire columns.

Common Size Contributors

High-resolution images and embedded objects are major culprits. Each image is stored in full within the file. Excessive cell formatting, such as different fonts or borders applied across thousands of rows, also adds significant overhead. External data connections and query definitions remain in the file even if the data is not currently loaded.

Steps to Check Your Excel File Size

You can check the file size from outside Excel or from within the application itself. The external method gives you the exact size on disk. The internal method is convenient while working.

Method 1: Check Size in Windows File Explorer

1. Save and close your Excel workbook
   Ensure all changes are saved and the file is closed in Excel.
2. Navigate to the file location
   Open File Explorer and find the folder containing your Excel file.
3. View file details
   Right-click the file and select Properties. The General tab shows the exact Size and Size on disk in kilobytes or megabytes.

Method 2: Check Size Within Excel

1. Open the Info pane
   With the workbook open, click File > Info. The right panel displays basic file properties.
2. View the size property
   Look under the Related Dates section. The Size property shows the current file size. This updates after you save.
3. Use the Workbook Analysis tool
   Go to the File tab, click Options, and select Add-ins. At the bottom, choose COM Add-ins from the Manage list and click Go. Check the box for Inquire and click OK. A new Inquire tab will appear on the ribbon. Click Inquire > Workbook Analysis to generate a detailed size report.

Steps to Reduce Excel File Size

1. Find and reset the last used cell
   Press Ctrl + End to jump to the last cell Excel recognizes as used. If this cell is far beyond your real data, select all rows below your data, right-click, and choose Delete. Do the same for columns to the right. Save the file.
2. Clear unused formatting
   Select the entire sheet by clicking the corner button between row 1 and column A. On the Home tab, click Clear > Clear Formats. Reapply formatting only to the cells that need it. This removes hidden formatting that increases file size.
3. Compress pictures
   Click on any picture in your workbook. The Picture Format tab appears. Click Compress Pictures. In the dialog box, uncheck Apply only to this picture to compress all images. Choose a lower resolution like Web (150 ppi) and click OK.
4. Remove unnecessary PivotTable cache
   Right-click on a PivotTable and select PivotTable Options. In the Data tab, uncheck Save source data with file. Click OK. For multiple PivotTables from the same source, consider sharing the cache.
5. Save the file in the binary format
   Click File > Save As. Choose a location, then click the Save as type dropdown. Select Excel Binary Workbook (*.xlsb). Click Save. This format is often significantly smaller and retains all features.

Common Mistakes and Things to Avoid

File Size Does Not Shrink After Deleting Data

Simply deleting cell contents does not reset the used range. Excel still stores formatting and other information for those cells. You must delete the entire rows or columns as described in the reduction steps. Always save and reopen the file after this cleanup to see the full effect.

Using Too Many Different Cell Formats

Applying unique formatting to thousands of individual cells creates overhead. Instead, use Excel Tables or apply formatting by entire columns or rows where possible. Style consistency helps keep the file size manageable.

Embedding Large Objects Instead of Linking

Pasting a full copy of a chart or document embeds all its data into the Excel file. Where possible, use paste special to link the object. This stores only a reference, not the entire object, reducing file size.

File Reduction Methods Comparison

Item	Clear Formats & Reset Used Range	Save as .XLSB Format
Primary Effect	Removes hidden formatting and resets workbook boundaries	Uses a more efficient binary storage structure
Best For	Files that have been edited extensively over time	Large, complex files with formulas and data
Data Risk	Low, but manual formatting is lost	None, all data and features are preserved
Size Reduction	Moderate, depends on how bloated the file was	Often significant, can be 50% or more
Reversibility	Difficult, requires re-application of formats	Easy, just save back as .XLSX format

You can now accurately check your Excel file size and identify what is causing it to be large. Use the Inquire add-in for a detailed breakdown before deciding on a reduction method. For ongoing size management, get into the habit of pressing Ctrl + End periodically to check for sheet bloat. A final advanced tip is to use Power Query to import and transform data, as it only loads the final result into the workbook, keeping the file lean.