Excel Window, Workbook Window, Worksheet Window

Location: http://www.mvps.org/dmcritchie/excel/excelwindow.htm      
Home page: http://www.mvps.org/dmcritchie/excel/excel.htm
[View without Frames]

Excel Window and Workbook Window(s)

Minimize, Maximize or Restore, Close buttons in upper right corner (#minmax)

The Excel window, the Workbook window, and the Worksheet Window all have three buttons in the upper-right corner depending on current status the three buttons may have fly over tool tips as in the...

Function Keys to control worksheet size (#pfk)

Ctrl+F7 to move worksheet unless maximized, Ctrl+F9 to minimize from restored or Maximized
[more information on shortcuts]

Full Screen Mode   (#fullscreen)

In addition to the above the Excel Window can be maximized to Full Screen mode (View, Full Screen) and can be Restored with View, Full Screen to turn off, or with Alt+SpaceBar and then Restore menu option

Full Screen Mode has it's own set of menu options.  Sometimes the menus are not visible, to get to the view menu you can the use ALT keys to invoke the menus one by one.  Alt+V then continue.  Appears that Excel 2000 does not allow suppress the menu bar. (Tools, Customize...), but the formula bar may be suppressed (View, Formula Bar). or the Status Bsr could be suppressed (View, Status Bar.

Minimize, Maximize/Restore, Close buttons (#minmax)  

min/max/close The Windows shortcut key ALt+SpaceBar,  Displays the System menu for the active window, brings up this menu and you can move the window with the arrow keys even if the title bar is hidden behind the top of the screen.  Don’t confuse hidden title bar with Full Screen View (F11) in Excel where there is no Title Bar.

Menu at right is what you see from right click on title bar, or on the frame of a window, or Alt+SpaceBar from a Windows window.

Menu at far right is what you see from right click of the workbook title bar, on on the frame of the workbook window, or Alt+minus from an Excel workbook window.

See Moving a Window (below) for more information on moving a system window or an Excel window.

2 Restore
Move
Size
0 Minimize
1 Maximize

r Close Alt+F4 
RClick on Title Bar
  *

Moving a Window (#move)

Windows such as the Excel Window, and the workbook Window(s) within Excel can be moved around by Right clicking and dragging the window.  Sometimes the window gets moved so that the blue title bar is hardly visible or can't be dragged from top or upper corners.  To solve that
   Alt+Spacebar   for Excel Window, or
   Alt+minus         for Workbook Window   (with NumLock key OFF)
look at the menu, choose Move, then move the window around with arrow keys.

Another somewhat less effective way to move the workbook frame around within the Excel window is to right click on the frame of the workbook and choose Arrange then horizontal, next repeat Arrange with Tiled.  You get same right click menu from titlebar and Excel logo within a non maximized workbook window.

Move and Resize Window with a Macro (#resize)

Recording a macro can get you started, some results from recording a macro.
Sub Macro17()
    Application.Top = 88.75
    Application.Left = 111.25
    Application.Width = 598.5
    Application.Height = 369
End Sub
 
Sub Macro15()
    'you can use xlMaximized, xlNormal, xlMinimized
    Application.WindowState = xlMaximized
    Application.WindowState = xlNormal
    ActiveWindow.WindowState = xlNormal
    ActiveWindow.WindowState = xlMaximized
End Sub

Blue Title Bar for Excel is Missing (#titlebar)

You are in full screen mode, and neither the Excel Window nor the Excel Spreadsheet will show a Title Bar -- turn off full-screen mode and Restore Window (see #move above), or use Alt+SpaceBar, Restore.

Blue Title Bar for Workbook is Missing

You have maximized the worksheet so that only one worksheet is visible.  Use the Restore Window button (middle of the three window buttons) for Worksheet (see #move above), or use Alt+minus, Restore.

Note:=  Most people will have the Workbook maximized to view a single sheet, and use the Window menu to bring a specific worksheet to the top.  Worksheet selections are at the bottom of the Window menu.  ( [picture] as seen on toolbars page with customizations)

Tools, Options Menu, some selected topics (#options)

Window Menu in Excel (#windowmenu)

*

New Window allows you to see more than one sheet of a workbook including the ability to see different view of a same sheet.  This is strictly viewing what you see on one sheet is the same as viewing the same sheet from a different view.  You will see a number attached to the workbook name.  i.e. Book1.xls:1 and Book1.xls:2 to eliminate the extra view, close the worksheet with the close button in upper right corner not the topmost one, which would close Excel itself [See Viewing Multiple Windows of Excel]

Arrange Windows within Excel choose from Tiled, Horizontal, Vertical, or Cascade.  separate option to limit this to the current workbook.

Hide and Unhide> do what they say.  The main reason to Hide a sheet is so the macros in your personal workbook will be found, but to work on a workbook to changes its options, or spreadsheet contents, or to Edit a macro from the Macro Dialog menu you must Unhide the workdbook.  Without unhiding you can use Step Into, ALT=F11, or use a macro to go to a specific macro module.

Split and Freeze Panes are mutually exclusive with each other, and pertain to splitting a view, or displaying header rows from top, row headers from left, more information on my Freeze web page, which also includes similar information for printing headers controlled from page setup, sheets.

List of Workbooks, choose here to bring a workbook or a view of a workbook to the top.

Zoom Level   (#zoom)

Tool bar zoom control is the normal way to zoom, or from menu with View, Zoom.  Hold Ctrl and roll mouse wheel.  Another way (not recommended) is another.  Tools, Options, General (tab), Zoom on roll with Intellimouse, which overrides your system mouse setting for the scroll wheel.  Use of versions prior to Excel 2000 may be advised to keep zoom at 100% see related below.
This page was introduced on January 5, 2003. 

[My Excel Pages -- home]    [INDEX to my site and the off-site pages I reference] 
[Site Search -- Excel]     [Go Back]    [Return to TOP

Please send your comments concerning this web page to: David McRitchie send email comments


Copyright © 1997 - 2004,  F. David McRitchie,  All Rights Reserved