|
Avoid Truncating Data In earlier versions of Office, you risked truncating data when you copied records from an Access table to an Excel worksheet. The solution was to use the Excel Paste Special command instead of Ctrl-V to paste the data to the spreadsheet. Office 2000 doesn't truncate the data, but Paste Special and Ctrl-V don't copy the data exactly the same way. If you use the Paste Special command, Excel cells will accommodate each field entry. In contrast, if you use Ctrl-V, Excel will increase the cell's depth (row height) rather than the width. If an entry is too wide for the current column setting, Excel will increase the row's height accordingly. If you manually decrease the row's height, Excel will force the entry onto one line.
|
||||
 |
|
 |
||
| Tips Index | ||||
