Computer Based Training: Office 97, Windows 95 & NT Basics

home *** CD-ROM | disk | FTP | other *** search

/ Computer Based Training: …, Windows 95 & NT Basics / a1454501.iso / msoie / IE04.CTL < prev next >

Wrap

Text File | 1997-03-25 | 46.9 KB | 1,662 lines

* SimScrn 4 1 7 ********************************* * Course: Intermediate Excel 97 * Unit: Customizing Unit No.:04 * Topic: Customizing Toolbars Topic No.: 1 **** MoveCtrl 1 493 460 0 eff.exe i04_101.gif 0 459 0 1 0 15 15 15 * Toolbars allow you to perform isave 414 457 636 389 text1 textbox 414 457 636 389 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_102a.gif 0 459 0 1 0 15 15 15 * This is a useful alternative t isave 414 394 636 321 text2 growbox 414 394 636 321 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** qcall IE04q 040101 eff.exe i04_103a.gif 72 400 0 1 0 15 15 15 * Excel comes with 13 Toolbars, isave 414 326 636 219 text3 growbox 414 326 636 219 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 414 326 image memory text2 0 414 394 image memory text1 0 414 457 * eff.exe i04_104a.gif 233 236 0 1 0 15 15 15 eff.exe i04_104b.gif 366 236 0 1 0 15 15 15 eff.exe i04_104c.gif 233 216 0 1 0 15 15 15 eff.exe i04_104d.gif 366 216 0 1 0 15 15 15 * Toolbars allow you to organize isave 4 275 320 207 text1 textbox 4 275 320 207 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** qcall IE04q 040102 eff.exe i04_105a.gif 0 459 0 1 0 15 15 15 * In a typical configuration, Ex isave 4 212 320 139 text2 growbox 4 212 320 139 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_106.gif 0 459 0 1 0 15 15 15 * You can leave these Toolbars w isave 4 144 320 54 text3 growbox 4 144 320 54 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 4 144 image memory text2 0 4 212 image memory text1 0 4 275 * qcall IE04q 040103 eff.exe i04_107a.gif 2 448 0 1 0 15 15 15 * The Worksheet Menu Bar is a sp isave 170 263 486 195 text1 textbox 170 263 486 195 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_108.gif 0 459 0 1 0 15 15 15 * These menus contain commands f isave 170 200 486 144 text2 growbox 170 200 486 144 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 170 200 image memory text1 0 170 263 * eff.exe i04_109a.gif 8 440 0 1 0 15 15 15 eff.exe i04_109b.gif 178 442 0 1 0 15 15 15 eff.exe i04_109c.gif 155 286 0 1 0 15 15 15 * You can customize this Menu Ba isave 176 344 448 293 text1 textbox 176 344 448 293 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_110a.gif 0 459 0 1 0 15 15 15 * For example, you might need to isave 176 298 448 225 text2 growbox 176 298 448 225 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 176 298 image memory text1 0 176 344 * eff.exe i04_111a.gif 0 459 0 1 0 15 15 15 * To display the Customise dialo isave 361 345 594 294 text1 textbox 361 345 594 294 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** qcall IE04q 040104 eff.exe i04_112.gif 0 459 0 1 0 15 15 15 * It is not possible to remove t isave 361 299 594 243 text2 growbox 361 299 594 243 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 361 299 image memory text1 0 361 345 * eff.exe i04_113a.gif 72 400 0 1 0 15 15 15 * In this case, you want to remo isave 41 202 328 134 text1 textbox 41 202 328 134 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_114a.gif 0 436 0 1 0 15 15 15 * So you click Standard to desel isave 41 139 328 100 text2 growbox 41 139 328 100 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_115a.gif 82 457 0 1 0 15 15 15 * Excel immediately applies your isave 41 105 328 49 text3 growbox 41 105 328 49 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 41 105 image memory text2 0 41 139 image memory text1 0 41 202 * eff.exe i04_116a.gif 2 416 0 1 0 15 15 15 * To remove the other Toolbar, y isave 285 274 609 223 text1 textbox 285 274 609 223 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_117a.gif 37 416 0 1 0 15 15 15 * In the shortcut menu, you clic isave 285 228 609 172 text2 growbox 285 228 609 172 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_118a.gif 139 421 0 1 0 15 15 15 * You will notice that the short isave 285 177 609 104 text3 growbox 285 177 609 104 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_119a.gif 0 436 0 1 0 15 15 15 * Again Excel immediately remove isave 285 109 609 70 text4 growbox 285 109 609 70 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 285 109 image memory text3 0 285 177 image memory text2 0 285 228 image memory text1 0 285 274 * eff.exe i04_120a.gif 0 459 0 1 0 15 15 15 * Although you may have seen Too isave 30 367 316 265 text1 textbox 30 367 316 265 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_121a.gif 26 437 0 1 0 15 15 15 eff.exe i04_121b.gif 128 437 0 1 0 15 15 15 eff.exe i04_121c.gif 130 231 0 1 0 15 15 15 * ≥ floatin isave 30 270 316 231 text2 growbox 30 270 316 231 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_122a.gif 130 231 0 1 0 15 15 15 eff.exe i04_122b.gif 132 91 0 1 0 15 15 15 * ≥ above the Status ba isave 30 236 316 197 text3 growbox 30 236 316 197 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 30 236 image memory text2 0 30 270 image memory text1 0 30 367 * eff.exe i04_123a.gif 0 459 0 1 0 15 15 15 * Let's see how you can move the isave 38 318 344 267 text1 textbox 38 318 344 267 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_124a.gif 1 453 0 1 0 15 15 15 * To do this, you point to a bla isave 38 272 344 216 text2 growbox 38 272 344 216 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_125a.gif 113 443 0 1 0 15 15 15 * Then you click and hold down t isave 38 221 344 148 text3 growbox 38 221 344 148 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 38 221 image memory text2 0 38 272 image memory text1 0 38 318 * eff.exe i04_126a.gif 113 383 0 1 0 15 15 15 * You drag the Menu Bar to where isave 35 154 254 103 text1 textbox 35 154 254 103 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_127a.gif 0 459 0 1 0 15 15 15 * Then you release the mouse but isave 35 108 254 52 text2 growbox 35 108 254 52 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 35 108 image memory text1 0 35 154 * eff.exe i04_128.gif 0 459 0 1 0 15 15 15 * Floating Toolbars offer two im isave 36 351 374 317 text1 textbox 36 351 374 317 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_129a.gif 199 288 0 1 0 15 15 15 eff.exe i04_129b.gif 16 92 0 1 0 15 15 15 * You can position a floating To isave 36 322 374 249 text2 growbox 36 322 374 249 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_130a.gif 16 113 0 1 0 15 15 15 * In addition, you can resize a isave 36 254 374 198 text3 growbox 36 254 374 198 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 36 254 image memory text2 0 36 322 image memory text1 0 36 351 * eff.exe i04_131a.gif 2 456 0 1 0 15 15 15 eff.exe i04_131b.gif 569 437 0 1 0 15 15 15 * Suppose that the floating Work isave 331 373 622 305 text1 textbox 331 373 622 305 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_132a.gif 8 412 0 1 0 15 15 15 * You simply double-click its ti isave 331 310 622 271 text2 growbox 331 310 622 271 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_133a.gif 0 459 0 1 0 15 15 15 eff.exe i04_133b.gif 0 19 0 1 0 15 15 15 * Excel docks the Worksheet Menu isave 331 276 622 220 text3 growbox 331 276 622 220 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 331 276 image memory text2 0 331 310 image memory text1 0 331 373 * SimScrn 4 2 7 ********************************* MoveCtrl 1 493 460 0 eff.exe i04_134.gif 0 459 0 1 0 15 15 15 * Excel's Toolbars facilitate a isave 38 189 246 138 text1 textbox 38 189 246 138 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_135a.gif 119 302 0 1 0 15 15 15 * You can create custom Toolbars isave 38 143 246 70 text2 growbox 38 143 246 70 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 38 143 image memory text1 0 38 189 * eff.exe i04_136a.gif 28 365 0 1 0 15 15 15 * A custom Toolbar could be an e isave 154 425 494 357 text1 textbox 154 425 494 357 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_137a.gif 190 266 0 1 0 15 15 15 * Or, it could be a brand new To isave 154 362 494 289 text2 growbox 154 362 494 289 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 154 362 image memory text1 0 154 425 * eff.exe i04_138a.gif 0 459 0 1 0 15 15 15 * Lets' see how you create a cus isave 127 346 383 295 text1 textbox 127 346 383 295 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_139a.gif 176 385 0 1 0 15 15 15 * You right-click, and in the sh isave 127 300 383 244 text2 growbox 127 300 383 244 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * Choosing View - Toolbars - Cus notebox 141 219 369 ** image memory text2 0 127 300 image memory text1 0 127 346 * eff.exe i04_141a.gif 2 436 0 1 0 15 15 15 * Next you click the Toolbars t isave 339 446 624 412 text1 textbox 339 446 624 412 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_142a.gif 41 402 0 1 0 15 15 15 eff.exe i04_142b.gif 280 361 0 1 0 15 15 15 eff.exe i04_142c.gif 317 130 0 1 0 15 15 15 * In the Toolbars page, you cli isave 339 417 624 378 text2 growbox 339 417 624 378 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_143a.gif 19 433 0 1 0 15 15 15 * Then you type a name for your isave 339 383 624 327 text3 growbox 339 383 624 327 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_144a.gif 19 426 0 1 0 15 15 15 * Now you click OK to close the isave 339 332 624 276 text4 growbox 339 332 624 276 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 339 332 image memory text3 0 339 383 image memory text2 0 339 417 image memory text1 0 339 446 * eff.exe i04_145a.gif 30 433 0 1 0 15 15 15 * Excel floats a small empty Too isave 6 148 377 114 text1 textbox 6 148 377 114 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_146a.gif 37 406 0 1 0 15 15 15 * When you click the Commands ta isave 6 119 377 63 text2 growbox 6 119 377 63 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_147a.gif 27 402 0 1 0 15 15 15 * For each category item you sel isave 6 68 377 12 text3 growbox 6 68 377 12 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 6 68 image memory text2 0 6 119 image memory text1 0 6 148 * eff.exe i04_148a.gif 27 386 0 1 0 15 15 15 eff.exe i04_148b.gif 27 207 0 1 0 15 15 15 * You locate the button you want isave 11 166 440 115 text1 textbox 11 166 440 115 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_149a.gif 33 329 0 1 0 15 15 15 eff.exe i04_149b.gif 412 245 0 1 0 15 15 15 * Now you drag the button out of isave 11 120 440 64 text2 growbox 11 120 440 64 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_150a.gif 192 336 0 1 0 15 15 15 eff.exe i04_150b.gif 382 279 0 1 0 15 15 15 * You repeat the procedure until isave 11 69 440 13 text3 growbox 11 69 440 13 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 11 69 image memory text2 0 11 120 image memory text1 0 11 166 * eff.exe i04_151a.gif 194 336 0 1 0 15 15 15 eff.exe i04_151b.gif 321 127 0 1 0 15 15 15 * Now you click Close to return isave 14 103 354 69 text1 textbox 14 103 354 69 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_152a.gif 0 436 0 1 0 15 15 15 * You can double-click the new T isave 14 74 354 18 text2 growbox 14 74 354 18 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * Dragging the Toolbar to the to notebox 65 199 310 ** image memory text2 0 14 74 image memory text1 0 14 103 * eff.exe i04_154a.gif 2 427 0 1 0 15 15 15 eff.exe i04_154b.gif 2 397 0 1 0 15 15 15 * Toolbars you create or customi isave 360 455 631 387 text1 textbox 360 455 631 387 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_155a.gif 185 357 0 1 0 15 15 15 eff.exe i04_155b.gif 185 215 0 1 0 15 15 15 eff.exe i04_155c.gif 406 215 0 1 0 15 15 15 * To ensure that a custom Toolba isave 360 392 631 302 text2 growbox 360 392 631 302 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_156a.gif 2 242 0 1 0 15 15 15 eff.exe i04_156b.gif 184 457 0 1 0 15 15 15 eff.exe i04_156c.gif 184 19 0 1 0 15 15 15 * To do this, you choose Tools - isave 360 307 631 234 text3 growbox 360 307 631 234 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 360 307 image memory text2 0 360 392 image memory text1 0 360 455 * eff.exe i04_157a.gif 2 457 0 1 0 15 15 15 eff.exe i04_157b.gif 2 19 0 1 0 15 15 15 * Then you click Attach on the T isave 317 449 625 415 text1 textbox 317 449 625 415 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_158a.gif 32 432 0 1 0 15 15 15 eff.exe i04_158b.gif 0 372 0 1 0 15 15 15 * Next you choose the Toolbar yo isave 317 420 625 364 text2 growbox 317 420 625 364 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_159a.gif 5 328 0 1 0 15 15 15 eff.exe i04_159b.gif 493 344 0 1 0 15 15 15 eff.exe i04_159c.gif 5 116 0 1 0 15 15 15 eff.exe i04_159d.gif 493 116 0 1 0 15 15 15 * You click the Copy button to c isave 317 369 625 313 text3 growbox 317 369 625 313 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 317 369 image memory text2 0 317 420 image memory text1 0 317 449 * eff.exe i04_160a.gif 208 324 0 1 0 15 15 15 eff.exe i04_160b.gif 396 344 0 1 0 15 15 15 * You click OK to close the Atta isave 97 170 305 119 text1 textbox 97 170 305 119 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_161a.gif 32 432 0 1 0 15 15 15 eff.exe i04_161b.gif 0 372 0 1 0 15 15 15 * Then you click Close isave 97 124 305 85 text2 growbox 97 124 305 85 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_162a.gif 15 435 0 1 0 15 15 15 * On the worksheet the custom To isave 97 90 305 34 text3 growbox 97 90 305 34 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 97 90 image memory text2 0 97 124 image memory text1 0 97 170 * SimScrn 4 3 7 ********************************* MoveCtrl 1 493 460 0 eff.exe i04_163.gif 0 459 0 1 0 15 15 15 * Extensive formatting can be ge isave 336 221 625 170 text1 textbox 336 221 625 170 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_164a.gif 59 300 0 1 0 15 15 15 eff.exe i04_164b.gif 120 330 0 1 0 15 15 15 * First you hold down Alt and dr isave 336 175 625 119 text2 growbox 336 175 625 119 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_165a.gif 56 316 0 1 0 15 15 15 eff.exe i04_165b.gif 226 330 0 1 0 15 15 15 * You can use the same procedure isave 336 124 625 68 text3 growbox 336 124 625 68 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 336 124 image memory text2 0 336 175 image memory text1 0 336 221 * eff.exe i04_166a.gif 2 348 0 1 0 15 15 15 eff.exe i04_166b.gif 357 443 0 1 0 15 15 15 * Suppose you want to add an ent isave 390 354 634 286 text1 textbox 390 354 634 286 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_167a.gif 357 443 0 1 0 15 15 15 eff.exe i04_167b.gif 2 340 0 1 0 15 15 15 * You click the Commands tab isave 390 291 634 252 text2 growbox 390 291 634 252 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_168a.gif 46 306 0 1 0 15 15 15 eff.exe i04_168b.gif 351 258 0 1 0 15 15 15 * In the Categories box, you cli isave 390 257 634 201 text3 growbox 390 257 634 201 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_169a.gif 338 458 0 1 0 15 15 15 eff.exe i04_169b.gif 46 258 0 1 0 15 15 15 * Then you drag the Toolbars men isave 390 206 634 133 text4 growbox 390 206 634 133 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 390 206 image memory text3 0 390 257 image memory text2 0 390 291 image memory text1 0 390 354 * eff.exe i04_170a.gif 2 458 0 1 0 15 15 15 * In Excel, the default screen s isave 337 230 629 162 text1 textbox 337 230 629 162 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_171a.gif 2 457 0 1 0 15 15 15 * You open the Customize dialog isave 337 167 629 111 text2 growbox 337 167 629 111 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_172a.gif 0 436 0 1 0 15 15 15 * Here you click the Large icons isave 337 116 629 77 text3 growbox 337 116 629 77 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 337 116 image memory text2 0 337 167 image memory text1 0 337 230 * eff.exe i04_173a.gif 47 330 0 1 0 15 15 15 * Since you want to display the isave 341 263 637 178 text1 textbox 341 263 637 178 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_174a.gif 0 457 0 1 0 15 15 15 * When you click Close to return isave 341 183 637 110 text2 growbox 341 183 637 110 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 341 183 image memory text1 0 341 263 * eff.exe i04_175a.gif 275 346 0 1 0 15 15 15 * Let's suppose that you want to isave 10 453 386 402 text1 textbox 10 453 386 402 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** qcall IE04q 040105 eff.exe i04_176a.gif 288 267 0 1 0 15 15 15 eff.exe i04_176b.gif 329 212 0 1 0 15 15 15 * When you quit Microsoft Excel isave 10 407 386 351 text2 growbox 10 407 386 351 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_177a.gif 288 267 0 1 0 15 15 15 eff.exe i04_177b.gif 533 267 0 1 0 15 15 15 eff.exe i04_177c.gif 288 212 0 1 0 15 15 15 eff.exe i04_177d.gif 533 212 0 1 0 15 15 15 * If you have Toolbars you use f isave 10 356 386 300 text3 growbox 10 356 386 300 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_178a.gif 331 207 0 1 0 15 15 15 * This is useful because you won isave 10 305 386 249 text4 growbox 10 305 386 249 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 10 305 image memory text3 0 10 356 image memory text2 0 10 407 image memory text1 0 10 453 * eff.exe i04_179a.gif 0 436 0 1 0 15 15 15 * To save the settings of a Tool isave 234 376 613 325 text1 textbox 234 376 613 325 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_180a.gif 2 457 0 1 0 15 15 15 * Then you quit Microsoft Excel isave 234 330 613 291 text2 growbox 234 330 613 291 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_181a.gif 0 459 0 1 0 15 15 15 * In your Windows folder, you lo isave 234 296 613 223 text3 growbox 234 296 613 223 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_182.gif 0 459 0 1 0 15 15 15 * If your computer is not connec isave 234 228 613 155 text4 growbox 234 228 613 155 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_183a.gif 0 241 0 1 0 15 15 15 * You then rename the file, reta isave 234 160 613 121 text5 growbox 234 160 613 121 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text5 0 234 160 image memory text4 0 234 228 image memory text3 0 234 296 image memory text2 0 234 330 image memory text1 0 234 376 * eff.exe i04_184a.gif 0 459 0 1 0 15 15 15 * When you want to use a saved c isave 389 435 629 350 text1 textbox 389 435 629 350 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_185a.gif 0 459 0 1 0 15 15 15 * Microsoft Excel will create a isave 389 355 629 265 text2 growbox 389 355 629 265 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** * If you cannot find the default notebox 314 238 624 ** image memory text2 0 389 355 image memory text1 0 389 435 * * Topic: Hands-on: Removing a Toolbar Topic No.: 2 **** SimScrn 4 4 7 ********************************* exercise 01 1 120 70 * MoveCtrl 1 493 460 0 * task 01 0101 400 317 238 2 50 67 5 5 * pause 1 1 1 1 1 1 1 1 * Topic: Using styles Topic No.: 3 **** SimScrn 4 5 7 ********************************* MoveCtrl 1 493 460 0 0 eff.exe i04_301.gif 0 459 0 1 0 15 15 15 * Extensive formatting can be ti isave 309 456 626 422 text1 textbox 309 456 626 422 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_302a.gif 0 459 0 1 0 15 15 15 * Excel's styles can reduc isave 309 427 626 371 text2 growbox 309 427 626 371 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_303a.gif 19 357 0 1 0 15 15 15 * They are formatting commands t isave 309 376 626 303 text3 growbox 309 376 626 303 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 309 376 image memory text2 0 309 427 image memory text1 0 309 456 * eff.exe i04_304a.gif 19 454 0 1 0 15 15 15 * Each style has a name which ca isave 4 166 448 132 text1 textbox 4 166 448 132 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_305a.gif 332 437 0 1 0 15 15 15 eff.exe i04_305b.gif 109 206 0 1 0 15 15 15 eff.exe i04_305c.gif 442 320 0 1 0 15 15 15 * When you apply a style to a ce isave 4 137 448 81 text2 growbox 4 137 448 81 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_306a.gif 0 459 0 1 0 15 15 15 * For example, a style named MyS isave 4 86 448 13 text3 growbox 4 86 448 13 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 4 86 image memory text2 0 4 137 image memory text1 0 4 166 * eff.exe i04_307.gif 0 459 0 1 0 15 15 15 * Generally, the more complex yo isave 73 153 293 68 text1 textbox 73 153 293 68 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 73 153 * qcall IE04q 040301 eff.exe i04_308a.gif 0 459 0 1 0 15 15 15 * By default, all styles have th isave 93 238 344 187 text1 textbox 93 238 344 187 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_309a.gif 334 451 0 1 0 15 15 15 * Excel provides five other buil isave 93 192 344 119 text2 growbox 93 192 344 119 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 93 238 image memory text2 0 93 192 * eff.exe i04_319.gif 0 459 0 1 0 15 15 15 *eff.exe i04_319a.gif 2 429 0 1 0 15 15 15 *eff.exe i04_319b.gif 2 408 0 1 0 15 15 15 * Each style contains six attri isave 434 456 634 371 text1 textbox 434 456 634 371 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_320a.gif 49 287 0 1 0 15 15 15 eff.exe i04_320b.gif 50 199 0 1 0 15 15 15 * You can apply any or all of th isave 434 376 634 320 text2 growbox 434 376 634 320 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** qcall IE04q 040303 eff.exe i04_321a.gif 49 258 0 1 0 15 15 15 eff.exe i04_321b.gif 49 229 0 1 0 15 15 15 * A style must have at least one isave 434 325 634 252 text3 growbox 434 325 634 252 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_322a.gif 0 459 0 1 0 15 15 15 * Each attribute is directly rel isave 434 257 634 184 text4 growbox 434 257 634 184 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 434 257 image memory text3 0 434 325 image memory text2 0 434 376 image memory text1 0 434 456 * eff.exe i04_323a.gif 0 459 0 1 0 15 15 15 * Let's see how you apply a styl isave 22 214 429 180 text1 textbox 22 214 429 180 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_324a.gif 33 434 0 1 0 15 15 15 eff.exe i04_324b.gif 2 365 0 1 0 15 15 15 * You select the rows, Net Profi isave 22 185 429 146 text2 growbox 22 185 429 146 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_325a.gif 12 457 0 1 0 15 15 15 * Then you choose Format - Style isave 22 151 429 112 text3 growbox 22 151 429 112 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_326a.gif 26 457 0 1 0 15 15 15 * You select the style you want isave 22 117 429 78 text4 growbox 22 117 429 78 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_327a.gif 337 429 0 1 0 15 15 15 eff.exe i04_327b.gif 26 345 0 1 0 15 15 15 eff.exe i04_327c.gif 337 330 0 1 0 15 15 15 * To close the Style dialog box, isave 22 83 429 44 text5 growbox 22 83 429 44 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_328a.gif 12 429 0 1 0 15 15 15 eff.exe i04_328b.gif 12 17 0 1 0 15 15 15 * Excel displays the new format isave 22 49 429 10 text6 growbox 22 49 429 10 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text6 0 22 49 image memory text5 0 22 83 image memory text4 0 22 117 image memory text3 0 22 151 image memory text2 0 22 185 image memory text1 0 22 214 * eff.exe i04_329a.gif 334 455 0 1 0 15 15 15 eff.exe i04_329b.gif 12 269 0 1 0 15 15 15 * An easy way to format your spr isave 36 201 411 150 text1 textbox 36 201 411 150 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_330.gif 0 459 0 1 0 15 15 15 * This allows you to change the isave 36 155 411 99 text2 growbox 36 155 411 99 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_331a.gif 143 455 0 1 0 15 15 15 * To do this, you right-click on isave 36 104 411 48 text3 growbox 36 104 411 48 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 36 104 image memory text2 0 36 155 image memory text1 0 36 201 * eff.exe i04_332a.gif 261 391 0 1 0 15 15 15 eff.exe i04_332b.gif 132 162 0 1 0 15 15 15 * You click Customize isave 391 260 637 226 text1 textbox 391 260 637 226 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_333a.gif 28 427 0 1 0 15 15 15 * On the Commands tab, you click isave 391 231 637 175 text2 growbox 391 231 637 175 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_334a.gif 357 443 0 1 0 15 15 15 eff.exe i04_334b.gif 161 274 0 1 0 15 15 15 * Next you drag the Style comman isave 391 180 637 124 text3 growbox 391 180 637 124 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_335a.gif 28 456 0 1 0 15 15 15 * The Style box is displayed on isave 391 129 637 73 text4 growbox 391 129 637 73 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 391 129 image memory text3 0 391 180 image memory text2 0 391 231 image memory text1 0 391 260 * eff.exe i04_336a.gif 2 453 0 1 0 15 15 15 eff.exe i04_336b.gif 2 17 0 1 0 15 15 15 * An advantage of having the Sty isave 107 175 478 107 text1 textbox 107 175 478 107 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 107 175 * eff.exe i04_337a.gif 2 379 0 1 0 15 15 15 eff.exe i04_337b.gif 130 456 0 1 0 15 15 15 eff.exe i04_337c.gif 130 19 0 1 0 15 15 15 * If the formatting you want has isave 116 189 429 121 text1 textbox 116 189 429 121 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_338a.gif 132 301 0 1 0 15 15 15 eff.exe i04_338b.gif 175 301 0 1 0 15 15 15 * The easiest way to create a st isave 116 126 429 70 text2 growbox 116 126 429 70 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 116 126 image memory text1 0 116 189 * eff.exe i04_339a.gif 344 457 0 1 0 15 15 15 eff.exe i04_339b.gif 130 316 0 1 0 15 15 15 * Then you click the Style field isave 33 200 381 166 text1 textbox 33 200 381 166 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_340a.gif 328 456 0 1 0 15 15 15 * You enter a name for the style isave 33 171 381 115 text2 growbox 33 171 381 115 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_341a.gif 2 379 0 1 0 15 15 15 eff.exe i04_341b.gif 144 457 0 1 0 15 15 15 eff.exe i04_341c.gif 144 19 0 1 0 15 15 15 * Now you click OK to create the isave 33 120 381 81 text3 growbox 33 120 381 81 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** *eff.exe i04_342a.gif 230 456 0 1 0 15 15 15 eff.exe i04_342b.gif 332 456 0 1 0 15 15 15 *eff.exe i04_342c.gif 230 330 0 1 0 15 15 15 eff.exe i04_342d.gif 347 330 0 1 0 15 15 15 * The new style is available to isave 33 86 381 47 text4 growbox 33 86 381 47 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 33 86 image memory text3 0 33 120 image memory text2 0 33 171 image memory text1 0 33 200 * eff.exe i04_343a.gif 2 456 0 1 0 15 15 15 eff.exe i04_343b.gif 2 19 0 1 0 15 15 15 * You can modify a style using t isave 284 454 628 420 text1 textbox 284 454 628 420 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_344a.gif 0 459 0 1 0 15 15 15 * When you click the style you'v isave 284 425 628 352 text2 growbox 284 425 628 352 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_345a.gif 0 459 0 1 0 15 15 15 * One way to modify a style is t isave 284 357 628 301 text3 growbox 284 357 628 301 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 284 357 image memory text2 0 284 425 image memory text1 0 284 454 * eff.exe i04_346a.gif 321 333 0 1 0 15 15 15 eff.exe i04_346b.gif 45 202 0 1 0 15 15 15 eff.exe i04_346c.gif 321 274 0 1 0 15 15 15 * You can also click the Modify isave 123 156 477 105 text1 textbox 123 156 477 105 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_347a.gif 11 421 0 1 0 15 15 15 * Here you click the Pattern tab isave 123 110 477 71 text2 growbox 123 110 477 71 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_348a.gif 85 415 0 1 0 15 15 15 * Then you click the Pattern dro isave 123 76 477 20 text3 growbox 123 76 477 20 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 123 76 image memory text2 0 123 110 image memory text1 0 123 156 * eff.exe i04_349a.gif 11 421 0 1 0 15 15 15 * You close the Format Cells dia isave 158 118 477 67 text1 textbox 158 118 477 67 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_350a.gif 190 453 0 1 0 15 15 15 eff.exe i04_350b.gif 17 364 0 1 0 15 15 15 * The modification has cha isave 158 72 477 16 text2 growbox 158 72 477 16 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 158 72 image memory text1 0 158 118 * eff.exe i04_351a.gif 2 403 0 1 0 15 15 15 eff.exe i04_351b.gif 2 196 0 1 0 15 15 15 * Remember that when you modify isave 31 180 415 112 text1 textbox 31 180 415 112 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_352a.gif 14 403 0 1 0 15 15 15 eff.exe i04_352b.gif 148 403 0 1 0 15 15 15 eff.exe i04_352c.gif 14 344 0 1 0 15 15 15 eff.exe i04_352d.gif 179 344 0 1 0 15 15 15 * For example, changing MyStyle1 isave 31 117 415 44 text2 growbox 31 117 415 44 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 31 117 image memory text1 0 31 180 * eff.exe i04_353a.gif 14 403 0 1 0 15 15 15 eff.exe i04_353b.gif 272 412 0 1 0 15 15 15 eff.exe i04_353c.gif 14 297 0 1 0 15 15 15 eff.exe i04_353d.gif 272 297 0 1 0 15 15 15 * If you notice immediately tha isave 90 172 399 104 text1 textbox 90 172 399 104 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 90 172 * eff.exe i04_354a.gif 2 427 0 1 0 15 15 15 eff.exe i04_354b.gif 419 19 0 1 0 15 15 15 * At times you might need to rem isave 40 181 351 130 text1 textbox 40 181 351 130 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_355a.gif 142 352 0 1 0 15 15 15 * First you select the range you isave 40 135 351 96 text2 growbox 40 135 351 96 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_356a.gif 26 457 0 1 0 15 15 15 eff.exe i04_356b.gif 45 457 0 1 0 15 15 15 * Then you select Edit - Clear isave 40 101 351 62 text3 growbox 40 101 351 62 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_357a.gif 45 457 0 1 0 15 15 15 eff.exe i04_357b.gif 449 447 0 1 0 15 15 15 * When you click Formats, Excel isave 40 67 351 11 text4 growbox 40 67 351 11 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 40 67 image memory text3 0 40 101 image memory text2 0 40 135 image memory text1 0 40 181 * * Topic: Customizing headers and footers Topic No.: 4 **** SimScrn 4 6 7 ********************************* MoveCtrl 1 493 460 0 0 eff.exe i04_401.gif 0 459 0 1 0 15 15 15 * A header is a line of informat isave 4 348 285 297 text1 textbox 4 348 285 297 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_402a.gif 272 424 0 1 0 15 15 15 eff.exe i04_402b.gif 159 113 0 1 0 15 15 15 * A footer is also a line of inf isave 4 302 285 229 text2 growbox 4 302 285 229 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_403a.gif 204 424 0 1 0 15 15 15 eff.exe i04_403b.gif 292 178 0 1 0 15 15 15 * Excel allows you the flexibili isave 4 234 285 144 text3 growbox 4 234 285 144 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 4 234 image memory text2 0 4 302 image memory text1 0 4 348 * qcall IE04q 040401 eff.exe i04_404a.gif 0 459 0 1 0 15 15 15 * Let's see how you select a bui isave 397 455 623 404 text1 textbox 397 455 623 404 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_405a.gif 113 136 0 1 0 15 15 15 eff.exe i04_405b.gif 264 200 0 1 0 15 15 15 * First you click the worksheet isave 397 409 623 370 text2 growbox 397 409 623 370 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_406a.gif 71 457 0 1 0 15 15 15 eff.exe i04_406b.gif 113 136 0 1 0 15 15 15 * Then you select View - Header isave 397 375 623 319 text3 growbox 397 375 623 319 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * Choosing File - Page Setup als notebox 401 291 606 ** image memory text3 0 397 375 image memory text2 0 397 409 image memory text1 0 397 455 * eff.exe i04_408a.gif 14 457 0 1 0 15 15 15 * In the Page Setup dialog box, isave 36 183 301 132 text1 textbox 36 183 301 132 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_409a.gif 345 456 0 1 0 15 15 15 eff.exe i04_409b.gif 487 456 0 1 0 15 15 15 eff.exe i04_409c.gif 11 406 0 1 0 15 15 15 eff.exe i04_409d.gif 487 406 0 1 0 15 15 15 * In the Header/Footer box, you isave 36 137 301 81 text2 growbox 36 137 301 81 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_410a.gif 20 366 0 1 0 15 15 15 eff.exe i04_410b.gif 20 330 0 1 0 15 15 15 * You choose Page 1 of ? isave 36 86 301 47 text3 growbox 36 86 301 47 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 36 86 image memory text2 0 36 137 image memory text1 0 36 183 * eff.exe i04_411a.gif 20 330 0 1 0 15 15 15 eff.exe i04_411b.gif 31 222 0 1 0 15 15 15 * In the Footer drop-down list, isave 64 119 253 68 text1 textbox 64 119 253 68 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_412a.gif 31 222 0 1 0 15 15 15 * Then you click OK to apply you isave 64 73 253 17 text2 growbox 64 73 253 17 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 64 73 image memory text1 0 64 119 * eff.exe i04_413a.gif 20 368 0 1 0 15 15 15 eff.exe i04_413b.gif 322 101 0 1 0 15 15 15 * Suppose that none of the pre-d isave 6 177 387 126 text1 textbox 6 177 387 126 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_414a.gif 20 371 0 1 0 15 15 15 eff.exe i04_414b.gif 20 250 0 1 0 15 15 15 * In this case, you need to defi isave 6 131 387 92 text2 growbox 6 131 387 92 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_415.gif 0 459 0 1 0 15 15 15 * Excel allows you to base a cus isave 6 97 387 41 text3 growbox 6 97 387 41 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_416a.gif 11 457 0 1 0 15 15 15 * You select View - Header and F isave 6 46 387 7 text4 growbox 6 46 387 7 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 6 46 image memory text3 0 6 97 image memory text2 0 6 131 image memory text1 0 6 177 * eff.exe i04_417.gif 0 459 0 1 0 15 15 15 * You click the footer in the Fo isave 31 420 328 352 text1 textbox 31 420 328 352 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_418a.gif 156 282 0 1 0 15 15 15 eff.exe i04_418b.gif 179 282 0 1 0 15 15 15 * Then you click Custom Footer isave 31 357 328 318 text2 growbox 31 357 328 318 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 31 357 image memory text1 0 31 420 * eff.exe i04_419a.gif 0 459 0 1 0 15 15 15 * Excel allows you only one cust isave 9 305 255 237 text1 textbox 9 305 255 237 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_420.gif 0 459 0 1 0 15 15 15 * If you create a new custom hea isave 9 242 255 152 text2 growbox 9 242 255 152 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 9 242 image memory text1 0 9 305 * eff.exe i04_421.gif 0 459 0 1 0 15 15 15 * Let's say that you want to mov isave 198 444 507 393 text1 textbox 198 444 507 393 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_422a.gif 11 453 0 1 0 15 15 15 eff.exe i04_422b.gif 14 258 0 1 0 15 15 15 * One way you can do this is to isave 198 398 507 325 text2 growbox 198 398 507 325 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 198 398 image memory text1 0 198 444 * eff.exe i04_423a.gif 15 258 0 1 0 15 15 15 * Assume you want the workbook n isave 3 194 282 143 text1 textbox 3 194 282 143 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_424a.gif 131 387 0 1 0 15 15 15 eff.exe i04_424b.gif 192 279 0 1 0 15 15 15 * First you can click Center sec isave 3 148 282 58 text2 growbox 3 148 282 58 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i04a424a.gif 74 387 0 1 0 15 15 15 eff.exe i04a424b.gif 131 387 0 1 0 15 15 15 eff.exe i04a424c.gif 74 252 0 1 0 15 15 15 eff.exe i04a424d.gif 279 252 0 1 0 15 15 15 qcall IE04q 040402 eff.exe i04_425a.gif 262 388 0 1 0 15 15 15 eff.exe i04_425b.gif 192 279 0 1 0 15 15 15 * You click the File Name button isave 3 63 282 7 text3 growbox 3 63 282 7 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 3 63 image memory text2 0 3 148 image memory text1 0 3 194 * eff.exe i04_426a.gif 262 388 0 1 0 15 15 15 eff.exe i04_426b.gif 192 279 0 1 0 15 15 15 * Suppose you want to enter addi isave 11 150 389 116 text1 textbox 11 150 389 116 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_427a.gif 389 325 0 1 0 15 15 15 * You click the section where yo isave 11 121 389 65 text2 growbox 11 121 389 65 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_428a.gif 389 325 0 1 0 15 15 15 * To start a new line of text, y isave 11 70 389 14 text3 growbox 11 70 389 14 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 11 70 image memory text2 0 11 121 image memory text1 0 11 150 * eff.exe i04_429a.gif 367 279 0 1 0 15 15 15 * To delete a section of a foote isave 15 134 307 66 text1 textbox 15 134 307 66 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 15 134 * eff.exe i04_430a.gif 196 271 0 1 0 15 15 15 * Let's say that you want to cha isave 33 164 279 113 text1 textbox 33 164 279 113 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_431a.gif 198 255 0 1 0 15 15 15 * You select the text in the Cen isave 33 118 279 62 text2 growbox 33 118 279 62 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** qcall IE04q 040403 eff.exe i04_432a.gif 95 386 0 1 0 15 15 15 eff.exe i04_432b.gif 528 367 0 1 0 15 15 15 eff.exe i04_432c.gif 196 271 0 1 0 15 15 15 * You click Font isave 33 67 279 28 text3 growbox 33 67 279 28 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 33 67 image memory text2 0 33 118 image memory text1 0 33 164 * eff.exe i04_433a.gif 2 395 0 1 0 15 15 15 * In the dialog box, you select isave 15 190 252 122 text1 textbox 15 190 252 122 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_434a.gif 3 331 0 1 0 15 15 15 eff.exe i04_434b.gif 420 339 0 1 0 15 15 15 eff.exe i04_434c.gif 3 201 0 1 0 15 15 15 eff.exe i04_434d.gif 420 201 0 1 0 15 15 15 * Then you click OK to close the isave 15 127 252 71 text2 growbox 15 127 252 71 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_435a.gif 2 443 0 1 0 15 15 15 * And you click OK to return to isave 15 76 252 20 text3 growbox 15 76 252 20 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 15 76 image memory text2 0 15 127 image memory text1 0 15 190 * eff.exe i04_436a.gif 2 458 0 1 0 15 15 15 * Before printing your document, isave 363 458 637 390 text1 textbox 363 458 637 390 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_437a.gif 8 458 0 1 0 15 15 15 * To do this you click the Margi isave 363 395 637 356 text2 growbox 363 395 637 356 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_438a.gif 11 418 0 1 0 15 15 15 eff.exe i04_438b.gif 404 453 0 1 0 15 15 15 eff.exe i04_438c.gif 126 233 0 1 0 15 15 15 * To change the distance from th isave 363 361 637 271 text3 growbox 363 361 637 271 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_439a.gif 133 402 0 1 0 15 15 15 eff.exe i04_439b.gif 134 229 0 1 0 15 15 15 eff.exe i04_439c.gif 235 228 0 1 0 15 15 15 * These settings should be small isave 363 276 637 220 text4 growbox 363 276 637 220 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_440a.gif 133 402 0 1 0 15 15 15 eff.exe i04_440b.gif 126 233 0 1 0 15 15 15 eff.exe i04_440c.gif 323 119 0 1 0 15 15 15 * You click OK to close the Page isave 363 225 637 169 text5 growbox 363 225 637 169 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text5 0 363 225 image memory text4 0 363 276 image memory text3 0 363 361 image memory text2 0 363 395 image memory text1 0 363 458 * *eff.exe i04_441a.gif 369 363 0 1 0 15 15 15 *eff.exe i04_441b.gif 319 122 0 1 0 15 15 15 eff.exe i04_441.gif 0 459 0 1 0 15 15 15 * To see how the new footer marg isave 3 337 329 269 text1 textbox 3 337 329 269 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_442a.gif 0 459 0 1 0 15 15 15 * You can adjust the header and isave 3 274 329 218 text2 growbox 3 274 329 218 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_443a.gif 122 457 0 1 0 15 15 15 * You click Margins, and then dr isave 3 223 329 184 text3 growbox 3 223 329 184 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_444a.gif 118 457 0 1 0 15 15 15 * Excel displays the new setting isave 3 189 329 150 text4 growbox 3 189 329 150 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i04_445a.gif 149 457 0 1 0 15 15 15 * You click Close to return to y isave 3 155 329 116 text5 growbox 3 155 329 116 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text5 0 3 155 image memory text4 0 3 189 image memory text3 0 3 223 image memory text2 0 3 274 image memory text1 0 3 337 * * Topic: Hands-on: Customizing a header Topic No.: 5 **** SimScrn 4 7 7 ********************************* exercise 02 1 120 70 * MoveCtrl 1 493 460 0 * task 02 0102 0 317 220 9 50 67 5 5 *task 02 0102 0 317 220 9 50 67 5 5 * pause 1 1 1 1 1 1 1 1