excel - deleting empty cells

[adrianlewis]

When trying to delete rows of empty cells I am highlighting the rows - right clicking and selecting delete. This is supposed to delete the rows so that the scroll bars on the right only scroll to the last row of data before they begin to change size and get smaller the further you scroll. however at the moment the scroll bar is tiny as it has decided that all of the empty rows are being used and therefore is creating a larger file to save. I highlight the rows and delete them but this doesnot correct the problem. Any ideas?

[sdkfz]

do you have anything typed into a cell way off to the right or the bottom? That would make the file huge casue you have 60,000 lines of nothing then a character in the last cell

Other than that thought I do not kow....

[Chris in U.K.]

Hi Adrian

which version of XL are you using?

Chris

[David_Jones]

Adrian,

How are you selecting the rows?

Try this:

Go to the last row that you have actually used (say 100).

Go down another 5 or so to be safe.

Now, select any cell in that row (say, A105), and press Shift-Ctrl-Down Arrow.

That should select every row from 105 to 65536.

Now, with those rows selected, choose EDIT - DELETE from the menu.

You'll then get a dialogue asking for confirmation of what you want to do. Choose 'Entire Row' and click OK.

Finally, save and close Excel for the change to be recognised fully when you re-open.

That should hopefully do it.

Note that you might also want to do the same with unused columns, although there are only 256 columns compared to 65536 rows in each sheet.

HTH,

David.