This is not a frequent problem in Excel, but not unheard of either. There could be several reasons why it’s happening. I noticed it after I started running both Office 2003 and Office 2007 on the same machine. According to some of the Excel expert message boards, a later automatic update of Windows XP or Office may have fixed my problem. There are also recurring themes of Mac Office and dual monitor usage making this a nuisance. After combing the expert message boards, here are several things to try:
1. First, make sure you are running with all current Service Packs. Visit Microsoft.com for more information. If you are using a version of Office older than 2003, you may no longer be getting any bug fixes. So, a more current version is recommended.
2. Open another workbook or two and then switching the active workbook by clicking on the Window menu bar item. Some users have reported that this “eventually” straightens out the problem.
3. Click on Window, then Arrange and choose Tiled. Be sure Windows of active workbook is selected. Maximize one of the windows. Close the others (if any) that are also open. You’ll see these on the Window drop down menu after tiling them.
4. Click on View, then Zoom and change the Zoom setting to 99%.
5. Click on Format, then Row and Unhide, then Format, Column and Unhide. This will make sure rows and/or columns haven’t been accidently hidden.
6. Also, try Format, Sheet, Unhide. If it’s grayed out, it’s not hidden.
If you have also been having this problem, let me know which if any of these worked for you. (By the way to recreate the appearance of the troubled screen, I switched to Page Break Preview, navigated away from cells with any data, then clicked on Tools, then Options and removed the the checkmark from the Row and Column headers checkbox. Just in case you have to “reproduce” the look for your support staff.
Join us in July for two exciting webinars: Integrating Microsoft Office on July 6, 2010 and Microsoft Outlook: Beyond E-mail to E-fficiency.