AccessMyLibrary provides FREE access to millions of articles from top publications available through your library.

Don't retype...replicate. (Copy command eases data-entry chores)(Start Here) (tutorial)

Lotus

| July 01, 1990 | Gasteiger, Daniel | COPYRIGHT 1987 Lotus Publishing Corp. (Hide copyright information)Copyright

Don't Retype... Replicate

A worksheet often contains data in one location that must also appear elsewhere in the worksheet. For example, in a database, the field names entered as part of the Input range must also appear in the Criterion and Output ranges. Retyping entries not only wastes time but it threatens to introduce errors that may affect a model's performance.

The Copy command is specifically designed to duplicate worksheet data. You issue the command and instantly, 1-2-3 can copy hundreds of cells to a new location. In 1-2-3 Releases 2.01 and 2.2, that location will be on the same worksheet. But in 1-2-3 Release 3, the destination might even be another worksheet or file currently in memory.

SINGLE CELLS ARE SIMPLE

At this simplest, the Copy command duplicates the contents of a source cell in a target cell. When you press the slash key and select Copy, 1-2-3 prompts you to specify a source range, which is the cell or range of cells containing the data you …

Related articles from newspapers, magazines, journals, and more
Getting around. (Symphony Macros) (techniques to move cell pointer about on...
Magazine article from: Lotus Gasteiger, Daniel November 1, 1988 700+ words
Modify the worksheet: the Copy and Move commands, as well as the EDIT key,...
Magazine article from: Lotus Conatser, Kelly R. May 1, 1991 700+ words
Where did I stash that worksheet? Build an instant index to help you find all...
Magazine article from: Lotus Dake, Glen L. September 1, 1989 700+ words
More tips on using Lotus products. (Good Ideas)
Magazine article from: Lotus May 1, 1989 700+ words
Hey, good lookin'; spruce up your output with the Worksheet Column Set-Width...
Magazine article from: Lotus Conatser, Kelly R. July 1, 1991 700+ words
©2013 Gale, a part of Cengage Learning. All rights reserved. Contact us | Privacy policy | Terms and conditions

The AccessMyLibrary advertising network includes: womensforum.com GlamFamily