Microsoft Office Tutorials and References
In Depth Information
Navigating Between Worksheets
To start Excel:
1. Click the Start button on the taskbar, click All Programs , click Microsoft
Office , and then point to Microsoft Excel 2010 .
Trouble? If you don’t see Microsoft Excel 2010 on the Microsoft Office submenu,
look for it on a different submenu or on the All Programs menu. If you still cannot
find Microsoft Excel 2010, ask your instructor or technical support person for help.
2. Click Microsoft Excel 2010 . The Excel window opens.
All the figures showing the Excel window in these tutorials are zoomed to 120%
for better readability. If you want to zoom your Excel window to match the
figures, complete Step 3. If you prefer to work in the default zoom of 100% or at
another zoom level, continue with Step 4; you might see more or less of the
worksheet on your screen, but this does not affect your work in the tutorials.
3. If you want your Excel window zoomed to match the figures, click the Zoom In
button on the status bar twice to increase the zoom level to 120%. The
120% magnification increases the screen size of each cell, but reduces the number
of worksheet cells visible in the workbook window.
4. If necessary, click the Maximize button
on the Excel window title bar. The
Excel window fills the screen.
By default, Excel starts with a blank workbook maximized to ﬁ ll the Excel window.
The name of the active workbook, Book1, appears in the title bar. You can open more
than one workbook window at a time to display the contents of different workbooks. You
can also open multiple workbook windows for one workbook to display different views
of the workbook’s contents.
Navigating Between Worksheets
A workbook can have two kinds of sheets: worksheets and chart sheets. A worksheet
contains a grid of rows and columns into which the user enters data values and formulas.
A chart sheet contains an Excel chart that provides a visual representation of worksheet
data. Charts can also be embedded within worksheets, displaying both the data and
charts in one sheet. By default, all new Excel workbooks are created with three
worksheets named Sheet1, Sheet2, and Sheet3. The Sheet1 worksheet is the active sheet.
Multiple sheets enable you to better organize data in the workbook. For example, a
sales report workbook might have a different worksheet for each sales region and another
worksheet that summarizes the results from all the regions.
Some workbooks contain so many sheets that their sheet tabs cannot all be displayed
at the same time in the workbook window. For these workbooks, you can scroll through
the sheet tabs using the sheet tab scrolling buttons. Scrolling through the sheet tabs does
not change the active sheet. To change the active sheet, you must click a sheet tab.
To change the active sheet:
1. Click the Sheet2 sheet tab. The Sheet2 worksheet, which is also blank, becomes
the active worksheet. The Sheet2 tab is white, indicating this worksheet is active.
You can also move to the
previous or next sheet by
pressing the Ctrl+Page Up
or Ctrl+Page Down keys.
2. Click the Sheet3 sheet tab. The Sheet3 worksheet becomes the active worksheet.
3. Click the Sheet1 sheet tab to return to the first worksheet.