how do I display a worksheeet in full screen view

[Guest]

Worksheets typically display in the full screen view. For some reason
worksheets in a specific excel file are all displaying is view that only
takes up about a third of the screen.

I have tried View > full Screen which does not expand the size of the
worksheet. It expands the Excel program to consume the entire window.
What is required to see the worksheet in full screen or mazimize the
viewing area of the worksheet

 

[Chip Pearson]

Click the Maximize button of the worksheet window, not the Excel
window.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


message
news:[email protected]...

 

[Anne Troy]

Double-click the bar at the top of the worksheet that has the workbook's
name (not the application's bar). You can also try Window-->Arrange, OK.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Guest]

Chip,

Thanks for reply - The problem is Maximum and Restore buttons are not
visible for the worksheet. I can max / min excel but not the worksheet. Any
other suggestions?

PolarBear

 

[Gord Dibben]

Bear

Perhaps that particular workbook has protection enabled on Structure and
Windows.

Unprotect then re-protect with just structure checked. Leave windows
unchecked.


Gord Dibben Excel MVP

 

[Guest]

Gord,

Thanks for the tip. Yes the user had password protected the worksheet. Once
protection was removed the worksheet displayed in full view.

Regards,

PolarBear