I am having an issue using Excel 2010. I am trying to insert a row in one of my worksheets.
When I attempt to do so I get an error:
"To Prevent loss of data, Excel cannot shift non blank cells off the worksheet. Select another location in which to insert new cells, or delete data from the end.
If you do not have data in the cells that can be shifted off fo the worksheet, you can reset which cells Excel considers nonblank. Press Cntl+END to locate the last non blank cell on the worksheet. Delete this and all cells between it and the last row and column of your data."
I went to the last row of my data set and highlighted all the rows below it to the end and deleted them. I also deleted all the columns to the right but it still will not let me insert a row after doing so, very confused. My data table ends are row 392 so I am nowhere near the end of the sheet...
When I attempt to do so I get an error:
"To Prevent loss of data, Excel cannot shift non blank cells off the worksheet. Select another location in which to insert new cells, or delete data from the end.
If you do not have data in the cells that can be shifted off fo the worksheet, you can reset which cells Excel considers nonblank. Press Cntl+END to locate the last non blank cell on the worksheet. Delete this and all cells between it and the last row and column of your data."
I went to the last row of my data set and highlighted all the rows below it to the end and deleted them. I also deleted all the columns to the right but it still will not let me insert a row after doing so, very confused. My data table ends are row 392 so I am nowhere near the end of the sheet...