• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar

Mechanicaleng blog

siemens nx tutorial & injection molding technology

  • Plastic molding
  • Siemens nx
    • nx modeling
    • nx drafting
    • nx sketching
    • nx assembly
  • Mechanical basic
    • mechanical standard
    • Mechanism video
  • microsoft office
    • microsoft word
    • powerpoint
    • excel tips
  • About me
  • CONTACT ME
Home » microsoft office » excel tips » 4 ways to reduce excel size

4 ways to reduce excel size

November 27, 2021 by mechanicaleng blog Leave a Comment

In this post, I will guide to you 4 ways to reduce excel size. You will know the reason of heavy and how to improve it. You can reduce excel file by compress images file, remove conditional formatting, Remove formatting from empty rows and columns, save as your excel file to Excel Binary Workbook.

Post contents

  • How do you think if your excel file is heavy?
  • I. Why your excel file is heavy?
  • II. How to reduce excel file?
    • 1. Reduce excel size file by compress images file.
    • 2. Reduce excel size by remove conditional formatting
    • 3. Remove formatting from empty rows and columns.
    • 4. Save as your excel file to Excel Binary Workbook.

How do you think if your excel file is heavy?

– We will lose long time to open it.
– You will lose more time to do your work. Sometimes, if your computer is low power, it will be stress, freeze.
– When you share the excel file to other people, your email, google driver, … will fill up quickly. Or if you are in low internet, you cannot upload it to internet.
A heavy excel file will reduce your working speed, it will take you more frustrate.

I. Why your excel file is heavy?

Have many reasons to make your excel file is heavy. You can check these reasons below and check in your excel file.
– Excel file have many pictures or original images.
– Excel file have too many formulas or high complexity formulas.
– There are many data in your excel file and it have many formats.
– There are many cell that do not use but are formatted. It is reason for slowly.
– Save excel file as .xls

II. How to reduce excel file?

To reduce the excel file, we will improve the reason of it.

1. Reduce excel size file by compress images file.

– Open the excel file that have many pictures or original image that you want to reduce of size.
– Select pictures in the excel file and click format -> compress pictures option. In this compress pictures dialog, you can select these method as you want.

reduce size in excel _compress pictures in excel

2. Reduce excel size by remove conditional formatting

– Open the excel file that you want to reduce size.
– Click the home tab -> conditional formatting.

excel_Conditional Formatting

– Select Clear Rules option (delete rules -> Clear Rules from Entire Sheet (delete rules in all sheets).

excel_clear rules from entire sheet

3. Remove formatting from empty rows and columns.

– Open the excel file that you want to reduce size.
– Select the first blank row, then press and hold Ctrl + Shift + down arrow to select all blank rows.

select all back row in excel
– Go to Home tab on the toolbar, click the Clear button -> Clear all.

clear all in excel
You can do the same to delete the blank column. To select all the black columns, press and hold Ctrl + Shift + right arrow to select all blank columns.

4. Save as your excel file to Excel Binary Workbook.

– Open your excel file that you want to reduce size.
– Select file -> save as -> browse. At save as type, you select Excel Binary Workbook option.
– Click save to get new file.

Related posts:

reduce size of PowerPoint 64 ways to reduce size of PowerPoint file educe the size of a Word document 6How to reduce the size of a Word document file How to count blank cells in excelHow to count and color blank cells in excel change cell background color automatically in excelchange cell background color in excel by equal formulas

Filed Under: excel tips Tagged With: excel beginner

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Recent Posts

  • what is spur gear | introduction
  • Mechanical engineering skills from training process
  • What is Inox | Stainless Steel?
  • How to create thread in nx
  • nx assembly| create a new part from the same part
  • how to calculate sum of squares in Excel
  • How to active GC toolkits in Siemens NX
  • How to create a sphere in nx
  • How to create a cone in nx
  • How to create a cylinder in nx

Copyright © 2023 · Magazine Pro on Genesis Framework · WordPress · Log in