answersLogoWhite

0


Best Answer

Remove anything that you are not using, like unused sheets. Do the same with any unused data. Things like pictures will greatly add to the size of a file, so remove any of those that are not necessary. You may not get a major reduction in size when you've done these things, but it should help a little. Older versions of Excel use less space for the same files, so you could save the file in an earlier format, by doing a Save As and picking an older version in Save As Type at the bottom of the dialog box. You can also zip a saved file to make it smaller.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you decrease the size of an Excel file?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Does image effect the file size in excel?

Having images in any application will always affect the file size, so the answer is yes.


How many Excel files can be stored on a 4gb memory stick?

It depends on the size of the files. If you have a 4GB Excel file, you will be able to store only one file.


What is the maximum MB file size of an Excel 2007 file?

Current spreadsheet size is 165MB, no problems yet and includes extensive code/macros and colors.


Can you decrease the file size of a photo in Microsoft paint?

Try saving as a different file type. A .jpeg file would be smaller than a .bmp file.


What kind of file is xlsx?

.xlsx is the file format used in Microsoft Office Excel 2007. It is NOT backwards compatible (i.e. Excel 2003 and earlier versions cannot open it). The file is XML based and smaller in size than the .xls format. It is possible to open, edit, and save a .xls file in Excel 2007 for backward compatibility.


What is the file excel?

Excel is not a file, but a computer program that makes spreadsheets.


What is an excel file?

When you create a spreadsheet or workbook then a corresponding file is created on your machine, that file is known as excel file.


Where does the file name appear when you open an Excel file?

The File name will usually appear at the top of the excel file. It should look something like this: file name - Microsoft Excel...


What is .xlsx?

.xlsx is the file format used in Microsoft Office Excel 2007. It is NOT backwards compatible (i.e. Excel 2003 and earlier versions cannot open it). The file is XML based and smaller in size than the .xls format. It is possible to open, edit, and save a .xls file in Excel 2007 for backward compatibility.


Can you reduce a 792MB picture file to 700MB to copy to a CD?

reducing the quality will decrease it size


What is the fingerprint for an Excel file?

Microsoft Excel


What is excel xltx?

It is an Excel template file.