Re: Excel won't let me insert rows

[Ron de Bruin]

Hi hornbuckle

Excel can think that the usedrange is bigger then it is.

You can see how big your usedrange is on every sheet with CTRL-END
If the row/column is not the last row/column with data then:

1 Select the first row below your last row with data
2 CTRL-SHIFT-DOWN ARROW
3 Right click on the selection and choose delete

And then for the columns

1 Select the first column next to your last column with data
2 CTRL-SHIFT-RIGHT ARROW
3 Right click on the selection and choose delete

Save the file an close it

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)

I am only using 100 row and 35 coulmn in a spreadsheet. When I try to insert a row it sends some message about the

spreadsheet being full and xxxxxx. For some reason the hortizonal and vertical arrows are also using the entire spreadsheet.
How to I correct this problem?