Microsoft Office Tutorials and References
In Depth Information
Moving a Worksheet
You can change the placement of the worksheets in the workbook. To move the position
of a worksheet in the workbook, click the sheet tab and then drag and drop it to a new
location relative to the other worksheets. You can also make a copy of a worksheet using a
similar drag-and-drop technique. To create a copy of a worksheet, press the Ctrl key as
you drag and drop the sheet tab of the worksheet you want duplicated.
Moving or Copying a Worksheet
Click the sheet tab of the worksheet you want to move (or copy).
Drag the sheet tab along the row of sheet tabs until the small arrow appears in the new
location. To create a copy of the worksheet, press and hold the Ctrl key as you drag the
sheet tab to the new location.
Release the mouse button. Release the Ctrl key if necessary.
Try this now by switching the location of the Documentation and Orders worksheets.
To reposition the worksheets:
1. Click the Orders tab, and then press and hold the left mouse button so the pointer
and a small arrow appears in the upper-left corner of the tab.
2. Drag the pointer to the left of the sheet tab for the Documentation sheet, and then release
the mouse button. The Documentation sheet is now the second sheet in the workbook, but
Sandra would prefer that the documentation sheet be the first sheet.
3. Click the Orders tab, and then drag the sheet tab to the right of the Documentation sheet
tab to place it back in its original location.
When you create a copy of a worksheet, you move the copy of the original worksheet
to a new location, while the original sheet remains at its initial position.
Using the Spell Checker
One of Excel’s editing tools is the Spell Checker . This feature checks the words in the
workbook against the program’s internal dictionary. If the Spell Checker comes across a
word not in its dictionary, it displays the word in a dialog box along with a list of sug-
gested replacements. You can replace the word with one from the list, or you can choose
to ignore the word and go to the next word that might be misspelled. You can also add the
word to the dictionary to prevent it from being flagged in the future. There are words that
are not included in the online dictionary (for example, some uncommon personal names
or last names). The Spell Checker will stop at these words. You can then choose to ignore
all occurrences of the word, change the word, or add the word to the dictionary. Excel
checks the spelling on the current worksheet only.
To see how the Spell Checker works, you’ll make an intentional spelling error in the