Forum Discussion
delayne
Jul 03, 2023Copper Contributor
worksheet page stopped showing any rows past 1200
One worksheet in my excel workbook stops at line 1236 and is grey below. Will not show data, gridlines, or let me add rows below. No rows are hidden. I removed the freeze top row. Tried looking at...
Riny_van_Eekelen
Jul 03, 2023Platinum Contributor
delayne Have a look at the bottom right of the Excel window. You probably selected Page Brake Preview.
Select the icon two to the left for Normal. That should bring back the grid lines and everything else you mention.
delayne
Jul 03, 2023Copper Contributor
found View normal, once selected it did not correct my issue.
- SergeiBaklanJul 03, 2023Diamond Contributor
- delayneJul 03, 2023Copper Contributor
SergeiBaklan No - it just has a box, like the pull down I'd expect to see, and gives me the 4 arrows when I click on it.
- delayneJul 05, 2023Copper ContributorThanks Sergio - I understand now. I have the box but it doesn't react or drag down. Just locks up the spreadsheet and makes me restart excel. lol**