Oops!
I skipped the part where you said your totals were on the last row!
Do a Ctrl-End to see where Excel "thinks" your worksheet ends and, as Chuck has noted -
Delete all unused/unwanted rows/columns then immediately save the workbook.
I've seen it posted that you have to close the workbook after this but in my experience
with '97, 2k and '03 saving it was enough.
Sorry for the confusion.
--
Regards;
Rob
------------------------------------------------------------------------
"RWN" wrote in message ...
They won't "go away".
Each worksheet comes with 65,536 rows and 256 columns.
If you don't use them (formatting as well as putting something in them) your workbook
will
ignore them when saving.
In other words Excel will keep track of what you have used.
--
Regards;
Rob
------------------------------------------------------------------------
"Jim" wrote in message
...
Hello,
I'm setting up a Sales Journal in Excel. I only need 50-60 rows and the
document I have open and set up has over 65,000 rows. And...of course....the
totals for the columns appear at the very bottom (row 65,000+)
So....how do I get rid of all those rows??? I've tried to highlight and
delete but they don't go away?????
As always....thanks for your help!
--
CWJ
--
CWJ
|