Small excel sheet that take many M-bits!!

Boss

New Member
Joined
Sep 10, 2003
Messages
6
Hi all

I have a big sheet with many functions, but to make it smaller I copyed and pasted all values, so it was surpost to be small in M-bits. But it was still 19 mbit.

So i tryed to delete all sheets minus one. and it files 1,4 mbit, and it is a emty sheet.

My questions is is there some plase in Excel where i can see what is taking all this diskplace???

:pray: HELP

Claus
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Richie(UK)

MrExcel MVP
Joined
May 17, 2002
Messages
3,329
Hi Claus,

Sounds like the real last cell is not correct. Try pressing Ctrl and End together - does this take you to where you think the last cell is or to somewhere further down the sheet?
 

inarbeth

Well-known Member
Joined
Apr 8, 2002
Messages
912
Hi welcome to the board.
There are a number of possible answers.
I suggest you check the following:
Are there hidden rows or columns in the sheets?
Are there hidden worksheets?
Is the sheet in fact "empty"? Are cells formatted with white text or formattted ;;; so that text is hidden??

As Richie suggests. select Ctrl + End to get to the last cell. Note it and then type in the name box "A1: the last cell" without the "" and then Edit Clear All.
 
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,491
Messages
5,764,675
Members
425,229
Latest member
Rashid mahmood

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top