I cannot seem to open any rows below 289, when I try to insert a row I get the "cannot push non-empty cells off the end of the worksheet" error. Somehow I set the very last row in this worksheet at 298 and no more. Help Please?
That row is the last row with data in it.
rows stop at 298, nothing at all below, no row numbers, grid lines or anything else, just grey space.
I can't remember anything I may have did; as in set a table etc. that could have caused this to happen.
You could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.
You can't have a worksheet with only 298 rows in it, so they must be hidden. Select all cells by clicking the grey square between the row 1 indicator and the column A one, then right-click a row, choose Row height, and set it to say 15.