Worksheet rows stop at row 298

SRMPURCHASE

Board Regular
Joined
Dec 23, 2014
Messages
161
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?
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,593
Office Version
  1. 2007
Platform
  1. Windows
Press Control + End and check which row was stopped. Maybe you put some information in the last row of the excel sheet.
What error does it send you?
 

SRMPURCHASE

Board Regular
Joined
Dec 23, 2014
Messages
161
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.
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,593
Office Version
  1. 2007
Platform
  1. Windows
Do you have an error?


The rows are not visible, they may be hidden, select all the cells, right click on any cell and select show.
 

SRMPURCHASE

Board Regular
Joined
Dec 23, 2014
Messages
161

ADVERTISEMENT

They may be hidden below 298 but I cannot unhide them, I've tried all I know on how to unhide hidden rows.
It appears as this worksheet only has 298 rows in it and can go no further.
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,593
Office Version
  1. 2007
Platform
  1. Windows
Is the sheet protected?

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.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,483
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS

ADVERTISEMENT

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.
 

SRMPURCHASE

Board Regular
Joined
Dec 23, 2014
Messages
161
Setting all rows to a height of 15 worked, never would have thought of that solution, thanks.
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,593
Office Version
  1. 2007
Platform
  1. Windows
I understand, you go into a desperation because the sheet was lost. Good thing it already works.
 

SRMPURCHASE

Board Regular
Joined
Dec 23, 2014
Messages
161
So, how did setting the row height to 15 expose the rows below 298? What was keeping them hidden?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,492
Messages
5,523,260
Members
409,506
Latest member
reneekeane

This Week's Hot Topics

Top