Error inserting rows

[COGICPENNY]

I have a massive list that contains 1M rows that I imported from a client's CD as a csv file.

I want to insert a row on the top to create a header row so that I can filter data. Upon trying to do this, I get the error message "Excel cannot shift non blank cells off the worksheet...."

I tried to follow the instructions, but they're VERY confusing and I have no clue what I need to do. I clicked CTRL+END and saw that under the last row of data was blank space/background with no rows (hope I'm making sense).

How do I get the spreadsheet to look like a normal excel spreadsheet with the standard blank rows showing beyond where your data ends?

Thanks,
Penny

 

[Joe4]

You didn't mention what version of Excel you are using.
If it is Excel 2007, it can hold up to 1,048,576 rows.
How many rows of data do you have?
If it is 1,048,576 or more, you have already used up all available rows and there is no more room to insert any more.

 

[COGICPENNY]

1,048,574 rows of data that appear, Excel 2007

Under the last row of data is the blue background no additional rows. I just want to create 1 row for the header information (LAST NAME, FIRST, ADDRESS, CITY, STATE, ZIP CODE)

Wow, I never knew that, so this means it is possible that the spreadsheet (converted from text format) could potentially be MUCH larger?!?

Any suggestions, on what other alternatives I could use? Do you know if Access has the same limitations on their records?

 

[Joe4]

Wow, I never knew that, so this means it is possible that the spreadsheet (converted from text format) could potentially be MUCH larger?!?

Yes, it is possible. Can you open it in a Text Editor like NotePad to verify?

Any suggestions, on what other alternatives I could use? Do you know if Access has the same limitations on their records?

Access's limitation is not on number of rows (records), but rather total database size (2 GB). So you could definitely try importing it into Access.

Over the years, I have also seen some threads where people created some clever VBA code that when importing a text file, if it exceeds the maximum number of rows, it continues on in a new sheet in the workbook. If interested, you may want to see if you can locate some of those threads.