Forum Discussion

Copper Contributor

Jul 03, 2023

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...

excel

Riny_van_Eekelen

Platinum Contributor

Jul 03, 2023

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
Copper Contributor
Jul 03, 2023
Riny_van_Eekelen
found View normal, once selected it did not correct my issue.
- SergeiBaklan
  Diamond Contributor
  Jul 03, 2023
  delayne
  
  If you select row 1236 do you see triangle like
  
  at the left bottom of A1236?
  - delayne
    Copper Contributor
    Jul 03, 2023
    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.
delayne
Copper Contributor
Jul 03, 2023
Riny_van_Eekelen I have searched and requested help to locate these 3 icons. They are not showing on the bottom of my excel, and I can't locate them under View , Review, or Page Layout. Now it won't even let me scroll (arrow on scroll bar) down to see the greyed out.
Trying to determine if i can open the bar to show these icons? it shows count, my additional tabs, zoom.