/ PC World Komputer 1997 November / Pcwk1197.iso / LOTUS / Eng-ins / 123 / SHEETEN.DLL / 303 / 65

< prev

view JSON data

view as text

open on a Mac

open on a PC

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 0c 00 02 00 00 01 01 00 | 00 00 06 00 80 00 00 00 |........|........|
|00000010| 31 01 00 00 c9 01 c8 0b | 1b 02 d3 0b 27 03 00 00 |1.......|....'...|
|00000020| 75 03 00 00 f2 03 e4 0b | f7 04 00 00 79 05 00 00 |u.......|....y...|
|00000030| d8 05 00 00 51 06 00 00 | 82 06 00 00 51 07 00 00 |....Q...|....Q...|
|00000040| 0a 08 00 00 37 08 e7 0b | a2 08 e7 0b 04 09 e7 0b |....7...|........|
|00000050| 6c 09 00 00 9f 09 00 00 | cc 09 00 00 99 0a 00 00 |l.......|........|
|00000060| 52 0b 00 00 fe 0b 00 00 | 05 0d 00 00 58 0d 00 00 |R.......|....X...|
|00000070| d8 0d 00 00 3f 0e 00 00 | b8 0e 00 00 17 0f 00 00 |....?...|........|
|00000080| 43 65 6c 6c 20 69 73 20 | 6e 6f 74 20 69 6e 20 73 |Cell is |not in s|
|00000090| 65 6c 65 63 74 69 6f 6e | 2e 0a 0a 54 68 65 20 61 |election|...The a|
|000000a0| 63 74 69 76 65 20 63 65 | 6c 6c 20 69 73 20 65 69 |ctive ce|ll is ei|
|000000b0| 74 68 65 72 20 6e 6f 74 | 20 69 6e 20 74 68 65 20 |ther not| in the |
|000000c0| 63 75 72 72 65 6e 74 20 | 73 65 6c 65 63 74 69 6f |current |selectio|
|000000d0| 6e 20 6f 72 20 61 6e 20 | 6f 70 74 69 6f 6e 61 6c |n or an |optional|
|000000e0| 20 72 61 6e 67 65 20 61 | 72 67 75 6d 65 6e 74 20 | range a|rgument |
|000000f0| 69 73 20 6e 6f 74 20 73 | 70 65 63 69 66 69 65 64 |is not s|pecified|
|00000100| 2e 20 52 65 73 65 74 20 | 74 68 65 20 73 65 6c 65 |. Reset |the sele|
|00000110| 63 74 69 6f 6e 20 61 6e | 64 20 72 75 6e 20 74 68 |ction an|d run th|
|00000120| 65 20 63 6f 6d 6d 61 6e | 64 20 61 67 61 69 6e 2e |e comman|d again.|
|00000130| 00 52 61 6e 67 65 20 71 | 75 61 6c 69 66 69 65 72 |.Range q|ualifier|
|00000140| 20 6e 6f 74 20 70 61 72 | 74 20 6f 66 20 73 65 6c | not par|t of sel|
|00000150| 65 63 74 69 6f 6e 0a 0a | 54 68 65 20 72 61 6e 67 |ection..|The rang|
|00000160| 65 20 61 72 67 75 6d 65 | 6e 74 20 69 73 20 6e 6f |e argume|nt is no|
|00000170| 74 20 73 70 65 63 69 66 | 69 65 64 20 69 6e 20 74 |t specif|ied in t|
|00000180| 68 65 20 63 75 72 72 65 | 6e 74 20 73 65 6c 65 63 |he curre|nt selec|
|00000190| 74 69 6f 6e 2e 20 53 70 | 65 63 69 66 79 20 74 68 |tion. Sp|ecify th|
|000001a0| 65 20 61 72 67 75 6d 65 | 6e 74 20 61 67 61 69 6e |e argume|nt again|
|000001b0| 20 61 6e 64 20 72 65 70 | 65 61 74 20 74 68 65 20 | and rep|eat the |
|000001c0| 63 6f 6d 6d 61 6e 64 2e | 00 46 69 6c 65 20 69 73 |command.|.File is|
|000001d0| 20 6c 6f 63 6b 65 64 2e | 0a 0a 59 6f 75 20 63 61 | locked.|..You ca|
|000001e0| 6e 6e 6f 74 20 77 6f 72 | 6b 20 69 6e 20 61 20 6c |nnot wor|k in a l|
|000001f0| 6f 63 6b 65 64 20 66 69 | 6c 65 2e 20 55 6e 6c 6f |ocked fi|le. Unlo|
|00000200| 63 6b 20 74 68 65 20 66 | 69 6c 65 20 61 6e 64 20 |ck the f|ile and |
|00000210| 74 72 79 20 61 67 61 69 | 6e 2e 00 50 72 6f 74 65 |try agai|n..Prote|
|00000220| 63 74 65 64 20 63 65 6c | 6c 0a 0a 2a 20 49 66 20 |cted cel|l..* If |
|00000230| 79 6f 75 20 6c 6f 63 6b | 65 64 20 74 68 65 20 77 |you lock|ed the w|
|00000240| 6f 72 6b 62 6f 6f 6b 2c | 20 79 6f 75 20 6d 75 73 |orkbook,| you mus|
|00000250| 74 20 75 6e 6c 6f 63 6b | 20 69 74 20 62 79 20 63 |t unlock| it by c|
|00000260| 68 6f 6f 73 69 6e 67 20 | 46 69 6c 65 20 2d 20 57 |hoosing |File - W|
|00000270| 6f 72 6b 62 6f 6f 6b 20 | 50 72 6f 70 65 72 74 69 |orkbook |Properti|
|00000280| 65 73 20 62 65 66 6f 72 | 65 20 79 6f 75 20 63 61 |es befor|e you ca|
|00000290| 6e 20 70 65 72 66 6f 72 | 6d 20 61 6e 79 20 6f 70 |n perfor|m any op|
|000002a0| 65 72 61 74 69 6f 6e 2e | 0a 2a 20 49 66 20 79 6f |eration.|.* If yo|
|000002b0| 75 20 6c 6f 63 6b 65 64 | 20 74 68 65 20 73 68 65 |u locked| the she|
|000002c0| 65 74 2c 20 79 6f 75 20 | 6d 75 73 74 20 75 6e 6c |et, you |must unl|
|000002d0| 6f 63 6b 20 69 74 20 62 | 79 20 63 68 6f 6f 73 69 |ock it b|y choosi|
|000002e0| 6e 67 20 53 68 65 65 74 | 20 2d 20 53 68 65 65 74 |ng Sheet| - Sheet|
|000002f0| 20 50 72 6f 70 65 72 74 | 69 65 73 20 62 65 66 6f | Propert|ies befo|
|00000300| 72 65 20 79 6f 75 20 63 | 61 6e 20 63 68 61 6e 67 |re you c|an chang|
|00000310| 65 20 61 6e 79 20 70 72 | 6f 74 65 63 74 65 64 20 |e any pr|otected |
|00000320| 63 65 6c 6c 73 2e 00 53 | 74 79 6c 65 20 6e 61 6d |cells..S|tyle nam|
|00000330| 65 20 68 61 73 20 61 6c | 72 65 61 64 79 20 62 65 |e has al|ready be|
|00000340| 65 6e 20 64 65 66 69 6e | 65 64 2e 0a 0a 45 6e 74 |en defin|ed...Ent|
|00000350| 65 72 20 61 6e 6f 74 68 | 65 72 20 73 74 79 6c 65 |er anoth|er style|
|00000360| 20 6e 61 6d 65 20 61 6e | 64 20 74 72 79 20 61 67 | name an|d try ag|
|00000370| 61 69 6e 2e 00 53 74 79 | 6c 65 20 6e 61 6d 65 20 |ain..Sty|le name |
|00000380| 68 61 73 20 6e 6f 74 20 | 62 65 65 6e 20 64 65 66 |has not |been def|
|00000390| 69 6e 65 64 2e 0a 0a 43 | 68 65 63 6b 20 74 68 65 |ined...C|heck the|
|000003a0| 20 27 53 74 79 6c 65 20 | 6e 61 6d 65 27 20 6c 69 | 'Style |name' li|
|000003b0| 73 74 20 69 6e 20 74 68 | 65 20 49 6e 66 6f 42 6f |st in th|e InfoBo|
|000003c0| 78 2e 20 49 66 20 74 68 | 65 20 73 74 79 6c 65 20 |x. If th|e style |
|000003d0| 6e 61 6d 65 20 64 6f 65 | 73 20 6e 6f 74 20 61 70 |name doe|s not ap|
|000003e0| 70 65 61 72 2c 20 63 72 | 65 61 74 65 20 6f 6e 65 |pear, cr|eate one|
|000003f0| 2e 00 43 61 6e 6e 6f 74 | 20 6d 6f 76 65 20 6f 72 |..Cannot| move or|
|00000400| 20 63 6f 70 79 20 64 61 | 74 61 20 62 65 79 6f 6e | copy da|ta beyon|
|00000410| 64 20 73 68 65 65 74 20 | 62 6f 75 6e 64 61 72 69 |d sheet |boundari|
|00000420| 65 73 0a 0a 4d 61 6b 65 | 20 73 75 72 65 20 74 68 |es..Make| sure th|
|00000430| 65 20 6e 75 6d 62 65 72 | 20 6f 66 20 72 6f 77 73 |e number| of rows|
|00000440| 20 6f 72 20 72 61 6e 67 | 65 20 79 6f 75 20 73 70 | or rang|e you sp|
|00000450| 65 63 69 66 69 65 64 20 | 64 69 64 20 6e 6f 74 20 |ecified |did not |
|00000460| 65 78 63 65 65 64 20 74 | 68 65 20 6e 75 6d 62 65 |exceed t|he numbe|
|00000470| 72 20 6f 66 20 62 6c 61 | 6e 6b 20 72 6f 77 73 20 |r of bla|nk rows |
|00000480| 61 74 20 74 68 65 20 62 | 6f 74 74 6f 6d 20 6f 66 |at the b|ottom of|
|00000490| 20 74 68 65 20 73 68 65 | 65 74 2e 20 53 70 65 63 | the she|et. Spec|
|000004a0| 69 66 79 20 66 65 77 65 | 72 20 72 6f 77 73 20 6f |ify fewe|r rows o|
|000004b0| 72 20 61 20 73 6d 61 6c | 6c 65 72 20 72 61 6e 67 |r a smal|ler rang|
|000004c0| 65 20 6f 72 20 6d 6f 76 | 65 20 74 68 65 20 70 61 |e or mov|e the pa|
|000004d0| 73 74 65 20 6c 6f 63 61 | 74 69 6f 6e 2c 20 74 68 |ste loca|tion, th|
|000004e0| 65 6e 20 72 65 70 65 61 | 74 20 74 68 65 20 63 6f |en repea|t the co|
|000004f0| 6d 6d 61 6e 64 2e 00 43 | 75 72 72 65 6e 63 79 20 |mmand..C|urrency |
|00000500| 73 79 6d 62 6f 6c 20 61 | 6c 72 65 61 64 79 20 65 |symbol a|lready e|
|00000510| 78 69 73 74 73 2e 0a 0a | 54 68 65 20 73 79 6d 62 |xists...|The symb|
|00000520| 6f 6c 20 79 6f 75 20 65 | 6e 74 65 72 65 64 20 69 |ol you e|ntered i|
|00000530| 73 20 61 6c 72 65 61 64 | 79 20 62 65 69 6e 67 20 |s alread|y being |
|00000540| 75 73 65 64 20 62 79 20 | 61 6e 6f 74 68 65 72 20 |used by |another |
|00000550| 63 75 72 72 65 6e 63 79 | 2e 20 45 6e 74 65 72 20 |currency|. Enter |
|00000560| 61 6e 6f 74 68 65 72 20 | 63 75 72 72 65 6e 63 79 |another |currency|
|00000570| 20 73 79 6d 62 6f 6c 2e | 00 54 68 69 73 20 66 6f | symbol.|.This fo|
|00000580| 72 6d 61 74 20 63 61 6e | 6e 6f 74 20 62 65 20 6d |rmat can|not be m|
|00000590| 6f 64 69 66 69 65 64 2e | 0a 0a 54 68 65 20 63 75 |odified.|..The cu|
|000005a0| 72 72 65 6e 63 79 20 73 | 79 6d 62 6f 6c 20 63 61 |rrency s|ymbol ca|
|000005b0| 6e 6e 6f 74 20 62 65 20 | 63 68 61 6e 67 65 64 20 |nnot be |changed |
|000005c0| 74 6f 20 74 68 65 20 73 | 65 6c 65 63 74 65 64 20 |to the s|elected |
|000005d0| 66 6f 72 6d 61 74 2e 00 | 4e 65 77 20 63 75 72 72 |format..|New curr|
|000005e0| 65 6e 63 79 20 73 79 6d | 62 6f 6c 20 69 73 20 74 |ency sym|bol is t|
|000005f0| 6f 6f 20 6c 6f 6e 67 2e | 0a 0a 43 68 61 6e 67 65 |oo long.|..Change|
|00000600| 20 74 68 65 20 63 75 72 | 72 65 6e 63 79 20 73 79 | the cur|rency sy|
|00000610| 6d 62 6f 6c 20 74 6f 20 | 61 20 73 6d 61 6c 6c 65 |mbol to |a smalle|
|00000620| 72 20 6c 65 6e 67 74 68 | 2e 20 54 68 65 20 73 79 |r length|. The sy|
|00000630| 6d 62 6f 6c 20 63 61 6e | 20 62 65 20 75 70 20 74 |mbol can| be up t|
|00000640| 6f 20 31 35 20 63 68 61 | 72 61 63 74 65 72 73 2e |o 15 cha|racters.|
|00000650| 00 43 61 6e 6e 6f 74 20 | 6d 6f 76 65 20 6f 72 20 |.Cannot |move or |
|00000660| 64 65 6c 65 74 65 20 61 | 20 70 6f 72 74 69 6f 6e |delete a| portion|
|00000670| 20 6f 66 20 61 20 51 75 | 65 72 79 20 54 61 62 6c | of a Qu|ery Tabl|
|00000680| 65 00 54 68 65 20 6c 6f | 63 61 74 69 6f 6e 20 79 |e.The lo|cation y|
|00000690| 6f 75 27 72 65 20 64 72 | 61 67 67 69 6e 67 20 74 |ou're dr|agging t|
|000006a0| 6f 20 63 6f 6e 74 61 69 | 6e 73 20 64 61 74 61 2e |o contai|ns data.|
|000006b0| 20 49 73 20 69 74 20 4f | 4b 20 66 6f 72 20 31 2d | Is it O|K for 1-|
|000006c0| 32 2d 33 20 74 6f 20 72 | 65 70 6c 61 63 65 20 74 |2-3 to r|eplace t|
|000006d0| 68 69 73 20 64 61 74 61 | 3f 0a 0a 43 6c 69 63 6b |his data|?..Click|
|000006e0| 20 4f 4b 20 74 6f 20 72 | 65 70 6c 61 63 65 20 74 | OK to r|eplace t|
|000006f0| 68 65 20 64 61 74 61 20 | 6f 72 20 63 6c 69 63 6b |he data |or click|
|00000700| 20 43 61 6e 63 65 6c 20 | 74 6f 20 65 6e 64 20 74 | Cancel |to end t|
|00000710| 68 65 20 64 72 61 67 20 | 6f 70 65 72 61 74 69 6f |he drag |operatio|
|00000720| 6e 20 61 6e 64 20 72 65 | 74 75 72 6e 20 74 68 65 |n and re|turn the|
|00000730| 20 72 61 6e 67 65 20 74 | 6f 20 69 74 73 20 6f 72 | range t|o its or|
|00000740| 69 67 69 6e 61 6c 20 6c | 6f 63 61 74 69 6f 6e 2e |iginal l|ocation.|
|00000750| 00 43 68 61 6e 67 69 6e | 67 20 74 68 65 20 6f 72 |.Changin|g the or|
|00000760| 69 65 6e 74 61 74 69 6f | 6e 20 6f 66 20 73 75 6d |ientatio|n of sum|
|00000770| 6d 61 72 79 20 74 6f 20 | 64 65 74 61 69 6c 20 77 |mary to |detail w|
|00000780| 69 6c 6c 20 63 6c 65 61 | 72 20 74 68 65 20 6f 72 |ill clea|r the or|
|00000790| 69 65 6e 74 61 74 69 6f | 6e 20 73 65 74 74 69 6e |ientatio|n settin|
|000007a0| 67 20 66 6f 72 20 61 6e | 79 20 6f 74 68 65 72 20 |g for an|y other |
|000007b0| 6f 75 74 6c 69 6e 65 20 | 69 6e 20 74 68 69 73 20 |outline |in this |
|000007c0| 73 68 65 65 74 2e 20 41 | 72 65 20 79 6f 75 20 73 |sheet. A|re you s|
|000007d0| 75 72 65 20 79 6f 75 20 | 77 61 6e 74 20 74 6f 20 |ure you |want to |
|000007e0| 63 68 61 6e 67 65 20 74 | 68 65 20 73 75 6d 6d 61 |change t|he summa|
|000007f0| 72 79 20 74 6f 20 64 65 | 74 61 69 6c 20 6f 72 69 |ry to de|tail ori|
|00000800| 65 6e 74 61 74 69 6f 6e | 3f 00 43 68 61 6e 67 65 |entation|?.Change|
|00000810| 20 4f 75 74 6c 69 6e 65 | 20 53 75 6d 6d 61 72 79 | Outline| Summary|
|00000820| 20 74 6f 20 44 65 74 61 | 69 6c 20 4f 72 69 65 6e | to Deta|il Orien|
|00000830| 74 61 74 69 6f 6e 00 43 | 6f 6c 75 6d 6e 20 68 69 |tation.C|olumn hi|
|00000840| 64 64 65 6e 0a 0a 59 6f | 75 20 74 72 69 65 64 20 |dden..Yo|u tried |
|00000850| 74 6f 20 6d 6f 76 65 20 | 74 68 65 20 63 65 6c 6c |to move |the cell|
|00000860| 20 70 6f 69 6e 74 65 72 | 20 74 6f 20 61 20 68 69 | pointer| to a hi|
|00000870| 64 64 65 6e 20 63 6f 6c | 75 6d 6e 2e 20 59 6f 75 |dden col|umn. You|
|00000880| 20 6d 75 73 74 20 66 69 | 72 73 74 20 72 65 64 69 | must fi|rst redi|
|00000890| 73 70 6c 61 79 20 74 68 | 65 20 63 6f 6c 75 6d 6e |splay th|e column|
|000008a0| 2e 00 52 6f 77 20 68 69 | 64 64 65 6e 0a 0a 59 6f |..Row hi|dden..Yo|
|000008b0| 75 20 74 72 69 65 64 20 | 74 6f 20 6d 6f 76 65 20 |u tried |to move |
|000008c0| 74 68 65 20 63 65 6c 6c | 20 70 6f 69 6e 74 65 72 |the cell| pointer|
|000008d0| 20 74 6f 20 61 20 68 69 | 64 64 65 6e 20 72 6f 77 | to a hi|dden row|
|000008e0| 2e 20 59 6f 75 20 6d 75 | 73 74 20 66 69 72 73 74 |. You mu|st first|
|000008f0| 20 72 65 64 69 73 70 6c | 61 79 20 74 68 65 20 72 | redispl|ay the r|
|00000900| 6f 77 2e 00 53 68 65 65 | 74 20 68 69 64 64 65 6e |ow..Shee|t hidden|
|00000910| 0a 0a 59 6f 75 20 74 72 | 69 65 64 20 74 6f 20 6d |..You tr|ied to m|
|00000920| 6f 76 65 20 74 68 65 20 | 63 65 6c 6c 20 70 6f 69 |ove the |cell poi|
|00000930| 6e 74 65 72 20 74 6f 20 | 61 20 68 69 64 64 65 6e |nter to |a hidden|
|00000940| 20 73 68 65 65 74 2e 20 | 59 6f 75 20 6d 75 73 74 | sheet. |You must|
|00000950| 20 66 69 72 73 74 20 72 | 65 64 69 73 70 6c 61 79 | first r|edisplay|
|00000960| 20 74 68 65 20 73 68 65 | 65 74 2e 00 43 6f 6c 75 | the she|et..Colu|
|00000970| 6d 6e 20 77 69 64 74 68 | 20 6d 75 73 74 20 62 65 |mn width| must be|
|00000980| 20 62 65 74 77 65 65 6e | 20 30 20 61 6e 64 20 32 | between| 0 and 2|
|00000990| 34 30 20 63 68 61 72 61 | 63 74 65 72 73 2e 00 52 |40 chara|cters..R|
|000009a0| 6f 77 20 68 65 69 67 68 | 74 20 6d 75 73 74 20 62 |ow heigh|t must b|
|000009b0| 65 20 62 65 74 77 65 65 | 6e 20 30 20 61 6e 64 20 |e betwee|n 0 and |
|000009c0| 32 35 35 20 70 6f 69 6e | 74 73 2e 00 59 6f 75 20 |255 poin|ts..You |
|000009d0| 63 61 6e 6e 6f 74 20 77 | 69 64 65 6e 20 61 20 63 |cannot w|iden a c|
|000009e0| 6f 6c 75 6d 6e 20 74 6f | 20 64 69 73 70 6c 61 79 |olumn to| display|
|000009f0| 20 6d 6f 72 65 20 74 68 | 61 6e 20 32 34 30 20 63 | more th|an 240 c|
|00000a00| 68 61 72 61 63 74 65 72 | 73 2e 20 59 6f 75 72 20 |haracter|s. Your |
|00000a10| 77 69 64 65 73 74 20 65 | 6e 74 72 79 20 65 78 63 |widest e|ntry exc|
|00000a20| 65 65 64 73 20 74 68 69 | 73 20 6c 69 6d 69 74 2e |eeds thi|s limit.|
|00000a30| 20 54 68 65 20 64 61 74 | 61 20 77 69 6c 6c 20 6e | The dat|a will n|
|00000a40| 6f 74 20 62 65 20 6c 6f | 73 74 2c 20 62 75 74 20 |ot be lo|st, but |
|00000a50| 6f 6e 6c 79 20 74 68 65 | 20 66 69 72 73 74 20 32 |only the| first 2|
|00000a60| 34 30 20 63 68 61 72 61 | 63 74 65 72 73 20 6d 61 |40 chara|cters ma|
|00000a70| 79 20 62 65 20 64 69 73 | 70 6c 61 79 65 64 2e 20 |y be dis|played. |
|00000a80| 44 6f 20 79 6f 75 20 77 | 61 6e 74 20 74 6f 20 63 |Do you w|ant to c|
|00000a90| 6f 6e 74 69 6e 75 65 3f | 00 43 61 6e 6e 6f 74 20 |ontinue?|.Cannot |
|00000aa0| 68 69 64 65 20 61 6c 6c | 20 63 6f 6c 75 6d 6e 73 |hide all| columns|
|00000ab0| 2e 0a 0a 52 65 64 75 63 | 65 20 74 68 65 20 6e 75 |...Reduc|e the nu|
|00000ac0| 6d 62 65 72 20 6f 66 20 | 63 6f 6c 75 6d 6e 73 20 |mber of |columns |
|00000ad0| 74 6f 20 68 69 64 65 20 | 62 79 20 61 74 20 6c 65 |to hide |by at le|
|00000ae0| 61 73 74 20 6f 6e 65 2c | 20 6f 72 20 72 65 64 69 |ast one,| or redi|
|00000af0| 73 70 6c 61 79 20 61 6e | 6f 74 68 65 72 20 63 6f |splay an|other co|
|00000b00| 6c 75 6d 6e 20 74 68 61 | 74 20 69 73 20 63 75 72 |lumn tha|t is cur|
|00000b10| 72 65 6e 74 6c 79 20 68 | 69 64 64 65 6e 20 61 6e |rently h|idden an|
|00000b20| 64 20 74 68 65 6e 20 68 | 69 64 65 20 74 68 65 20 |d then h|ide the |
|00000b30| 63 6f 6c 75 6d 6e 73 20 | 79 6f 75 20 6f 72 69 67 |columns |you orig|
|00000b40| 69 6e 61 6c 6c 79 20 73 | 70 65 63 69 66 69 65 64 |inally s|pecified|
|00000b50| 2e 00 43 61 6e 6e 6f 74 | 20 68 69 64 65 20 61 6c |..Cannot| hide al|
|00000b60| 6c 20 72 6f 77 73 0a 0a | 52 65 64 75 63 65 20 74 |l rows..|Reduce t|
|00000b70| 68 65 20 6e 75 6d 62 65 | 72 20 6f 66 20 72 6f 77 |he numbe|r of row|
|00000b80| 73 20 74 6f 20 68 69 64 | 65 20 62 79 20 61 74 20 |s to hid|e by at |
|00000b90| 6c 65 61 73 74 20 6f 6e | 65 2c 20 6f 72 20 72 65 |least on|e, or re|
|00000ba0| 64 69 73 70 6c 61 79 20 | 61 6e 6f 74 68 65 72 20 |display |another |
|00000bb0| 72 6f 77 20 74 68 61 74 | 20 69 73 20 63 75 72 72 |row that| is curr|
|00000bc0| 65 6e 74 6c 79 20 68 69 | 64 64 65 6e 20 61 6e 64 |ently hi|dden and|
|00000bd0| 20 74 68 65 6e 20 68 69 | 64 65 20 74 68 65 20 72 | then hi|de the r|
|00000be0| 6f 77 73 20 79 6f 75 20 | 6f 72 69 67 69 6e 61 6c |ows you |original|
|00000bf0| 6c 79 20 73 70 65 63 69 | 66 69 65 64 2e 00 44 65 |ly speci|fied..De|
|00000c00| 73 74 69 6e 61 74 69 6f | 6e 20 52 61 6e 67 65 20 |stinatio|n Range |
|00000c10| 46 75 6c 6c 20 6f 72 20 | 49 6e 76 61 6c 69 64 20 |Full or |Invalid |
|00000c20| 52 61 6e 67 65 0a 0a 57 | 68 65 6e 20 65 6e 74 65 |Range..W|hen ente|
|00000c30| 72 69 6e 67 20 61 20 74 | 61 62 6c 65 2c 20 74 61 |ring a t|able, ta|
|00000c40| 62 6c 65 20 64 65 66 69 | 6e 69 74 69 6f 6e 2c 20 |ble defi|nition, |
|00000c50| 6f 72 20 6c 69 73 74 20 | 6f 66 20 69 6e 66 6f 72 |or list |of infor|
|00000c60| 6d 61 74 69 6f 6e 3b 20 | 6d 61 6b 65 20 73 75 72 |mation; |make sur|
|00000c70| 65 20 74 68 65 20 72 61 | 6e 67 65 20 79 6f 75 20 |e the ra|nge you |
|00000c80| 73 70 65 63 69 66 79 20 | 61 6c 6c 6f 77 73 20 74 |specify |allows t|
|00000c90| 68 65 20 73 68 65 65 74 | 20 74 6f 20 61 63 63 6f |he sheet| to acco|
|00000ca0| 6d 6d 6f 64 61 74 65 20 | 61 6c 6c 20 74 68 65 20 |mmodate |all the |
|00000cb0| 69 6e 66 6f 72 6d 61 74 | 69 6f 6e 3b 20 74 68 61 |informat|ion; tha|
|00000cc0| 74 20 74 68 65 20 72 61 | 6e 67 65 20 69 73 20 69 |t the ra|nge is i|
|00000cd0| 6e 20 61 6e 20 61 63 74 | 69 76 65 20 66 69 6c 65 |n an act|ive file|
|00000ce0| 2c 20 61 6e 64 20 74 68 | 61 74 20 74 68 65 20 72 |, and th|at the r|
|00000cf0| 61 6e 67 65 20 69 73 20 | 75 6e 70 72 6f 74 65 63 |ange is |unprotec|
|00000d00| 74 65 64 2e 00 54 68 65 | 20 6e 61 76 69 67 61 74 |ted..The| navigat|
|00000d10| 6f 72 20 6c 65 74 73 20 | 79 6f 75 20 67 6f 20 74 |or lets |you go t|
|00000d20| 6f 20 6e 61 6d 65 64 20 | 72 61 6e 67 65 73 2e 20 |o named |ranges. |
|00000d30| 54 68 65 72 65 20 61 72 | 65 20 6e 6f 20 6e 61 6d |There ar|e no nam|
|00000d40| 65 64 20 72 61 6e 67 65 | 73 20 69 6e 20 74 68 69 |ed range|s in thi|
|00000d50| 73 20 66 69 6c 65 2e 00 | 53 74 79 6c 65 20 6e 61 |s file..|Style na|
|00000d60| 6d 65 20 69 73 20 74 6f | 6f 20 6c 6f 6e 67 20 6f |me is to|o long o|
|00000d70| 72 20 65 6d 70 74 79 2e | 0a 0a 43 68 65 63 6b 20 |r empty.|..Check |
|00000d80| 74 68 61 74 20 74 68 65 | 20 73 74 79 6c 65 20 6e |that the| style n|
|00000d90| 61 6d 65 20 79 6f 75 20 | 73 70 65 63 69 66 69 65 |ame you |specifie|
|00000da0| 64 20 63 6f 6e 74 61 69 | 6e 73 20 31 20 74 6f 20 |d contai|ns 1 to |
|00000db0| 36 34 20 63 68 61 72 61 | 63 74 65 72 73 20 61 6e |64 chara|cters an|
|00000dc0| 64 20 69 73 20 73 70 65 | 6c 6c 65 64 20 63 6f 72 |d is spe|lled cor|
|00000dd0| 72 65 63 74 6c 79 2e 00 | 59 6f 75 20 63 61 6e 6e |rectly..|You cann|
|00000de0| 6f 74 20 63 72 65 61 74 | 65 20 61 20 6e 65 77 20 |ot creat|e a new |
|00000df0| 6e 61 6d 65 64 20 73 74 | 79 6c 65 20 62 65 63 61 |named st|yle beca|
|00000e00| 75 73 65 20 79 6f 75 20 | 65 78 63 65 65 64 65 64 |use you |exceeded|
|00000e10| 20 74 68 65 20 6c 69 6d | 69 74 20 6f 66 20 34 30 | the lim|it of 40|
|00000e20| 39 34 20 6e 61 6d 65 64 | 20 73 74 79 6c 65 73 20 |94 named| styles |
|00000e30| 69 6e 20 61 20 77 6f 72 | 6b 62 6f 6f 6b 2e 00 49 |in a wor|kbook..I|
|00000e40| 6e 76 61 6c 69 64 20 72 | 61 6e 67 65 2e 0a 0a 53 |nvalid r|ange...S|
|00000e50| 70 65 63 69 66 79 20 61 | 20 32 44 20 72 61 6e 67 |pecify a| 2D rang|
|00000e60| 65 20 74 68 61 74 20 6f | 76 65 72 6c 61 70 73 20 |e that o|verlaps |
|00000e70| 61 6e 64 20 69 73 20 69 | 6e 20 74 68 65 20 73 61 |and is i|n the sa|
|00000e80| 6d 65 20 66 69 6c 65 20 | 61 73 20 74 68 65 20 66 |me file |as the f|
|00000e90| 69 6c 6c 65 64 20 72 61 | 6e 67 65 20 74 68 61 74 |illed ra|nge that|
|00000ea0| 20 69 73 20 63 75 72 72 | 65 6e 74 6c 79 20 73 65 | is curr|ently se|
|00000eb0| 6c 65 63 74 65 64 2e 00 | 49 6e 76 61 6c 69 64 20 |lected..|Invalid |
|00000ec0| 65 78 70 72 65 73 73 69 | 6f 6e 2c 20 25 31 2e 0a |expressi|on, %1..|
|00000ed0| 0a 4d 61 6b 65 20 73 75 | 72 65 20 74 68 61 74 20 |.Make su|re that |
|00000ee0| 74 68 65 20 65 78 70 72 | 65 73 73 69 6f 6e 20 79 |the expr|ession y|
|00000ef0| 6f 75 20 74 79 70 65 64 | 20 69 73 20 61 20 76 61 |ou typed| is a va|
|00000f00| 6c 69 64 20 6e 75 6d 62 | 65 72 20 6f 72 20 66 6f |lid numb|er or fo|
|00000f10| 72 6d 75 6c 61 2e 00 54 | 68 65 20 64 65 73 74 69 |rmula..T|he desti|
|00000f20| 6e 61 74 69 6f 6e 20 66 | 6f 72 20 74 68 65 20 73 |nation f|or the s|
|00000f30| 65 6c 65 63 74 65 64 20 | 63 6f 6c 75 6d 6e 73 20 |elected |columns |
|00000f40| 6f 72 20 72 6f 77 73 20 | 63 61 6e 6e 6f 74 20 6f |or rows |cannot o|
|00000f50| 76 65 72 6c 61 70 20 74 | 68 65 20 6f 72 69 67 69 |verlap t|he origi|
|00000f60| 6e 61 6c 20 6c 6f 63 61 | 74 69 6f 6e 00          |nal loca|tion.   |
+--------+-------------------------+-------------------------+--------+--------+