Forum Discussion
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 advanced settings, as it wouldn't let me insert rows, but Ctrl +6 allowed me to do that. How do I locate the rest of the worksheet? I believe there were completed rows past 1236? Tried finding Disable acceleration Graphics in settings and it doesn't appear where all excel tutorials show it should be.
Thanks
8 Replies
- You could use the name box to navigate to A1048576 and then unhide using this method:
https://support.microsoft.com/en-us/office/unhide-the-first-column-or-row-in-a-worksheet-d6b47608-80ee-4021-9b51-6a1f57269ec9#:~:text=1%20To%20select%20the%20first%20hidden%20row%20or,the%20row%20height%20or%20column%20width.%20See%20More 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.
found View normal, once selected it did not correct my issue.
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.
