reduction of excel file size

Hi
I have a excel file which contain many formula but the problem is it is consuming more time to open and even the excel file is too heavy . how can i reduce the file size?

take a look

Workbook Filesize too big, worksheet too big.

If you Hit Ctrl & End and the cell selected is way past you actual worksheet, then you probably have formats in unused cells.

Just for an example exercise:

Open a new Workbook.

Make a small Excel Table 3 rows down and 3 columns accross. Select A1 and hit Ctrl & End keys. This will select  C3.

Select E5 and click the Align text left icon, but do not enter anything into that cell.

Select A1 and then hit Ctrl & End Keys. E5 is now selected, even though it is empty.

Do the same for F100, you will see that F100 is now the end of the sheet.

Another indication of a sheet being to large is the size of the scroll bars. If they are smaller than you think they should be.

Select the very last Cell on the sheet and set the format but leave it empty.

Select A1, you see you only have a 3 x 3 table but look how small your scroll bars are.

Save the workbook as Test or anything you want.

Make it small again.

Select Column D by clicking on the D Use the keys Shift & End & Right Arrow key to select all the way to the last column. Select the Clear Icon, in xl'07 it is located on the Home Ribbon. Select "Clear All"

Note: The delete key will not work for this excercise, the delete key only clears the contents

Select Row 4 by clicking on the 4, Use the keys Shift & End & Down Arrow key to select all the way to the last row. Clear the rows the same way as you cleared the columns.

You will see that the scroll bars are still small. Hit the save button and they should instantly become the proper size again.

Select A1 and hit Ctrl & End, C3 should be selected.

So in a nutsheel.

"Clear All" the Empty Columns

"Clear All" the empty Rows

Resave sheet.

 

Dave

davesexcel.com/