The Word97 file named Oak
Products Data.doc holds:
- Resource requirements for each chair type
(for each chair, a column shows how many dowels, rungs, rails, etc.
- Current chair profit levels (in a row with
the label "Unit Profit").
- The parts inventory expected to be on hand
for August (in a column with the label "On Hand").
The contents of the Word file appears
below. Notice that in Word this data is arranged in tabular format.
You build a spreadsheet model in Excel to help you
determine August's most profitable product mix. Although you could start
your worksheet from scratch, you can save data entry time by importing
into Excel some of the data from the Word document.
Open both Excel and Word as full-screen
sessions. (You can shift between them by holding down the ALT key
and pressing the Tab key.)
- In Word, open
the document that holds the tabular data.
- Position the insertion
point in the table of data.
- Click the Table
command in Word's menu.
- Choose Select
Table. Word highlights the entire table (but not the separate
From the menus choose Edit and then
Copy. (Alternatively, click the Copy button on Word's
Standard Toolbar or hit CTRL+C.)
- Switch to Excel by hitting CTRL+TAB until
your Excel session is active.
- Click cell A3 to make it the current cell.
- Select Edit, Paste Special from the
- In the Paste Special dialog box,
select Paste and As Text and click OK.
Each cell in the Word table becomes a cell in the
Excel worksheet. Now you're ready to build the model around this core
set of data.
to Top Next