Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Excel 2007 not displaying as expected

0

I am helping someone else working on a busy spreadsheet that is not behaving as it used to on my computer. The problem is when I open the file, everything appears normal but the 5 worksheets (workbooks) shown at the bottom are no longer shown. I know how to use the ribbon to go to VIEW and then click on Full Screen. Now the workbooks are displayed but the ribbon disappears. I need to have of them both visible at the same time. Its probably a mouse click or two but it is very frustrating. Any help someone can provide would be much appreciated.  The computer is an Acer Netbook. It is quite a small screen but is running Windows 10 and no other programs are showing issues.  Thanks.

Answer
Discuss

Answers

0

Please try this:-

  1. From the Ribbon's File tab select Options.
  2. Select Advanced.
  3. Scroll down to Display options for this workbook.
  4. Make sure that Show sheet tabs is checked.
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login