ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

Can we reduce the size of an Excel file ?

user-image
تم إضافة السؤال من قبل jhangeer bazmi , Freelance Graphics Designer
تاريخ النشر: 2017/03/09
Aamir Husain Ansari
من قبل Aamir Husain Ansari , Electronics Engineer , Al Jazirah for Trading and Industry Co. Ltd.

Yes. We can use an online compressor to reduce the fie size.

Sidrah Yaseen
من قبل Sidrah Yaseen , Psychologist , Combined Military Hospital Bahawalpur

Yess,we can reduce the size of an excel file.

Granville Cardoz
من قبل Granville Cardoz , Event Operations Manager , Fleming.

If you Don’t want to edit or make changes to your Excel File, but still want to reduce the file size? Then the best option will be Zip’ing the excel file, it will reduce upto 90% of file size depending upon the images and objects in the excel file

Faraz Shaikh
من قبل Faraz Shaikh , Supervisor, Inbound Logistics , Factory Of Methanol Chemicals Company - CHEMANOL

Shrink the excel file size more than 50% without losing DATA

please see the below link 

https://www.youtube.com/watch?v=6Oy63vU1nD0

Roxana Hoque
من قبل Roxana Hoque , Researcher , Japan Agency for Marine-Earth Science and Technology (JAMSTEC).

Save the file to Excel in binary (.xlsb). Doing this structures the workbook into a compressed folder that has many binary files. The amount of compression that you're going to get depends on the contents of the workbook. Also, you may find that opening, closing and saving the file takes longer than something saved just in regular (.xls) format.[1]

  • After you've saved the file as an .xlsb, highlight and delete all of the cells outside the data range (typically to the right and below).
  • Highlight the same cells and delete all formatting (colors, lines, etc.). Delete formatting for each for each sheet within the workbook.
  • Re-save the workbook as an .xlsx file. Check to see how much these actions reduced the file size.

Firas Shahadi
من قبل Firas Shahadi , Human Resources Director , SAUDI UNION

We need fist to define the file size.

is it the bytes of the file? is is the number of rows and columns? is it the calculation time for each sheet. etc..

there are plenty ways to reduce the file size of you mean just the bytes of the file.

 

  1. remove extra unnecessary formatting
  2.  avoid selecting the entire row and column and give it a format.
  3. remove extra rows and columns that are blanks. use Ctrl+End to know where is the last cell.
  4. there is more advance techniques in case this is not enough.

 

thank you for the question

 

المزيد من الأسئلة المماثلة