Extra Rows in Excel 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

danika - 24 Mar 2008 23:38 GMT

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?

Reply to this Message

Jim Rech - 25 Mar 2008 11:46 GMT

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.

>>Then I selected the entire old spreadsheet, did a 'clear contents',

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

Signature

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
[quoted text clipped - 14 lines]
|
| Anybody know what's happening?

Reply to this Message

Rate this thread: