I have a workbook that is only about 1/2 screen size, vertical and
horizontal. It does not have the 3 buttons at the top right corner for
minimize, enlarge/reduce and close. I can only get to the worksheet tabs
when I select View - Full Screen. I also cannot get to the left/right page
shift bar at the bottom unless I am in Full Screen mode. When placing the
cursor at the edges, it does not change to the double arrow which would allow
the page to be pulled out (enlarged). What could be the problem and/or
resolution to get this to be a normal workbook page with the options replaced
that are normally there?
--
ALH

Try this, Arden: Open the workbook. Hit Window--Arrange, and then just hit
OK. Then double-click the blue bar at the top of the column letters to get
it back to "normal" Excel view.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Arden" wrote in message
...
I have a workbook that is only about 1/2 screen size, vertical and
horizontal. It does not have the 3 buttons at the top right corner for
minimize, enlarge/reduce and close. I can only get to the worksheet tabs
when I select View - Full Screen. I also cannot get to the left/right
page
shift bar at the bottom unless I am in Full Screen mode. When placing the
cursor at the edges, it does not change to the double arrow which would
allow
the page to be pulled out (enlarged). What could be the problem and/or
resolution to get this to be a normal workbook page with the options
replaced
that are normally there?
--
ALH

Thanks, Anne. However that didn't clear the problem. As you said I did
Window--Arrange. Then there are 4 options. I tried using all 4 at various
attempts and also checked and unchecked the Bottom Item regarding the
Workbook. After clicking on OK each time, I double-clicked on the solid blue
bar above the letters that has the file name to the left within it. I got no
results. When double-clicking on that bar I attempted to move the entire
worksheet, but had no success there either. In the past I had also tried
saving this info to a new file, but it opens with the new named file with the
identical problem. Other Excel files seem to open in the normal window mode.
I don't know what else I could tell you that might give you a clue as to
what is wrong.

Thanks again for your help
--
ALH


"Anne Troy" wrote:

Try this, Arden: Open the workbook. Hit Window--Arrange, and then just hit
OK. Then double-click the blue bar at the top of the column letters to get
it back to "normal" Excel view.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Arden" wrote in message
...
I have a workbook that is only about 1/2 screen size, vertical and
horizontal. It does not have the 3 buttons at the top right corner for
minimize, enlarge/reduce and close. I can only get to the worksheet tabs
when I select View - Full Screen. I also cannot get to the left/right
page
shift bar at the bottom unless I am in Full Screen mode. When placing the
cursor at the edges, it does not change to the double arrow which would
allow
the page to be pulled out (enlarged). What could be the problem and/or
resolution to get this to be a normal workbook page with the options
replaced
that are normally there?
--
ALH

It sounds like your workbook is protected.

Try tools|protection|unprotect workbook
(you may need to provide the password)

Arden wrote:

I have a workbook that is only about 1/2 screen size, vertical and
horizontal. It does not have the 3 buttons at the top right corner for
minimize, enlarge/reduce and close. I can only get to the worksheet tabs
when I select View - Full Screen. I also cannot get to the left/right page
shift bar at the bottom unless I am in Full Screen mode. When placing the
cursor at the edges, it does not change to the double arrow which would allow
the page to be pulled out (enlarged). What could be the problem and/or
resolution to get this to be a normal workbook page with the options replaced
that are normally there?
--
ALH

--

Dave Peterson

I have exactly the same problem, yet document is not protected and never has
been.

"Dave Peterson" wrote:

It sounds like your workbook is protected.

Try tools|protection|unprotect workbook
(you may need to provide the password)

Arden wrote:

I have a workbook that is only about 1/2 screen size, vertical and
horizontal. It does not have the 3 buttons at the top right corner for
minimize, enlarge/reduce and close. I can only get to the worksheet tabs
when I select View - Full Screen. I also cannot get to the left/right page
shift bar at the bottom unless I am in Full Screen mode. When placing the
cursor at the edges, it does not change to the double arrow which would allow
the page to be pulled out (enlarged). What could be the problem and/or
resolution to get this to be a normal workbook page with the options replaced
that are normally there?
--
ALH

--

Dave Peterson

Hi folks,

What it sounds like you've got is a full-screen workbook that's been positioned so that its right & lower sides are off the screen.
Try clicking Window|Arrange|OK to reposition the worksheet.

Cheers

--
macropod
[MVP - Microsoft Word]


"H." wrote in message ...
| I have exactly the same problem, yet document is not protected and never has
| been.
|
| "Dave Peterson" wrote:
|
| It sounds like your workbook is protected.
|
| Try tools|protection|unprotect workbook
| (you may need to provide the password)
|
| Arden wrote:
|
| I have a workbook that is only about 1/2 screen size, vertical and
| horizontal. It does not have the 3 buttons at the top right corner for
| minimize, enlarge/reduce and close. I can only get to the worksheet tabs
| when I select View - Full Screen. I also cannot get to the left/right page
| shift bar at the bottom unless I am in Full Screen mode. When placing the
| cursor at the edges, it does not change to the double arrow which would allow
| the page to be pulled out (enlarged). What could be the problem and/or
| resolution to get this to be a normal workbook page with the options replaced
| that are normally there?
| --
| ALH
|
| --
|
| Dave Peterson
|

I have a dual monitor and when I move files to the extended monitor, it
defaults to leaving them there. Now whenever I open an excel file, the
screen is blank because the file is always way off to the right of the
default monitor. How can I change the default location of the files to be
back on the lefthand monitor again?

"macropod" wrote:

Hi folks,

What it sounds like you've got is a full-screen workbook that's been positioned so that its right & lower sides are off the screen.
Try clicking Window|Arrange|OK to reposition the worksheet.

Cheers

--
macropod
[MVP - Microsoft Word]


"H." wrote in message ...
| I have exactly the same problem, yet document is not protected and never has
| been.
|
| "Dave Peterson" wrote:
|
| It sounds like your workbook is protected.
|
| Try tools|protection|unprotect workbook
| (you may need to provide the password)
|
| Arden wrote:
|
| I have a workbook that is only about 1/2 screen size, vertical and
| horizontal. It does not have the 3 buttons at the top right corner for
| minimize, enlarge/reduce and close. I can only get to the worksheet tabs
| when I select View - Full Screen. I also cannot get to the left/right page
| shift bar at the bottom unless I am in Full Screen mode. When placing the
| cursor at the edges, it does not change to the double arrow which would allow
| the page to be pulled out (enlarged). What could be the problem and/or
| resolution to get this to be a normal workbook page with the options replaced
| that are normally there?
| --
| ALH
|
| --
|
| Dave Peterson
|