change view in excel

Occasional Contributor

do you know how i change the view in excel?


this changed recently 


when i go full sheet, i can't see the sheet tab view.

but when i minimise i can see the tab view.


how do i change this 


I beleive it only happens when i use multiple moniors for excel fro some reason


Thanks, Kind Regards

1 Reply


Two things come to mind that could possibly solve this:

  • In your Excel workbook, click: ViewArrange All > tick Windows of active workbook
  • The sheets tab at the bottom could be hidden behind your taskbar which was an irregular issue with Windows 7 - I think it had something to do with having both auto-hide and locked taskbar enabled; so disable one of them.

Hope this helps!