Microsoft KB Archive/79974

= Unable to Join Spreadsheets Using Select All =

Article ID: 79974

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition

-



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.


 * 1) CTRL+HOME (Makes A1 the active cell)
 * 2) 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.

