Extra Rows in Excel 2007

[danika]

I recently upgraded to Excel 2007 from 2002, and a lot of the spreadsheets
seem to have something extra in the rows below the end of the data. Two
examples:

1) I went to the bottom of the data in a spreadsheet and made a new entry.
As soon as I hit enter, the spreadsheet started scrolling down and wouldn't
stop for a couple of thousand rows.

2) I saved a spreadsheet as a csv file and another application that uses the
file started having problems. So I opened the csv file in WordPad and saw a
couple of hundred rows of commas. That never happened with Excel 2002. I
opened the spreadsheet back up, cut the data, and pasted it temporarily to
another spreadsheet. Then I selected the entire old spreadsheet, did a
'clear contents', and then copied and pasted the data back into the old
spreadsheet and saved it as a csv file again. Same result, lots of extra
rows of commas.

Anybody know what's happening?

 

[Jim Rech]

I do not understand why the first problem happens, sorry.

The second is easy to duplicate (in Excel 2007 or 2002):

-New sheet
-Fill "data" like "ABC" in a range such as A1:F30
-Select rows 16:30 and change row heights to say 10.
-Clear data from range A16:F30.
-Save as a CSV.

You will have 15 rows of data and 15 rows of commas in the CSV.

Even though the cleared range has no entries Excel sees it as having data.

Don't do a clear contents. Instead select the range and delete the entire
rows (Ctrl-Minus).

--
Jim
|I recently upgraded to Excel 2007 from 2002, and a lot of the spreadsheets
| seem to have something extra in the rows below the end of the data. Two
| examples:
|
| 1) I went to the bottom of the data in a spreadsheet and made a new
entry.
| As soon as I hit enter, the spreadsheet started scrolling down and
wouldn't
| stop for a couple of thousand rows.
|
| 2) I saved a spreadsheet as a csv file and another application that uses
the
| file started having problems. So I opened the csv file in WordPad and saw
a
| couple of hundred rows of commas. That never happened with Excel 2002. I
| opened the spreadsheet back up, cut the data, and pasted it temporarily to
| another spreadsheet. Then I selected the entire old spreadsheet, did a
| 'clear contents', and then copied and pasted the data back into the old
| spreadsheet and saved it as a csv file again. Same result, lots of extra
| rows of commas.
|
| Anybody know what's happening?