Excel Data Entry Page ends at row 887. How to expand for more data?

Copper Contributor

At the beginning of the year I set up a new workbook for tracking data for the company. The page has been used by several people through the year. 

When I set it up I did some basic formatting to make it look nice. One thing I did was to scroll way down, ctrl+shift+down arrow then hide the bottom rows. I thought I had allowed plenty of rows for data. 

The space is also formatted as a table. If I did anything else I don't remember or maybe someone else did something. I don't know. 

Now we need more rows and I can't get them? I've tried to unhide and I've resized the table range. I'm not sure what else to try? 

1 Reply

@dsquire Solved it. There was some kind of bug. I selected the last 3 rows, this was after unhiding several different ways, then resized the rows by dragging the row height slightly. Immediately the missing rows appeared.