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!
Standard look: Excel window with workbook window maximized
Window is wide enough to show all parts of Home ribbon tab.
Small window: Home ribbon tab must compress to fit window
Excel 2007, 2010: Small workbook window and a minimized workbook window.
Two task panes showing
![]() |
Step-by-Step: Appearance |
![]() |
What you will learn: | to match window appearance - window size document window size view used zoom amount |
Start with: (a blank
workbook)
Excel Window
Maximized or Not:
If necessary, click the Maximize button
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!
Click the Restore button
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.
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.
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
Excel 2013 and 2016 use separate windows for each workbook.