« I ♥ ☼ | Main | 10 things about Library Online »

How to fix a reoccurring Excel problem

Have you ever opened your monthly Circulation Statistics spreadsheet and found that all of the sheet tabs, that are usually on the bottom, are missing?  If you have then I have a solution for you.

The cause of this problem is that your screen resolution is higher than that of the person who created the spreadsheet.  This causes the spreadsheet to unhook from the Excel window and makes it look like a window within Excel.  Click on the graphic below to see a sample of what it looks like.

Excel_Before 
To fix this problem all you have to do click on the Restore Window button, the middle button, in the trio of buttons found in the upper right-hand corner of the title bar of the window containing the data.  You can also double-click the window's title bar.  Once you do that the sheet tabs should now be at the bottom again.  Click on the graphic below to see what it looks like once it's fixed.

Excel_After 

Comments

Feed You can follow this conversation by subscribing to the comment feed for this post.

Post a comment