Unable to Join Spreadsheets Using Select All (79974)
The information in this article applies to:
- Microsoft Works 2.0
- Microsoft Works 2.0a
- Microsoft Works 3.0
This article was previously published under Q79974 SUMMARY
Currently the only way to join two Works for Windows spreadsheets or
databases is to copy one spreadsheet or database and append it to the
second one by using the paste function. When copying one spreadsheet
or database to another, the following keystrokes should be used to
select the spreadsheet, rather than using the Select All command from
the Select menu.
Note: These procedures should be done in List view when joining two
databases.
- CTRL+HOME (Makes A1 the active cell)
- CTRL+SHIFT+END (Selects from the active cell to the end of the
spreadsheet)
MORE INFORMATION
Using Select All to select the spreadsheet to be copied will select
all 16,384 rows or in the database select all 32000 records and not
just the area on the spreadsheet or database that contains data.
Therefore, when this information is copied and pasted to the second
file, all of the second spreadsheet or database will be replaced with
the 16,384 copied rows or 32000 records. This occurs regardless of the
position of the active cell when the paste is executed.
REFERENCES
"Microsoft Works for Windows User's Guide", version 3.0.
- Spreadsheet page 175.
- Database page 333.
"Microsoft Works for Windows User's Guide", version 2.0, page 148,
| Modification Type: | Major | Last Reviewed: | 10/6/2003 |
|---|
| Keywords: | KB79974 |
|---|
|