Contents
The Excel 2007 Interface
Keyboard Shortcuts in Excel 2007
How to Create New Spreadsheets and Open Existing Spreadsheets
How to Save and Close an Excel Spreadsheet
How to Navigate an Excel 2007 Spreadsheet
Basic Cell Operations in Excel
Excel Formulas and Functions
How to Use Excel’s Fill Feature
How to Sort Data in Excel
How to Format Cells in Excel
How to Format Excel Spreadsheets
How to Add Charts or Graphics to Excel Spreadsheets
How to Print Excel Spreadsheets
|
 |
 |
 |
|
How to Navigate an Excel 2007 Spreadsheet
To work effectively in Excel, it’s helpful to know how to navigate around the Excel work space. You can navigate around a spreadsheet in two main ways:
- Scroll by moving the right and bottom scrollbars with your mouse.
- Use keyboard commands to move the active cell around the spreadsheet.
To move . . . |
Press . . . |
|
Down one cell |
Enter |
|
One cell to the right |
Tab |
|
One cell up, down, left, or right |
Arrow Keys |
|
To the edge of the data region |
Ctrl+Arrow Key |
|
To column A in the current view |
Home |
|
To cell A1 |
Ctrl+Home |
|
To the last cell in the spreadsheet containing data or text |
Ctrl+End |
|
Up one screen |
Page Up |
|
Down one screen |
Page Down |
|
Left one screen |
Alt+Page Up |
|
Right one screen |
Alt+Page Down |
You can also move to a specific cell in a spreadsheet by typing the cell’s column and row number into the Name box.
How to Navigate Between Spreadsheets
An Excel document is also called a workbook because it contains more than one spreadsheet. You can navigate between different spreadsheets in a workbook by using the spreadsheet tabs at the bottom left of the Excel window.
To move from one spreadsheet in a workbook to the next, just click on a spreadsheet's tab.
Other Uses for the Spreadsheet Tabs
In addition to navigation, you can use the spreadsheet tabs to perform a number of other actions:
- Rename a spreadsheet: Either double-click the tab or right-click the tab and then choose Rename from the shortcut menu.
-
Insert a new spreadsheet: Click the New Spreadsheet tab
or double-click a tab and choose Insert from the Shortcut menu. The new spreadsheet tab will appear to the left of the tab
that you right-clicked. - Delete a spreadsheet: Right-click the Sheet tab and choose Delete. When you delete a spreadsheet, all data (if any) in that spreadsheet is lost.
- Rearrange the order of a spreadsheet: You can reorder the tabs by clicking and dragging them.
- Move or copy a spreadsheet: Right-click the tab and choose Move or Copy. You can choose to move the tab within the existing workbook or to another open workbook. To copy rather than move the tab, click the Create a Copy box in the Move or Copy dialog box.
How to Zoom in Excel
Because Excel spreadsheets can get very large, it’s helpful to be able to zoom in on a particular area of the spreadsheet to do detailed work or zoom out to get a better sense of the big picture. Excel gives you two ways to zoom: the zoom group and the zoom slider.
-
Zoom group: You can use the buttons on the zoom tab to zoom in on selected cells, zoom to a 100% view of the spreadsheet (the size it will be when printed), or click on the magnifying glass to open the zoom dialog box, which has more zooming options.
-
Zoom slider: This is a sliding bar located at the bottom right of the Excel window. Click on the + or – or drag the slider to zoom in or out.
| Acknowledgments & Disclaimer |
