Cara menggunakan 10mb excel file download

Kompresor PDF ini gratis dan menyediakan Anda untuk menggunakannya waktu yang tidak terbatas dan kompres ukuran PDF online.

Kompresi Cepat

Pemrosesan kompresinya sangat kuat. Jadi, Dibutuhkan sedikit waktu untuk memampatkan semua PDF yang dipilih.

Keamanan

Kami memastikan bahwa PDF Anda sangat aman. Mengapa karena kami tidak mengunggah PDF apa pun di mana saja di Server.

Tambahkan Beberapa File

Pada alat ini, Anda dapat dengan mudah memampatkan beberapa PDF sekaligus. Anda cukup memampatkan PDF dan menyimpannya.

User Friendly

Alat ini dirancang untuk semua pengguna, pengetahuan lanjutan tidak diperlukan. Jadi, Sangat mudah untuk kompres ukuran PDF.

Alat yang Kuat

Anda dapat mengakses atau menggunakan PDF Compressor online di Internet menggunakan browser dari sistem operasi apa pun.

Bagaimana cara mengompres PDF secara online?

  1. Pilih PDF yang ingin Anda kompres pada Kompresor PDF.
  2. Lihat pratinjau semua PDF yang dipilih pada PDF Compressor.
  3. Anda dapat mengatur ukuran PDF menggunakan slider sesuai.
  4. Selain itu, Anda dapat menambahkan atau menghapus PDF dari daftar.
  5. Akhirnya, unduh PDF terkompresi dari Kompresor PDF.

Ini adalah cara untuk mengompres file PDF secara online menggunakan alat kompresor online gratis ini. Anda cukup mengompres banyak file PDF menggunakan alat online kompres file PDF ini. Jadi, pilih PDF yang ingin Anda kompres pada alat ini. Setelah memilih PDF, Anda dapat melihat di sana alat ini akan secara otomatis memampatkan semua PDF yang dipilih satu per satu dan kemudian menampilkan tombol unduh. Tombol unduh ini akan menampilkan setiap file PDF di bawah ini dengan ukuran file baru juga. Selain itu, Anda dapat menyesuaikan ukuran PDF menurut Anda dan menambahkan lebih banyak PDF atau menghapus PDF juga. Terakhir, unduh PDF terkompresi satu per satu atau unduh file zip. Jadi, dengan menggunakan alat kompres file PDF online ini, Anda cukup mengompres file PDF.

Hasil kompresi tidak dapat diprediksi. Jika file PDF sudah dioptimalkan, rasio kompresi akan dibatasi. Tetapi untuk sebagian besar pengguna kami file PDF, optimisasi selalu dapat ditemukan dan ukurannya berkurang secara dramatis. Beberapa ukuran file dapat dikurangi hingga 99%.

Mengapa mengompresi file membantu menjaga Blue Planet kita?

Semakin besar file Anda, semakin banyak energi yang dibutuhkan untuk penyimpanan dan transfer data. Namun pada tahun 2025, Internet dapat mengkonsumsi hingga 20% dari konsumsi listrik di seluruh dunia. Dengan mengompresi file Anda, Anda berkontribusi untuk masa depan yang lebih dapat dipastikan.

We all have an Excel file that’s too large. The kind that takes minutes to open or save, so everything takes twice as long.

Cara menggunakan 10mb excel file download

Florence, Senior Consultant at UpSlide, has a few easy hacks up her sleeve that will help you reduce your Excel file size within seconds.

Discover seven easy ways to compress Excel files in the article below.

Table of Contents

How to audit a large Excel file

Before we show you how to reduce your Excel file size, we’d first like to share a quick tip on auditing an Excel workbook.

For finance professionals working in Transactional Services or Investment Banking, building models with tons of formulas, tables and sheets is the norm. However, the more comments, formulas, conditional formatting and hidden sheets you add, the heavier the Excel file gets.

You can easily discover which sheets are the heaviest in your Excel file. To do so, make a copy of your Excel file and follow these steps:

  1. Open the File Explorer where your Excel is saved
  2. Display file name extensions in the “View” tab
  3. Change your Excel file copy’s extension to “.zip”
  4. Cara menggunakan 10mb excel file download

  5. Then open the zipped folder and go to xl > worksheets
  6. Sort by size

Cara menggunakan 10mb excel file download

Spotting the heaviest Excel sheets can help you choose which one to start with. For instance, “sheet26.xml” accounts for almost one-third of the global volume. Usually, it corresponds to the n+1 sheet in your Excel file. So, in the above example, we could start by trimming the twenty-seventh sheet.

Be careful! The n+1 rule takes into account hidden sheets. If you have a lot of hidden sheets, it can become tricky to find the right one. One way to know for certain you have the right sheet is to get the exact name. Here is the detailed guide for finding a sheet’s name.

Now, it’s time to dive into our seven tips for reducing an Excel file size:

Tip #1: Remove conditional formatting

Conditional formatting comes in handy when you need to highlight specific data. But it can quickly make your Excel file heavy. We suggest removing conditional formatting from your spreadsheet as soon as you are done with it. To do so, you must:

  • Select some formatted cells on your sheet
  • Go to the Home tab > Conditional formatting > Clear Rules > Clear from Selected Cells

Cara menggunakan 10mb excel file download

If you want to remove conditional formatting from all of your cells, pick Clear Rules from Entire Sheet.

Tip #2: Crop each worksheet to its used range

Did you know that Excel sheets can have up to one million rows? A good way to reduce your Excel file size is to get rid of the empty rows and columns. Here’s how to do that:

  • Select all unused rows and columns (Shortcut = Ctrl+Shift+Right/Down Arrow)
  • Right-click > Delete

Cara menggunakan 10mb excel file download

Tip #3: Remove unnecessary formulas

We all use Excel formulas to manipulate and combine data dynamically. But we often forget to remove them when they’re no longer needed.
Be sure to replace your formulas with their values to downsize your file and keep a record of your data. Here’s a quick way to do it:

  • Select the cells you are working with (you can use the shortcut Ctrl+A to select your entire sheet)
  • Copy and Paste Special: Values

Cara menggunakan 10mb excel file download

This will also remove hyperlinks, which make your file heavy.

Discover 16 basic Excel tips

Tip #4: Compress pictures in Excel

The golden rule is to avoid having pictures in Excel. If you have to use pictures, it’s best practice to always compress them. Here’s how:

  • Select the picture you wish to lighten
  • Go to the Picture Format tab
  • Click on Compress
  • We recommend unchecking the first box Apply only on this picture to compress all pictures inside your Excel file
  • Optional: you can choose the resolution you want (we recommend email).

Cara menggunakan 10mb excel file download

Tip #5: Clear data formatting

Formatting enables the eye to naturally structure information. However, formatting your data also weighs your sheets down. If you’re running into difficulties loading a file, we recommend removing your formatting. Follow these few easy steps:

  • Select all formatted rows, columns and cells that do not contain data
  • Home > Editing > Clear Format

Cara menggunakan 10mb excel file download

Want to learn the Top 6 Excel financial functions?

Tip #6: Delete watches

People who work on large files with many sheets and formulas know what watches are (not the one on your wrist!) Numerous watches will weigh down your spreadsheets. Once you’re done with them, a good practice is to remove them from your files:

  • Go to Formula tab > Watch Window
  • Select all and click Delete

Cara menggunakan 10mb excel file download

Tip #7: Eliminate hidden data (sheets, rows and columns)

IMPORTANT: We recommend you apply this step last, as it can break formulas and cannot be reversed! Make a copy beforehand.

Let’s start with sheets!

  • Right-click on a sheet
  • Select Unhide
  • Repeat the previous steps for every sheet

Now let’s do the same with columns and rows:

  • Select your entire sheet (Ctrl+A)
  • Right-click on your rows/columns
  • Click Unhide

Cara menggunakan 10mb excel file download

Now that you can see your entire Excel file, you can delete all unnecessary sheets, columns and rows. Moreover, you can easily audit your Excel file to spot heavy sheets with the method we used at the beginning of the article.

✨BONUS TIP: Reduce your Excel file size in one click

At UpSlide, we like to work on light files. That is why we created a feature that does the work for you: Smart Clean! It applies all the above tips in the blink of an eye. A single click on the UpSlide tab in Excel and your file will be as light as a feather.

This feature can reduce your Excel file size up to 99% of its initial weight!

    Try the Smart Clean now

Cara menggunakan 10mb excel file download

Want to find out more about UpSlide’s features and how we help you save time on Microsoft Office?

    Discover our features

Share it

Subscribe

Notify of

Label

{} [+]

Nom*

Email*

Website

Label

{} [+]

Nom*

Email*

Website

18 Comments

Oldest

Newest Most Voted

Inline Feedbacks

View all comments

OneAbdelah

2 years ago

This is definitely a very useful post, thank you for sharing

8

Reply

Pablo

2 years ago

The delete empty rows trick… OMG, that is a game changer for me. I didn’t know that when you copied full page ranges a million rows got copied! That was why my files were in the tens of megs. Now they’re 200kb! Thank you.

37

Reply

Will

2 years ago

can’t make sense of these instructions at all step 1: Change file extension to .zip?? Do you mean save as a zip – not possible, or send to a zip folder: tried that but it’s still and excel file?? so step 2 open zip file and go to XL>worksheets ?? no such menu options

0

Reply

Author

Edouard Ouaknine

2 years ago

Reply to 

Dear Will,
Thanks for spotting this!
We added two extra steps so you can see how to effectively change your file extension to ZIP.
Hope this will help you to reduce the size of your future heavy Excel spreadsheets 🙂
Best,
Edouard

4

Reply

Bart

2 years ago

You can use Ctrl-End to find the outmost cell that is being saved. It will show if there are indeed empty column/rows that are actually being saved/causing the large file size.

0

Reply

Author

Edouard Ouaknine

2 years ago

Reply to 

Hi Bart,
Thanks for the tip!
Another way to highlight cells containing data is to select “A1” and use Ctrl+Shift+End (this shortcut extends the selection to the last used cell on the worksheet).

1

Reply

Jignesh

2 years ago

Hi, Thanks for sharing. This is very useful.

0

Reply

Tom

2 years ago

This was the first page I found for this problem – but I could not crop the unused rows until I reset the row height to the default for that spreadsheet (see https://superuser.com/questions/1349521/deleting-rows-in-excel-doesnt-reset-last-cell-used-range)

0

Reply

Jaz

2 years ago

Save my life!

0

Reply

Jason

2 years ago

I had 3 separate sheets in my file that had blank columns in the “used range” all the way to XFD (16,000+ columns). I deleted all 3 and the used range is now down to about 50 columns, then saved the file. This resulted in no reduction (zero k) in file size. I verified that the used range is now correct and this bloated columns are gone, so why no change in size?

16

Reply

izabely lima

2 years ago

Save as Excel Binary Workbook.

5

Reply

VANDEEP

2 years ago

Reply to 

THANKS IT WORKED.

0

Reply

Afaq Zaheer

1 year ago

Thanks Alot… Useful post

0

Reply

Tom

1 year ago

Fantastic Post, thank you very much. The ZIP file method is incredible, I will not forget that going forward. We went from 46MB to 874KB.

3

Reply

Jack Rick

1 year ago

I tried 1st method but xecel file size increased 12MB to 124MB and system fully slow. But then I follow all series wise finally reduce excel file size. thanks

2

Reply

vim

3 months ago

Tip #2 knocked 8 meg off. Thanks Fella.

0

Reply

William Kus

27 days ago

The only problem with the delete function is that some computers may crash because of how much memory it takes to do this. I feel like Excel should automatically limit the cells. Not sure why 99% of users would need that many.

0

Reply

William Kus

27 days ago

Also when I was using the delete function to crop down a page with about 40000 rows, and a few hundred columns, I had to do a portion at a time (and mind you I have a gaming rig). Inbetween, I had to save, closeout of the program, and reload the excel sheet, reselect new portions, and delete again. The delete function stopped working if I didn’t save and closeout, and re-open. Not sure if anybody else is having this issue.