ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I expand a worksheet? (https://www.excelbanter.com/excel-discussion-misc-queries/114359-how-do-i-expand-worksheet.html)

cubc

How do I expand a worksheet?
 
Hiya,
I built a workbook in Excel 2002. Put it on a flash drive and did some
tinkering with it on another computer. Moved it back using my flash drive.
Now when I open it, I cannot expand it to fill the full Excel screen. I'm
not talking about full screen, just to fill in the window. I don't have the
buttons such as the ones at the top right that allow you to minimize and
maximize a window (or close). All I have is a solid blue border at the top.
How do I fix this. Thanks much.

Dave Peterson

How do I expand a worksheet?
 
It sounds like the workbook is protected.

Tools|Protection|Unprotect workbook
You may need to supply a password.

Tools|Protection|Protect workbook|Check windows
is the way to turn this feature on.

====
If it's not that, maybe the titlebar is just off the visible screen.

Window|Arrange|Tiled (and resize manually)

cubc wrote:

Hiya,
I built a workbook in Excel 2002. Put it on a flash drive and did some
tinkering with it on another computer. Moved it back using my flash drive.
Now when I open it, I cannot expand it to fill the full Excel screen. I'm
not talking about full screen, just to fill in the window. I don't have the
buttons such as the ones at the top right that allow you to minimize and
maximize a window (or close). All I have is a solid blue border at the top.
How do I fix this. Thanks much.


--

Dave Peterson


All times are GMT +1. The time now is 06:12 PM.

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