How to Reduce Excel File Size (with Pictures)

Table of contents:

How to Reduce Excel File Size (with Pictures)
How to Reduce Excel File Size (with Pictures)

Video: How to Reduce Excel File Size (with Pictures)

Video: How to Reduce Excel File Size (with Pictures)
Video: How to Download & Install Microsoft Word/ Office For Free on (PC / Laptop) 2024, November
Anonim

This wikiHow teaches you how to reduce the amount of space a Microsoft Excel file takes up by removing some formatting, compressing images, and saving the file in a more efficient format.

Step

Part 1 of 6: Saving Sheets As Binary Files

Reduce Size of Excel Files Step 1
Reduce Size of Excel Files Step 1

Step 1. Open the Microsoft Excel file

Double click the green and white app icon with the letter “ X", click menu " File " and " Open… ”, and select the desired file.

Reduce Size of Excel Files Step 2
Reduce Size of Excel Files Step 2

Step 2. Click File

Reduce Size of Excel Files Step 3
Reduce Size of Excel Files Step 3

Step 3. Click Save As…

Reduce Size of Excel Files Step 4
Reduce Size of Excel Files Step 4

Step 4. Type in a file name

Reduce Size of Excel Files Step 5
Reduce Size of Excel Files Step 5

Step 5. Click the "File Format:" drop-down box

Reduce Size of Excel Files Step 6
Reduce Size of Excel Files Step 6

Step 6. Click Excel Binary Workbook on segment "Specialty Formats".

Files saved in this format are quite small in size compared to regular.xls files.

Reduce Size of Excel Files Step 7
Reduce Size of Excel Files Step 7

Step 7. Click Save

The smaller Excel file will be saved to the computer.

Part 2 of 6: Removing Format from Blank Rows and Columns

Reduce Size of Excel Files Step 8
Reduce Size of Excel Files Step 8

Step 1. Open the desired Microsoft Excel file

Double click the green and white app icon with the letter “ X", click menu " File " and " Open… ”, and select the desired file.

Reduce Size of Excel Files Step 9
Reduce Size of Excel Files Step 9

Step 2. Select all blank rows

Click the first blank line number, then press and hold the key combination Ctrl+⇧ Shift+↓ (Windows) or +⇧ Shift+↓ (Mac).

The arrow keys are generally in the lower-right corner of the keyboard

Reduce Size of Excel Files Step 10
Reduce Size of Excel Files Step 10

Step 3. Click the Home tab or (Windows) or Edit on the menu bar (Mac).

Reduce Size of Excel Files Step 11
Reduce Size of Excel Files Step 11

Step 4. Click Clear

Reduce Size of Excel Files Step 12
Reduce Size of Excel Files Step 12

Step 5. Click Clear All (Windows) or Format (Mac).

With this option, unnecessary formatting will be removed from unused cells.

Reduce Size of Excel Files Step 13
Reduce Size of Excel Files Step 13

Step 6. Select all blank columns

Click the letter of the first empty column, then press and hold the key combination Ctrl+⇧ Shift+→ (Windows) or +⇧ Shift+→ (Mac).

The arrow keys are generally in the lower-right corner of the keyboard

Reduce Size of Excel Files Step 14
Reduce Size of Excel Files Step 14

Step 7. Click the Home tab (Windows) or Edit on the menu bar (Mac).

Reduce Size of Excel Files Step 15
Reduce Size of Excel Files Step 15

Step 8. Click Clear

Reduce Size of Excel Files Step 16
Reduce Size of Excel Files Step 16

Step 9. Click Clear All (Windows) or Format (Mac).

With this option, unnecessary formatting will be removed from unused cells.

Part 3 of 6: Removing Conditional Formatting

Reduce Size of Excel Files Step 17
Reduce Size of Excel Files Step 17

Step 1. Open the desired Microsoft Excel file

Double click the green and white app icon with the letter “ X", click menu " File " and " Open…, and select the desired file.

Reduce Size of Excel Files Step 18
Reduce Size of Excel Files Step 18

Step 2. Click the Home tab at the top of the screen

Reduce Size of Excel Files Step 19
Reduce Size of Excel Files Step 19

Step 3. Click Conditional Formatting

It's in the "Styles" section of the options ribbon.

Reduce Size of Excel Files Step 20
Reduce Size of Excel Files Step 20

Step 4. Click Clear Rules

Reduce Size of Excel Files Step 21
Reduce Size of Excel Files Step 21

Step 5. Click Clear Rules from Entire Sheet

Part 4 of 6: Removing Format from Blank Cells (Windows)

Reduce Size of Excel Files Step 22
Reduce Size of Excel Files Step 22

Step 1. Open the desired Microsoft Excel file

Double click the green and white app icon with the letter “ X", click menu " File " and " Open…, and select the desired file.

Reduce Size of Excel Files Step 23
Reduce Size of Excel Files Step 23

Step 2. Click the Home tab at the top of the screen

Reduce Size of Excel Files Step 24
Reduce Size of Excel Files Step 24

Step 3. Click Find & Select

This option is in the " Editing " section of the options ribbon.

Reduce Size of Excel Files Step 25
Reduce Size of Excel Files Step 25

Step 4. Click Go To…

Reduce Size of Excel Files Step 26
Reduce Size of Excel Files Step 26

Step 5. Click Special…

Reduce Size of Excel Files Step 27
Reduce Size of Excel Files Step 27

Step 6. Click the Blanks radio button

Reduce Size of Excel Files Step 28
Reduce Size of Excel Files Step 28

Step 7. Click OK

Now, all blank cells in the data set will be marked.

Reduce Size of Excel Files Step 29
Reduce Size of Excel Files Step 29

Step 8. Click Clear

This option is indicated by an eraser icon.

Reduce Size of Excel Files Step 30
Reduce Size of Excel Files Step 30

Step 9. Click Clear All

Part 5 of 6: Removing Format from Blank Cells (Mac)

Reduce Size of Excel Files Step 31
Reduce Size of Excel Files Step 31

Step 1. Open the desired Microsoft Excel file

Double click the green and white app icon with the letter “ X", click menu " File " and " Open… ”, and select the desired file.

Reduce Size of Excel Files Step 32
Reduce Size of Excel Files Step 32

Step 2. Click Edit

This option is in the menu bar at the top of the screen.

Reduce Size of Excel Files Step 33
Reduce Size of Excel Files Step 33

Step 3. Click Find

Reduce Size of Excel Files Step 34
Reduce Size of Excel Files Step 34

Step 4. Click Go To…

Reduce Size of Excel Files Step 35
Reduce Size of Excel Files Step 35

Step 5. Click Special…

Reduce Size of Excel Files Step 36
Reduce Size of Excel Files Step 36

Step 6. Click the Blanks radio button

Reduce Size of Excel Files Step 37
Reduce Size of Excel Files Step 37

Step 7. Click OK

Now, all blank cells in the data set will be marked.

Reduce Size of Excel Files Step 38
Reduce Size of Excel Files Step 38

Step 8. Click Edit on the menu bar

Reduce Size of Excel Files Step 39
Reduce Size of Excel Files Step 39

Step 9. Click Clear

Reduce Size of Excel Files Step 40
Reduce Size of Excel Files Step 40

Step 10. Click Format

Part 6 of 6: Compressing Images

Reduce Size of Excel Files Step 41
Reduce Size of Excel Files Step 41

Step 1. Open the desired Microsoft Excel file

Double click the green and white app icon with the letter “ X", click menu " File " and " Open… ”, and select the desired file.

Reduce Size of Excel Files Step 42
Reduce Size of Excel Files Step 42

Step 2. Open the “Compression” dialog box

To display it:

  • On a Windows computer, click the image, then click the “ Format ” and click option “ Compress ” on the toolbar.
  • On a Mac computer, click the “ File " and select " Reduce File Size… ”.
Reduce Size of Excel Files Step 43
Reduce Size of Excel Files Step 43

Step 3. Click on the drop-down menu that is next to the “Picture Quality” option

Reduce Size of Excel Files Step 44
Reduce Size of Excel Files Step 44

Step 4. Choose a smaller image resolution

Reduce Size of Excel Files Step 45
Reduce Size of Excel Files Step 45

Step 5. Check the box " Delete cropped areas of pictures"

Reduce Size of Excel Files Step 46
Reduce Size of Excel Files Step 46

Step 6. Click All pictures in this file

Reduce Size of Excel Files Step 47
Reduce Size of Excel Files Step 47

Step 7. Click OK

The images displayed in the file will be compressed and extraneous image data will be deleted.

Recommended: