Jan's Illustrated Computer Literacy 101 Logo:Jegsworks Jan's Illustrated Computer Literacy 101


Home > Jan's CompLit 101 > Working with Numbers > Basics > Getting Started > Appearance
Icon: Arrow - Previous pagePrevious    NextIcon: Arrow - Next page

Jan's Working with Numbers

    Excel Basics: Getting Started: Appearance

It can be confusing if your worksheet doesn't look quite like what you see in these lessons. It helps if your Excel window has the same parts showing and is the same size. Unfortunately even if all your settings are the same as mine, the size of your monitor and the resolution that you use can still make your documents look a bit different from the illustrations. Don' t let it make you too crazy!

Sample looks:

Document maximized (Excel 2010)

Standard look: Excel window with workbook window maximized
Window is wide enough to show all parts of Home ribbon tab.
  
Small window with compressed ribbon (Excel 2010)

Small window: Home ribbon tab must compress to fit window

Smal workbook window; minimized workbook window (Excel 2010) 

Excel 2007, 2010: Small workbook window and a minimized workbook window.

Blank maximized sheet with two task panes, Clipboard & Clip Art (Excel 2010)

Two task panes showing


Icon Step-by-Step 

Step-by-Step: Appearance

 Icon Step-by-Step

What you will learn: to match window appearance -
    window size
    document window size
    view used
    zoom amount

Start with: Icon - Excel with blank document (a blank workbook)

  1. If necessary, open Excel to a blank workbook.
  2. Window control buttons on the Title bar (Excel 2016)

    Window control buttons on the Title bar (Excel 2013) Window control buttons on the Title bar (Excel 2010)Excel Window Maximized or Not:
    If necessary, click the Maximize button Button: Maximize Excel (Excel 2010) Button: Maximize Excel (Excel 2013) Button: Maximize Excel (Excel 2016) in the Title bar of the Excel window to make it take up the whole Desktop area.
    You usually need all of the display space you can get for spreadsheets!

  3. Click the Restore button Button: Restore (Excel 2010) Button: Restore (Excel 2016) on the Title bar of the Excel window to return the window to its previous size. Drag the edges of the window to a convenient size.

    Title bar for Excel window & workbook window - Restore buttons (Excel 2010)Icon: Excel 2007 Icon: Exel 2010 Excel 2007, 2010: These versions allow multiple worksheet windows inside the Excel window. Each of those windows has its own control buttons. Be careful to click the one you mean to click.

    Your window may have different proportions than the illustrations and may show more or fewer ribbon buttons. Illustrations in the lessons sometimes show a window that is smaller than would be comfortable to work with to save space on the lesson page.

  4. Window controls on worksheet window (Excel 2010)Icon: Excel 2007 Icon: Exel 2010 Excel 2007, 2010: Workbook Window Maximized
    within the Excel window:
    If necessary, click the Maximize button Button: Maximize worksheet (Excel 2010) in the workbook title bar to see only one open workbook.
    The window control buttons when the workbook is maximized are underneath the control buttons for the overall Excel window, beside the Help button.
    Later, when you wish, you can use the Restore button Button: Restore worksheet window (Excel 2010) in the workbook title bar to return the workbook window to its previous size so you can see more than one open workbook in the same window.
  5. Status Bar: Normal view and 100% zoom (Excel 2010)Use Normal view Button: Normal view - Status bar (Excel 2010).
    The view button on the Status bar is highlighted in color for the current view.
  6. Set Zoom = 100% (the default) on the Status Bar.

Excel window and worksheet window - not maximized

Excel window is not maximized; worksheet window is not maximized.
Excel 2007 and 2010 put each workbook into a window inside the Excel window.

Excel window maximized in Win10 (Excel 2016)

Excel window maximized
Excel 2013 and 2016 use separate windows for each workbook.