Over a million cells in my spreadsheet
 

I'm sure this is a human error as I have just a basic knowledge of excel. I
have started a spreadsheet to keep track of ticket sales. My first column
has my ticket numbers and stops at 1525. Everything was fine until somehow
my spreadsheet opened to over a million cells. I have no idea how I did this
or how to fix it. I have made three new spreadsheets and have managed to do
this to all of them.

Over a million cells in my spreadsheet
 

I've had similar things happen, and I think it may have to do with full row
or column formatting. Ex. excel will generally not consider areas of the
sheet that are not being worked on, but if you format an entire column with
borders or colours, it thinks your using that whole area and starts
considering them for display. You may want to avoid this type of formatting
and only format the actual areas that you intend to work with. There may be
better solutions out there, but this worked for me.

"fancy" wrote:

I'm sure this is a human error as I have just a basic knowledge of excel. I
have started a spreadsheet to keep track of ticket sales. My first column
has my ticket numbers and stops at 1525. Everything was fine until somehow
my spreadsheet opened to over a million cells. I have no idea how I did this
or how to fix it. I have made three new spreadsheets and have managed to do
this to all of them.

Over a million cells in my spreadsheet
 

Thanks Mike... to the best of my 'limited' knowledge, I am not formatting
anything. So I just don't know what is causing this. Thanks for the answer
though!

"mike" wrote:

I've had similar things happen, and I think it may have to do with full row
or column formatting. Ex. excel will generally not consider areas of the
sheet that are not being worked on, but if you format an entire column with
borders or colours, it thinks your using that whole area and starts
considering them for display. You may want to avoid this type of formatting
and only format the actual areas that you intend to work with. There may be
better solutions out there, but this worked for me.

"fancy" wrote:

I'm sure this is a human error as I have just a basic knowledge of excel. I
have started a spreadsheet to keep track of ticket sales. My first column
has my ticket numbers and stops at 1525. Everything was fine until somehow
my spreadsheet opened to over a million cells. I have no idea how I did this
or how to fix it. I have made three new spreadsheets and have managed to do
this to all of them.