how do I display a worksheeet in full screen view

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

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


"PolarBear" <PolarBear@discussions.microsoft.com> wrote in
message
news:C43CAB4C-46B5-49D4-9C86-9ABF2B4223AA@microsoft.com...
> 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

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


"PolarBear" <PolarBear@discussions.microsoft.com> wrote in message
news:C43CAB4C-46B5-49D4-9C86-9ABF2B4223AA@microsoft.com...
> 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,

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

"Chip Pearson" wrote:

> 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
>
>
> "PolarBear" <PolarBear@discussions.microsoft.com> wrote in
> message
> news:C43CAB4C-46B5-49D4-9C86-9ABF2B4223AA@microsoft.com...
> > 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
>
>
>

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

On Tue, 5 Jul 2005 08:13:01 -0700, PolarBear
<PolarBear@discussions.microsoft.com> wrote:

>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

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

"Gord Dibben" wrote:

> 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
>
> On Tue, 5 Jul 2005 08:13:01 -0700, PolarBear
> <PolarBear@discussions.microsoft.com> wrote:
>
> >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
>
>