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...
- Excel Window
Maximize, Restore Down, Close (closes Excel)
Minimize, Maximize, Close (closes Excel)
Restore, Maximize, Close [Alt+F4] -- as seen on Right-Click menu
- Workbook Window minimize/maximize options appear immediately below these Excel Window options, if the Workbook window is maximized.
Minimize Window, Restore Window, Close Window (closes Workbook)
Minimize, Maximize, Close (closes Workbook)
Restore Up, Maximize, Close (closes Workbook)
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]
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.
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
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.
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
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.
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)
Ignore Other Applications, turn off to avoid message "the document is already open".
- View, gridlines pertains to display; whereas, page setup, sheets, gridlines pertains to printing.
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.
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.
- For more help with the Excel Window see Help (F1), Answer Wizard (tab), window
- Cell Comments
- Fill-Handle, Filling in an area, The fill-handle is one of the most powerful tools in Excel, and normally alleviates the need to type in formulas similar to the previous lines. Additional techniques for moving rows or columns; and inserting blank rows or columns all using the cursor in combination with the ctrl, shift, or alt keys
- Freeze Panes and Rows/Columns to repeat. When viewing a sheet we usually want to see the descriptive column and row headings anywhere on the sheet whether display or on the printed page. Also see Headings for Columns, and Page Numbering page.
- Grayed Out Menus, etc.
- Gridlines and Borders
- Menus (related: Toolbars, BuildToc)
- Menus and Command Bars , Jon Peltier
- Excel Window, Workbook Window, Worksheet Window, move, restore, minimize, maximize, close
- Menus Excel 97 and Menus Excel 2000 «, both by Kevin Pedersen (descriptions and pictures of menus, all on one page)
- User Interface «, Nick Hodge, Menu Topics: File, Edit, View, Insert, Format, Tools, Data, Window, Help
In order to understand Excel you should be familiar with all of the menus and options. These are new pages and so far will guide you through the File through Format menus. (each menu described on their own pages)
Navigating within a Sheet Properties Shortcut keys in Excel 2000 Status Bar, The Status bar is at the bottom of the Excel spreadsheet and provides useful information from the Excel software or issued from a running macro. If missing it can be restored on Tools --> View. The status bar provides a convenient method of summing a range of cells (SUM not included for a single cell). SUM will not be shown unless at least one of the cells is numeric and at least a second cell has content (not ISBLANK). Some of the other indications are for keys depressed. ¤ If you maintain a checkbook in Excel you can add up deposits for a deposit slip by selecting the range and looking at the SUM= on the status bar. Toolbars, Custom Buttons and Menus Visual Basic Editor (VBE) Window Zoom level, may cause GDI Memory leakage if not maintained at 100% (Excel 97 and earlier) see Slow Response page.
Please send your comments concerning this web page to: David McRitchie send email comments
Copyright © 1997 - 2004, F. David McRitchie, All Rights Reserved