|
3.642 bytes |
Service Hints & Tips |
Document ID: DJON-3F6FQ9 |
Aptiva - Can I copy a column of numbers in Works without copying their formulas?
Applicable to: World-Wide
To copy a column of numbers without moving the underlying formulas:
1) Use the "Copy Special..." option from the "Edit" menu.
2) Highlight those cells that you want to copy.
3) Choose EDIT and then COPY SPECIAL command.
4) Indicate the new position and press [ENTER],
5) Choose "OK" for "Values Only". This will copy the data only and leave the formulas in their original places.
If you choose to copy formulas, you can keep the cell addresses from changing when you copy formulas by inserting a "$" before the part (or each part) of the address you wish to keep the same. If you have a dollar sign in the cell address ($C$10, for example), it will prevent that formula from changing when you copy it.
|
Search Keywords |
Works | |
|
Hint Category |
Productivity Software | |
|
Date Created |
01-04-97 | |
|
Last Updated |
09-12-98 | |
|
Revision Date |
09-12-99 | |
|
Brand |
IBM Aptiva | |
|
Product Family |
Aptiva, PS/1 | |
|
Machine Type |
2011, 2121, 2123, 2133, 2155, 2168, 2144 | |
|
Model |
C01; C34; M01; NEA; T35; U35; A62; A82; A94; B82; C42; C92; G42; M82; S92; 081; 087; 131; 137; K37; N31; N81; 11E; 13T; 14C; 16E; 17A; 18A; 18T; 19C; 21C; 23C; 28A; 46M; 51D; D50; G11; G13; G43; G46; G46; G49; G49; G50; G53; M40; M40; M46; M46; P11; P13; P43; P50; P53; R04; R05; R06; R09; R38; R42; R43; R44; R84; R86; R87; RO3; S11; S13; S43; S45; S45; S47; S47; S48; S48; S50; S53; W11; W13; W42; W42; W43; W45; W45; W50; W53; 20E; 22T; 24C; 24M; 28V; 39E; 41T; 43C; 45V; 48E; 50T; 52C; 55V; 72E; 74T; 76C; 78C; 79C; 81A; 82E; 84T; 86C; 87C; CC1; D53; G14; G44; G52; G54; G72; G76; G78; G82; NM1; P14; P44; P57; P71; P74; P76; P78; P84; R14; R15; R16; R17; R18; R51; R52; R57; R58; R62; R63; R67; R71; R89; R93; R96; R97; S14; S44; S50; S54; S70; S75; S76; S78; S80; W14; W44; W48; W54; W67; W76; W77; W78; Z33; 28V; 31E; 33T; 37C; 38C; 51E; 54T; 56C; 57C; 88V; BB1; G57; G87; OR1; OR3; OR4; OR5; P89; R28; R29; R31; R74; R78; R82; R98; S55; S85; SR1; US1; W52; W82; 1R2; 66P; 67P; 86P; OR8; 1R1; 1R3; 1R5; 22P; 24P; 25P; 27P; 29P; 63P; 67P; 82P; 83P; OR6; OR7; OR9; 1R0; 1R1; 26P; 62P; 2R0; P30; 2R3; S15 | |
|
TypeModel |
| |
|
Retain Tip (if applicable) |
| |
|
Reverse Doclinks |