If you can see only limited area of a worksheet
1. Check if the sheet is protected. This you check by going to Review tab and see if Unprotect Sheet Button is appearing.
– If Unprotect Sheet Button is appearing sheet is protected. You need to click it and if password is asked, you need to give the correct password to make the sheet unprotected.
– If Protect Sheet Button is appearing sheet is not protected. Then nothing needs to be done.
2. Press CTRL+A, Right Click on a Column Name A, B, C, D…..and Click Unhide. All columns will be unhidden.
3. Press CTRL+A, Right Click on a Row Number 1, 2, 3, 4…..and Click Unhide. All rows will be unhidden.