ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Workbook cannot be expanded to fill screen (https://www.excelbanter.com/excel-discussion-misc-queries/166665-workbook-cannot-expanded-fill-screen.html)

Karen

Workbook cannot be expanded to fill screen
 
Using Office 2003 as well as Office 2007
Workbook is missing the restore down/up/and close buttons to enable changing
the size of the screen. It does not have the resizer in the bottom right.
Double clicking in top bar does not work.

The Microsoft Excel Toolbar does have the buttons however this does not have
an effect on the workbook "inside" the window. Not sure how to fix.
--
Karen

Elkar

Workbook cannot be expanded to fill screen
 
Perhaps the controls have just been obscured behind toolbars and such. Try
this:

In Excel 2003:

Go to the Window Menu
Choose "Arrange"
Choose "Tiled"
Click OK

In Excel 2007:

Go to the View Tab
In the Window Section, choose "Arrange All"
Choose "Tiled"
Click OK

HTH,
Elkar


"Karen" wrote:

Using Office 2003 as well as Office 2007
Workbook is missing the restore down/up/and close buttons to enable changing
the size of the screen. It does not have the resizer in the bottom right.
Double clicking in top bar does not work.

The Microsoft Excel Toolbar does have the buttons however this does not have
an effect on the workbook "inside" the window. Not sure how to fix.
--
Karen


Gord Dibben

Workbook cannot be expanded to fill screen
 
If the workbook is protected and "Windows" is checked when protecting you will
not see those icons.

ToolsProtectionUnprotect Workbook.


Gord Dibben MS Excel MVP


On Mon, 19 Nov 2007 15:45:00 -0800, Karen
wrote:

Using Office 2003 as well as Office 2007
Workbook is missing the restore down/up/and close buttons to enable changing
the size of the screen. It does not have the resizer in the bottom right.
Double clicking in top bar does not work.

The Microsoft Excel Toolbar does have the buttons however this does not have
an effect on the workbook "inside" the window. Not sure how to fix.



Dave Peterson

Workbook cannot be expanded to fill screen
 
Maybe the workbook's windows are protected.

In xl2003, it's:
tools|Protection|Protect workbook|Uncheck Windows



Karen wrote:

Using Office 2003 as well as Office 2007
Workbook is missing the restore down/up/and close buttons to enable changing
the size of the screen. It does not have the resizer in the bottom right.
Double clicking in top bar does not work.

The Microsoft Excel Toolbar does have the buttons however this does not have
an effect on the workbook "inside" the window. Not sure how to fix.
--
Karen


--

Dave Peterson


All times are GMT +1. The time now is 03:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com