Strange Display Issue - small table

[SoxFaninVA]

I have encountered an Excel file where the table has been resized to about
1/4 of the size of the main Excel window. See here for a screencap:
http://drop.io/5uv2svl/asset/strange-excel-display-jpg

I have looked at all the settings in Excel and can't figure out how to make
the table go back to full screen. This appears in both Excel 2003 and 2007.

Any ideas?

Thanks,
Tom

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

 

[Gord Dibben]

Perhaps the workbook has been protected.

Tools>Protection>Unprotect Workbook.


Gord Dibben MS Excel MVP

 

[SoxFaninVA]

I tried that shortly after posting my original msg and that was the ticket!
I didn't think protection changes the display. Oh well, mystery solved!