Home

AppleWorks 5 User`s Manual: for Windows 95/NT 4.0

1. E E_E In the Help index see gt layouts mailing labels New layout names are added to the bottom of the Layout menu and the bottom of the Layout pop up menu You can quickly change the layout of your data in Browse mode by selecting a different layout name from either menu Columnar layouts To create a columnar layout click Columnar report in the New Layout dialog box and then click OK Move the field names to the Field Order list in the order you want them to appear and then click OK File Customer City State File Customer City State Giga wn Sided Race awd Fie Customer Ciy State 107 Adventure Books Durango co Bod g 106 Book Cellar Portland OR 103 Cooks and Books Belmont CA Columnar layout in Layout mode Columnar layout in Browse mode Label layouts To create a layout for labels click Labels in the New Layout dialog box choose a label from the pop up menu and then click OK Avery 5160 5260 5660 are the most common label sizes used for shipping and postal service mailers In the Set Field Order dialog box move the field names to the Field Order list in the order you want them to appear on the label and then click OK Name Adventure Books Address 1 100 Aspen Lane Address 2 Building 2 suite 300 City ST ZIP Durango CO 99332 Avery 5160 5260 5660 label Avery 5160 5260 5660 label layout layout in Layout mode in Browse mode If you choos
2. amp be miee Horizontal Ezaa iiaeaae Tu pane A EE control Text ruler 100 Jal TI Page 1 Zoom percentage box 7716 97 5 31 PM 4 Status bar Vertical pane control Zoom controls Page indicator Show hide tools control The status bar at the bottom of the AppleWorks window provides information about your document 3 2 AppleWorks 5 User s Manual When you work with objects and frames this code changes to show the type of menus currently available Current date and time Sets the fill patter DR Modified REC 7 15 97617PM 4 Displays information as you move the Modified means you When you record or play a macro pointer over a tool or menu command have unsaved changes you see REC or PLAY here Tip As you work in AppleWorks click the right mouse button to see a menu of appropriate commands Viewing windows You can view a window and its contents in different ways For example to In the Help index see see a drawing in detail you can enlarge your view of it zoom in When you gt viewing documents finish zoom out to return to its original size To Do this Example Zoom in or out Click P to zoom in click M or choose a to zoom out or click the zoom 3K zoom percentage box and select a percentage percentage Split a window Click the horizontal pane vertically or control in the upper right horizontally to corner or the vertical pane display different control at t
3. Creating a drawing To Do this Example In the Help index see Create a blank Choose New from the File menu MEAT draw document select Drawing and then click OK gt documents creatin Sie gt documents an Or click on the Default Bs button bar If you don t see the button bar choose ShowButtonBar JE from the Window menu A draw document Draw objects in any type Select a drawing tool from the of document except tool panel and drag the pointer communications in the document If you don t see the panel choose Show Tools Circle drawn ina from the Window menu The spreadsheet document frame tools appear amp A Note You can create pictures by either drawing or by painting For information about painting and how it differs from drawing see chapter 6 Painting About the draw window When you open a new draw document you see the draw menus tool panel In the Help index see and graphics grid a guide you can use to size position and align objects gt draw documents gt grids gt rulers gt tools Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Draw menus Drawing 5 3 Tool panel 4 File Edit Format Arange Options Window Help la x 8 3 8 5 8 sy SS 28 Be 3 Bl 8 Bl Bl Bl 7 Ul F355 i dinane tor comino D 22 1B Se a
4. Delete a chart Press Delete Move a chart to another Drag it to a new position not by a handle Moving a chart location in the same document maintains the link to the chart s spreadsheet Resize a chart Drag one of its handles Scale a chart to a specific Choose Scale By Percent from the Arrange menu and then enter percentage percentages to scale the chart horizontally and vertically K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Original chart Enhanced chart Spreadsheet 7 31 To Select the chart and then Hide a spreadsheet frame If necessary resize the spreadsheet frame to make it smaller under a chart than the chart Then select the chart and drag it over the spreadsheet Bring a hidden spreadsheet Select the chart and then click 4 on the Default button bar frame back into view or choose Move To Back from the Arrange menu Enhancing a chart s appearance Because a spreadsheet chart is an object you can change the chart s appearance by selecting all or part of it and using the fill and pen palettes and text formatting commands Title California poppy Eschscholzia Yaxis H Germination rate Legend Series symbol Series box X axis 0 50 100 Axes labels ermination rate Hide the chart s border California poppy Eschscholzia A m Hide the t
5. The footer displays the page number Basics 3 13 Type or insert header text here cone heiii Lwem Geom ie sl aoe sareatna sapane ald t ana at alert wage eae et n eam inani Lae ipa Gk laeras eoresutava vipave Uk 146 dan ith kodas at vom Re nowy eb soa teh ue wt uae de msp Adee mage sipon ant misga U wei pis rected aaam a R eee ee Scare Seer erie a vin be eet eee Type or insert footer text here In headers and footers you can type text use the text ruler to set indentation tabs justification and line spacing include other elements such as a page number date or graphics For example you can create a header to display a chapter title at the top of each page and create a footer to display the current page number at the bottom of each page Seer a The header displays the i a canis di Seeing eh nhinuriiineg ah same text at the top of paranana atte adn each page Rodale winks ues org wisane a beo odo denimin gil wepo impe midori TASA Muettty Repot Title page contains no header or footer oa arina gat ein caw va 3 14 AppleWorks 5 User s Manual You see the header and footer on the page when you print and on the screen when you re in page view See Previewing pages for printing on page 3 11 for more information To remove a header or footer choose Remove Header or Remove Footer from the Format menu Note You can divide a word processing docume
6. In the Help index see gt collapsing text labels such as Roman numerals numbers and letters are underlined you don t see the underline character when you print diamonds change from black to gray Tip To collapse or expand an item quickly double click it To Collapse a topic or outline so that subtopics are hidden Do this Select the topic or outline and choose Collapse from the Outline menu Example before and after A Grants A B Loans B 1 Institutional 2 Government 3 Private Sector Grants Expand a topic or outline so that subtopics are visible Select the topic or outline and choose Expand from the Outline menu A Grants B Loans 1 Institutional 2 Government 3 Private Sector Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Text word processing 4 17 To Do this Example before and after Expand the Click in the topic or select the L Planning 1 Planning II Funding II Funding current topic or entire outline Choose Expand A Grants A Grants an entire outline To from the Outline menu B Loans B Loans ot 1 Institutional III Building to a specific and then type a number in the gt Gaverniiont level dialog box 3 Private Sector P 8 III Building Outline expanded to level 2 subtopics Outline fully expanded Collapse or Select all the t
7. New Button 2 x Button Name Show Button In Type aname for the button s 6r er VW Button Description Vv Type a brief description of what the F il button does the description r displays in the status line F Sp When button pressed Tr Macro X Select which document types you want the button to appear in Select the task you want the button to perform Click to create a button design Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Using macros Beyond the basics 9 29 To set the task that the button performs choose an option from the When button pressed pop up menu To make the button From the When button pressed pop up menu choose Play a macro Play Macro Enter the name of the macro you want the button to play Open a document Open Document Click Select Document select the document you want the button to open and then click Open Open another application Launch Application Click Select Application select the application you want the button to open and then click Open Open a URL Open URL Enter the URL for the document to link to on the World Wide Web Your computer must already be set up with a Web browser and an Internet connection for the URL button to link to the document To edit a button choose Edit Buttons from the menu on the butto
8. Start by clicking s on the Default button bar or choosing Show Stylesheet from the Window menu to show the stylesheet palette Then click the Edit button on the stylesheet palette To Cut or copy a style Do this Select a style and choose Cut Style or Copy Style from the stylesheet palette s Edit menu Paste a style Cut or copy a style and then choose Paste Style from the stylesheet palette s Edit menu If the style you re pasting has the same name as another style on the palette you see a dialog box Type a new name for the style and then click Rename to replace the style with the new style Delete a style Select a style and then choose Clear Style from the stylesheet palette s Edit menu You can t delete a style that other styles are based on or any style that is in use in the current document Cut copy or delete properties Select a style click Edit and then select one or more properties Then choose Cut Properties Copy Properties or Clear Properties from the stylesheet palette s Edit menu Paste properties Select a style click in the Properties box and then choose Paste Properties from the stylesheet palette s Edit menu Note You cannot cut copy or paste substyles If you want to change or copy information contained in a substyle edit or copy its properties K Choose Index from the Help menu and type the first few letters of the entry Double click the entry
9. When you move and delete footnotes or endnotes the remaining footnotes or endnotes are renumbered and the document is adjusted accordingly To delete a footnote select the footnote reference and press the Backspace key Finding and changing text In the Help index see gt finding text Click to match text only to entire words Click to match upper and Match case lowercase exactly You can use the AppleWorks Find Change command to save time finding a particular word or phrase in your document or to find and replace some or all occurrences of specific text To find and replace text choose Find Change from the Edit menu and then choose Find Change Type the word or phrase you want to find Click to find the next occurrence without making a change Find Change Find what lorem Change to Smoren T Match whole word only Click to replace this occurrence and then find the next one Click to replace only this occurrence and end the search Change All Click to replace all Type the text to be used as the occurrences at once replacement optional K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 4 28 AppleWorks 5 User s Manual If you leave the Change to box empty clicking any change button deletes the text that is found Once you close the Find Change dialog box you can find the text fo
10. Choose the category of options you want to set Set options to customize the way you work in AppleWorks Click to use the current settings whenever you create a document Basics 3 21 Preferences for untitled CWK 2 x 1 Topic F m Polygon Closing Gradient Manual POR Fast Gradient Printing C Automatic ace Best Gradient Printing m Object Selection m Options Bo I Automatically Smooth Freehand C El Mouse Shift Constraint a5 From the Topic pop up menu choose General Make Defaut Cancel _ To set preferences for General display of alerts warnings settings for saved documents and startup settings Text The preset font for new documents character display smart quotes invisible formatting characters and character spacing and date format Graphics Object selection polygon closing mouse control and gradients Spreadsheet The way the arrow and Enter keys select text and cells in a spreadsheet Palettes The number of colors displayed in the color palettes and opening and saving color pattern texture and gradient palettes Communications Default communications software Chapter 4 Text word processing This chapter explains how to work with text to produce attractive professional word processing documents All text features including procedures buttons and troubleshooting are described completely in onscreen Help When to use a
11. Linking to other documents 1 1 1 1 1 3 1 3 1 4 1 5 1 7 1 7 1 8 1 8 1 8 1 9 1 10 1 11 1 11 1 12 1 13 1 14 2 1 2 2 2 3 2 5 2 7 2 8 2 9 IV AppleWorks 5 User s Manual Saving document formatting as templates stationery Setting up regular stationery Setting up default stationery Creating stationery Opening stationery Identifying your documents Protecting documents with passwords Importing and exporting documents Closing a document and leaving AppleWorks Printing a document or Help topic Chapter 3 Basics Working with windows Viewing windows Arranging windows Going to a page Using the tool panel Using the button bar Switching button bars Showing hiding and positioning the button bar Customizing the button bar Adding and removing buttons Creating your own button bar Using palettes Working with frames Working in an AppleWorks document Cutting copying and pasting Changing your mind Previewing pages for printing Using rulers Creating headers and footers Adding a date or time Numbering pages Setting margins Changing the page orientation and size 2 10 2 10 2 11 2 11 2 12 2 13 2 14 2 15 2 16 2 16 3 1 3 2 3 3 3 4 3 5 3 5 3 6 3 6 3 6 3 7 3 9 3 10 3 10 3 10 3 11 3 12 3 12 3 14 3 15 3 16 3 16 Contents V Using libraries 3 17 Creating opening and saving libraries 3 18 Working with the library palette 3 18 Duplicating deleting and moving library
12. oe Corea eer ee Assistant for creating tables Creating opening and printing documents 2 5 An Assistant prompts you to supply information Based on that information AppleWorks creates the document for you This Assistant Address List Helps you to Create a database listing of names and addresses for business personal or student information Business Cards Create business cards for business or personal use Calendar Create a monthly calendar Certificate Create certificates awards or diplomas Create Labels Assistant Create a database layout for labels Envelope Home Finance Position and print addresses including return addresses on envelopes For more information see Addressing envelopes on page 9 22 Examine home finance questions such as determining your net worth buying a home or taking out a loan Insert Footnote Place a footnote in a document For more information see Adding footnotes and endnotes on page 4 26 Make Table Insert and format a table within a document For more information see Creating tables on page 4 18 Newsletter Create newsletters for your club school or business Paragraph Sorter Sort paragraphs alphabetically within a document For more information see Sorting paragraphs on page 4 13 Presentation Create presentations to view on a computer or overhead projector or on paper Using station
13. AppleWorks 5 User s Manual Includes instructions for using your software Apple Computer Inc 1998 Apple Computer Inc All rights reserved Under the copyright laws this manual may not be copied in whole or in part without the written consent of Apple Your rights to the software are governed by the accompanying software license agreement The Apple logo is a trademark of Apple Computer Inc registered in the U S and other countries Use of the keyboard Apple logo Option Shift K for commercial purposes without the prior written consent of Apple may constitute trademark infringement and unfair competition in violation of federal and state laws Every effort has been made to ensure that the information in this manual is accurate Apple is not responsible for printing or clerical errors Apple Computer Inc 1 Infinite Loop Cupertino CA 95014 2084 408 996 1010 http www apple com Apple the Apple logo AppleWorks and the AppleWorks design Claris and QuickTime are trademarks of Apple Computer Inc registered in the U S and other countries Other company and product names mentioned herein are trademarks of their respective companies Mention of third party products is for informational purposes only and constitutes neither an endorsement nor a recommendation Apple assumes no responsibility with regard to the performance or use of these products Simultaneously published in the United States and Canada E
14. Descending order Type aname for the sort Select sort order for selected fields Cooks and Books 45 First St Belmont CA 94002 Adventure Books ___ Records are sorted by State then 100 Aspen by Customer Durango CO 99332 Treetop Books 23 Forest Boulder co 80302 To From the Sort Iii pop up menu choose Ma Use a named sort The named sort New Sort Ue Caeser Change the sort order Edit Sort Select a named sort from the list and click Modify State Customer Select a field choose Ascending or Descending and then click OK sata Rename a named sort Edit Sort Select a named sort from the list and then click Modify Type a new name and then click OK Delete a named sort Edit Sort Select a named sort from the list click Delete and then click OK Note AppleWorks sorts name fields fields whose type is Name by the last first or other word in the field depending on how you type the name For more information see Entering data in fields on page 8 12 Finding information Finding text In the Help index see gt finding text gt find requests Database 8 23 There may be times when you want to view update or print a specific group of records To find information in a database you can search for particular text create a find request to search for records that meet your criteria or write a formula to select records that match the formula s result To fin
15. Drawing 5 11 ey aE TARTS Tip You can create styles combinations of formatting information and In the Help index see then apply the styles with a single click To show the stylesheet click 4s on gt styles the Default button bar or choose Show Stylesheet from the Window menu For example if you create a style called Wide Border you can apply it to objects and frames any time you want When you change a style all the objects with the same style also change For information on creating and using styles see onscreen Help and Using styles on page 9 5 789 89 Select the objects to change After Fie Edit ee Edit Bleck Fil Red Border Checked Fill Checked Fill Bord Default SS Base Style None Red FilBlue Border Red FillBlu Obj Pen Size Spt Then click to apply a V Wide Border vide Border Obj FilCoo style that you created Default D Paragraph Obj Pen Pattern EEE Default gt Outline Sties i gt Table Stes To see astyle s properties click Properties of the selected Edit and then select the style style Copying an object s attributes Use the eyedropper to pick up copy an object s attributes color and In the Help index see pattern gradient or texture and pen width and arrowhead settings and make gt objects copying attributes them the current settings without having to select them from a palette You can also use the eyedropper to apply the current settings to another obj
16. Center Default Then click to pergcmrwmn Before apply a style BD Tabs Accounting Blue Gray 1 p gt Blue Gray 2 D Classic gt Colorful Auto Expenses Repairs 102 00 Blue Gray 2 Gas 31 00 Classic Tolls 12 00 Total 145 00 After To see astyle s properties click Properties of the style Edit and then select the style 3D Table 1 Sorting cell data Sort data in numeric or alphabetical order to organize it You can specify a major In the Help index see order key the cell where the sort starts and two minor order keys If you are gt sorting spreadsheet data sorting a list containing duplicate entries use second and third order keys to further organize your data for example by first name and middle initial To sort spreadsheet data select the cells you want to sort and click 24 to sort in ascending order or click 2t to sort in descending order You can also choose Sort from the Calculate menu In the Sort dialog box select the options you want and click OK K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 7 12 AppleWorks 5 User s Manual EM Smith 4 J Ca Smith Ann Before sorting After sorting on first After sorting on first order key order key A2 only A2 second order key B2 and third order key C2 Locking cell data Protect data or formulas from accidental changes by locking cells
17. Checking your spelling In the Help index see gt spelling Double click or type Alt a number to replace a word You can check all the text in the document or text that you select To check Do this All the text in the document Click on the Default button bar or choose Writing Tools from the Edit menu and then choose Check Document Spelling A selection Select the text or text frame you want to check Click on the Default button bar or choose Writing Tools from the Edit menu and then choose Check Selection Spelling Once you choose either command the Spelling dialog box appears and AppleWorks begins checking for questionable words The spelling checker verifies the words you are checking in the main dictionary which is installed with AppleWorks and any installed user dictionaries If it does not find a word it suggests alternatives If the spelling of the word in question is correct such as the spelling of someone s name you can add the word to a user dictionary by clicking Learn the annual book fair next Friday and Saturday Several prominent there to sign your EE books We ll have entertainment too The Spelling x Check Skip Learn Cancel Context lt lt Click to replace with the word selected in the list changes to Done when check is complete Click to add the questionable word to the user dictionary IN 1S A e 160 INS e Click to hide or show the wo
18. Continent Asia contiguous Country Yietnam records i Continent Country Continent North America Country Canada Show all records Click on the Default Continent Asia button bar or choose Show Country Japan All Recordsfrom the Organize continent Asia menu Country Vietnam Continent Europe Country France Continent North America Country Canada You can sort records alphabetically or numerically based on the fields you specify You can also save a set of sort criteria called a named sort for reuse You can sort records in Browse mode and List mode Tip To sort records quickly by field select the field and then on the Default button bar click 24 to sort in ascending order or click 24J to sort in descending order Hidden records are not sorted To save a set of sort criteria choose New Sort from the Sort ii pop up menu To sort records without saving the criteria choose Sort Records from the Organize menu K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 8 22 AppleWorks 5 User s Manual Click to move fields between the Field List Click to clear the and the Sort Order list Sort Order list Sort Records Field List Sort Order all State all Customer Order of fields from first to last Select fields to sort by field names move to the Sort Order list Sort Name al Ascending order Sort 1 h
19. Wednesday Chih carrot sticks cookies Let us know what you think and then we ll make adjustments and go shopping Word processing document Spreadsheet or database You can use either a spreadsheet or a database document to store and organize information Use a spreadsheet when you primarily want to do computations or when you want to do simple numeric or alphabetic sorts Use a database document when you want to print labels present the information in various layouts or do complex sorting For more information on databases see chapter 8 Database A spreadsheet can be a document or a frame a spreadsheet within another document You use the same commands and controls any time you work with a spreadsheet whether it s a document or a frame K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Spreadsheet 7 3 Creating a spreadsheet To create a Do this Example Blank spreadsheet Choose New from the File menu In the Help index see gt New command gt spreadsheet frames document select Spreadsheet and then click OK Or click on the Default button bar If you don t see the button bar choose Show Button Bar from the Window menu Spreadsheet frame within Select the spreadsheet tool 4 a document except choose Show Tools from the communications Window ment if it isn t v
20. a spreadsheet to a letter without first creating a spreadsheet document Introduction 1 9 Text word processing documents Use a word processing document to write a letter report story outline form letter or other project that is mostly text If you want to add a spreadsheet or pictures you can do so without leaving the word processing document by creating a spreadsheet frame or drawing directly in the letter File Edit Format Font Size Style Outline Window Help 18 x 2 a BY BY 8 2 S SJ 2 23 8 2 SJ G Gl BY 7 Ul 3 Bl Al Al BI Sl S Word processing menus button bar and ruler B Se2 4 die2eeio ol jo Iz lz W Ts le iF Te July 30 1997 Mr Benjamin Mason 123 Main Street Philadelphia PA Dear Sir Euismod tincidunt ut la oreet dolore magna aliquam erat voluptpat Ut wisi enim ad minim veniam quis nostrud exe gt RRA Eusimod tincidunt ut laoreet doli minim veniam quis nostrud exe Drawa logo g A July 30 1994 Write a letter in a word Mr Benjamin Mason processing document 123 Main Street Philadelphia PA Dear Sir Euismod tincidunt ut la oreet dolore magna aliquam erat voluptpat Ut wisi er minim veniam quis nostrud exercitation uliamcorper suscipit lobortis nisi uta Eusimod tincidunt ut laoreet dolore magna aliquam erat volutpat Ut wisi enir minim veniam quis nostrud exercitation ullamcorper suscipit lobortis nisi uta Qty
21. and then type new size values Choose Close from the File menu Change which part of the spreadsheet shows in the frame Select any cell in the frame and then choose Display from the Options menu Type a cell address in the Origin box and then click OK Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Spreadsheet 7 5 As you work with spreadsheet frames keep the following points in mind You can t change or open any type of frame in a paint document See Adding text and spreadsheets on page 6 12 for more information a You can link two or more spreadsheet frames in a document See Linking frames on page 9 24 Typing in a spreadsheet In the Help index see gt entering spreadsheet data gt spreadsheets documents Each cell in a spreadsheet can contain numbers words or formulas Click J to To type numbers or words in a confirm the entry cell click a cell and begin typing qE to cancel appears in the entry bar The entry appears in the cell To enter a negative number begin the number with a minus sign To enter a formula or function begin the entry with an equal sign See Working with formulas on page 7 20 and Examples Entering formulas on page 7 25 for more information Note You can also print or merge database information on a spreadsh
22. described 1 12 entering data in 8 12 examples of 8 4 8 5 field definitions 8 3 types 8 3 8 7 8 12 find requests 8 23 8 25 formulas and functions in 7 21 8 8 8 10 8 11 importing data to 8 37 inserting data in 8 37 merging data from 9 19 9 22 modes of described 8 2 Find 8 23 Layout 8 29 multiple 8 31 movies in 8 9 9 26 parts 8 34 8 36 pictures adding to 8 9 8 14 8 32 preferences for 3 20 printing 8 38 slides in 9 17 text attributes changing for 8 19 8 33 when to use 8 1 Database modes 8 2 Databases See also Database documents described 8 1 designing 8 6 elements of 8 2 importing 8 37 spreadsheets and differences 7 2 Dates conventions for 3 14 current in databases 8 13 text 3 14 3 15 format preferences 3 21 formatting in databases 8 8 8 33 spreadsheets 7 10 recording automatically 8 9 sorting paragraphs by 4 13 DB document type 2 3 3 9 Default button bar 3 5 font changing 3 21 font in spreadsheets 7 10 formatting options stationery 2 11 preferences setting 3 20 Deleting charts 7 30 fields 8 12 footnotes 4 27 headers and footers 3 14 images 6 8 layouts 8 32 library items 3 19 named searches 8 25 sorts 8 22 named cells 7 13 objects 5 9 records 8 15 reports 8 37 sections 4 23 spreadsheet cells columns and rows 7 17 Index l 3 data 7 8 page breaks 7 19 styles 9 15 text 4 4 undoing deletion 3 10 Depth perspective adding t
23. from the Edit menu Then select Page Number to insert the page number or Document Page Count to insert the total number of pages in the document Page number inserted in a footer A fixed page number Hold down Alt as you choose Insert that does not update Page from the Edit menu whenever pages are added or removed AppleWorks is preset to paginate a document using numbers To use Roman numerals or letters choose an option from the Representation pop up menu in the Insert Page Number dialog box Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 3 16 AppleWorks 5 User s Manual To set the starting page number choose Document from the Format menu enter a number for Start at Page in the Document dialog box and then click OK You can also number sections in a word processing document See Numbering sections on page 4 25 Setting margins In the Help index see gt Show Margins command AppleWorks presets the margins for each type of document For these document types Margins are set to Word processing 1 inch on all sides Spreadsheet 0 5 inch on all sides Draw paint database The smallest possible margin for the type of printer you ve chosen To change the margins for a document choose Document from the Format menu to show the Document dialog box Type the margin widths you want in the Top Bo
24. or border of Click the series box once and then choose from the a series for example the bars onabar fill and pen palettes chart or the symbol on a scatter chart Make a chart or the series Choose the transparent icon f from the for example the bars on a fill pattern palette bar chart transparent Note To change the appearance of chart elements in one step select the element and apply a style For information on applying styles or creating your own see Using styles on page 9 5 Adding pictures or a text frame AppleWorks provides you with several methods for adding pictures to a spreadsheet You can also add text frames to create special effects Pictures or text frames that you add to a spreadsheet are objects and can be moved and manipulated just as other objects can See What are objects on page 5 3 for more information about objects Note Pictures and frames are layered on top of the spreadsheet You can t place a picture in the entry bar or directly in a spreadsheet cell Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Spreadsheet 7 33 Draw a rectangle and Add clip art from an fill it with a gradient AppleWorks library Type in a text frame rotate the frame and drag it over the rectangle Start by choosing Show Tools from the Window menu to display the tool panel To Do this Exa
25. you can change the appearance of the text inside Changes you make while a text frame is selected affect all the text in the frame Cutting copying and pasting text In the Help index see gt copying text Once you ve selected text you can cut or copy it to the Clipboard and paste it elsewhere in the document or in a different document or frame See Cutting copying and pasting on page 3 10 Tip To move text quickly select the text you want to move hold down Ctrl Alt and then click where you want to move the text Showing formatting characters In the Help index see gt invisible characters When you press certain keys such as the Space bar or Tab or Enter you place special characters in your document called formatting characters that contain instructions for formatting your text AppleWorks is preset to hide formatting characters However it may be easier to edit with formatting characters visible For example you can find where you typed two spaces together where you want only one and then delete the extra space To show formatting characters choose Preferences from the Edit menu choose Text from the Topic pop up menu and then select Show Invisibles To hide formatting characters deselect Show Invisibles To show or hide formatting characters as you work click f on the Default button bar or type Ctrl semicolon For more information see Setting preferences on page 3 2
26. you see the topic Double click a topic you want to see Cancel To return to the same place in the index click the button Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Leaming more about onscreen Help Introduction 1 7 Refer to AppleWorks Help for more tips on locating information and customizing onscreen Help For information on Adding your own notes to a Help topic In the Help index see gt Help customizing Copying Help topics into an existing document gt Help copying Finding text within a Help topic gt Help finding Marking topics you use often gt Help customizing Printing one or more Help topics gt Help printing Referring to a glossary of AppleWorks terms gt glossary Getting additional help Here are more ways to learn about AppleWorks To Take an onscreen tour of the most important AppleWorks features and concepts Do this Choose Introduction to AppleWorks from the AppleWorks Help menu Use automated assistance in creating various types of documents such as newsletters and presentations Choose New from the File menu and then select UseAssistant or Stationery Choose a category from the pop up menu and then select an Assistant from the scrolling list For more information about Assistants see Using an Assistant on page
27. 33 9 17 QuickTime extension 9 26 Moving database columns and rows 8 19 fields 8 31 records 8 15 images 6 8 objects 5 7 outline topics 4 16 spreadsheet cells and data 7 7 Multimedia fields Index l 7 attributes changing 8 33 described 8 9 moving with database document 8 17 N Name fields 8 8 8 13 8 22 Named cells 7 13 cells in formulas 7 14 search 8 25 Naming cells 7 13 documents 2 7 fields 8 3 8 12 layouts 8 29 8 32 reports 8 37 searches 8 25 sort sequences 8 21 8 22 Negative numbers entering 7 5 formatting 7 10 New documents creating 2 1 Newsletter Assistant 2 5 Non breaking space 4 4 Number fields 8 8 Numbering footnotes 4 26 outlines 4 13 4 16 pages 3 15 paragraphs 4 11 sections 4 25 Numbers entering in spreadsheets 7 5 7 10 formatting in databases 8 19 8 33 spreadsheets 7 10 sorting paragraphs by 4 13 Oo Objects See also Arcs Bezigons Circles drawing Freehand objects Lines Polygons Rectangles drawing Regular polygons Rounded rectangles drawing Squares drawing Choose Index from the Help menu and scroll to the entry Then choose a topic from the list and click Go To Topic 1 8 AppleWorks User s Guide arranging 5 15 borders of 5 3 5 10 changing appearance of 5 9 orientation of 5 15 coloring 5 10 connecting 5 13 copying attributes of 5 11 one or more 5 9 deleting 5 9 described 5 3 drawing tools 5 4 duplicating 5
28. 8 8 finding 8 25 8 27 Ranges of cells naming 7 13 Index 1 9 REC in status bar 3 2 Record info fields 8 9 Records See also Database documents Fields Layouts adding 8 14 copying or deleting 8 15 described 8 2 duplicating 8 15 finding and matching 8 23 8 26 going to 8 15 hiding 8 20 numbering of 8 25 selecting 8 20 sorting 8 7 8 13 viewing 8 16 8 17 8 21 Rectangles drawing 5 4 See also Objects Reduced view See Zooming References cell 7 19 7 20 7 22 7 23 Regular polygons 5 4 5 5 5 13 6 5 See also Objects Relative references 7 22 Reordering paragraphs 4 13 Reports 8 36 Reshaping or smoothing See also Shaping images 6 9 objects 5 13 Resizing database fields 8 31 parts 8 36 rows and columns 8 18 draw documents 5 18 images 6 10 objects 5 12 paint documents 6 14 frames 6 4 spreadsheet charts 7 30 columns and rows 7 16 documents 7 18 frames 7 4 7 18 Resolution and depth paint 6 13 Reverting to a previously saved version of a document 3 10 Roman numerals in page X Choose Index from the Help menu and scroll to the entry Then choose a topic from the list and click Go To Topic 1 10 AppleWorks User s Guide numbers 3 15 Rotating images 6 10 objects 5 15 Rounded rectangles drawing 5 4 5 13 6 5 See also Objects Rows database viewing data in 8 16 8 18 8 19 spreadsheet changing number of 7 4 headings 7 3 7 19 7 20 inserting and deleting 7 17 resizi
29. 9 filling 5 10 grouping and ungrouping 5 15 5 16 inserting in text 4 31 locking and unlocking 5 16 moving 5 7 pasting 3 10 reshaping or smoothing 5 13 scaling 5 12 selecting 5 6 selection preferences 3 21 storing in libraries 3 17 Sa ae Linking and Embedding Online service 10 2 Onscreen Help See Help Opening button bar 3 6 documents AppleWorks 2 8 Assistants 2 3 from different applications 2 15 linked 9 3 new 2 1 stationery templates 2 5 HTML files 11 9 libraries 3 18 palettes fill and pen 5 9 library 3 18 links 9 2 mail merge 9 21 stylesheet 9 5 Operators 7 23 8 24 Options stationery 2 11 Order keys 7 11 Outdenting indented paragraphs 4 10 Outline styles 4 17 9 7 Outlines 4 13 4 16 Ovals drawing 5 4 See also Objects Overlapping document windows 3 3 images 6 2 objects 5 15 6 2 P Page view 2 16 3 11 Pages adding to draw documents 5 18 breaking in documents database 8 36 spreadsheet 7 19 word processing 4 21 counting 4 31 displaying in word processing documents 4 22 going to 3 4 margins and guides for showing hiding 3 11 3 16 master 5 17 numbering 3 15 orientation and size of 2 16 3 16 title 3 14 4 19 viewing in page view 3 11 Paint bucket 6 5 Paint documents See also Paint frames book marks in 6 14 creating 6 2 described 1 11 6 3 linked frames in 9 26 links to different or same document 6 14 memory for 6 14 painting in 6 4 pictures in 6 13 preferences for 3 20
30. A P sa st e E eae hae S Sele s documents and frames Working area with graphics grid al H What are obj In the Help index see gt objects creating Text frame hidden border and transparent fill Gale 0 ma ects A drawing is made of objects separate elements such as rectangles lines and text as well as paint and spreadsheet frames Think of a drawing as a collage in which you create and arrange objects of various shapes sizes and colors When you overlap objects the hidden parts still exist Every object has a border which you can hide and a fill the area within the border Another type of object is a frame Most of what you can do with an object you can do with a frame as well Border Using the drawing tools In the Help index see gt drawing tools gt selecting objects You use the tools in the tool panel to create select move resize and reshape objects If you don t see the tool panel start by choosing Show Tools from the Window menu K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 5 4 AppleWorks 5 User s Manual You use the first four tools in the tool panel to work with frames and objects For more information see Working with frames on page 3 9 Use the remaining tools in the tool panel to create and change different
31. AppleWorks is New command running choose Newfrom the File menu Or click the appropriate button in the Default button bar If you don t see the button bar choose Show Button Bar from the Window menu If you selected New from the File menu you see the New Document dialog box CP Grade Her Dresi Select a document type ries oe rasik a rebi ee pee de m When you create a document you see the window for the selected document type K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Creating opening and printing documents 2 3 Document name which you The order in which the can change document was created FS AppleWorks 5 untitled 3 CWK WP File Edit Format Font Size Style Putine Window Help l x 5 8 2 8 a Sl 5 09 eel 8 S GI GI gt Bl Z Ul ae al Document type 5 8 Al Al 7 ll e amp WP for Word Processing ee DR for Draw Ea eee eae 6 7 EBET PT for Paint amp z SS for Spreadsheet DB for Database CM for Communications 100 Jahd E Pace 1 q The margins page numbering and display are set up for each type of document You can change these settings by choosing Document from the Format menu Using an Assistant Use an Assistant to lead you step by step in creating specific documents In the Help index see such as a document for a
32. Default Footer If yov re editing an outline or table spreadsheet style select each substyle you want to edit before choosing any commands or clicking controls File Edit Click a triangle to 7 Outine Stylea a display substyles gt Diamond Base Style None Text Font Arial 4 ane Ls ee ach Properties of the 3D v Table Stes Cell Alignment Center Table 1 style Select a style to edit gt 3D Tabe 1 gt 3D Tabk 2 b Accounting gt Blue Gray 1 gt Blue Gray 2 gt Classic gt Coborful AR BR BA BB BB BBR GS ii ii iii When you re finished editing the style click Done Note If you click in the document or select a non formatting menu command such as Print in the File menu you can no longer edit the style If this happens click the Edit button on the stylesheet palette To change the name of a style or to change the style on which a style is based select the style and choose Modify Style from the Edit menu on the stylesheet palette Modify Style Style name Beyond the basics 9 15 Type a name for ME your style eins Choose a style to None 4 acquire the properties Cancel of that style Copying pasting and deleting styles and properties You can duplicate and delete styles and move them between documents You can also cut or copy properties and move them to another style In the Help index see gt styles editing Note You cannot cut or delete a style that is in use
33. Do this Double click the field to modify select options and then click OK Show or hide field labels or set other options for pop up menu radio button or checkbox fields Double click the field select options and then click OK Change the appearance of text in a non text field for example to display a date in italic Select the field and choose from the Font Style Size and Text Color commands in the Format menu or use the pop up menus on the button bar Change the format of numbers dates and times Double click the number date or time field select formats and then click OK Change the appearance of a picture or QuickTime or AVI movie in a multimedia field Double click the field select options and then click OK Change text appearance or formats for several fields of a similar type Shift click the fields to change and then double click a selected field or choose from the Font Style Size Text Color Alignment and Spacing commands in the Format menu Add a color pattern gradient texture or border to any type of field Select the field s and choose a fill color pattern gradient or texture from the fill palettes and a line color width or pattern from the pen palettes on the tool panel You can t change the border width for a pop up menu Add styles to text in Browse mode Select the text and choose a style from the stylesheet palette Note To change a f
34. H Handles changing number of graphics preferences described 5 6 Hanging indent 4 10 Hard non breaking space 4 4 Header part See Parts database Headers dates and times in 3 14 in database documents 8 35 inserting 3 12 on title pages 3 14 4 19 page numbers in 3 15 removing 3 14 viewing in page view 3 11 Headings spreadsheet described 7 3 showing and hiding 7 19 Heavy bold text 4 7 Help contents 1 3 copying text from Help copying index 1 5 navigating 1 4 notes adding to 1 7 opening and closing 1 3 printing 1 5 topics marking Help customizing viewing 1 5 using with this user s guide 1 2 Windows Help application 1 3 Hidden characters See Formatting characters Hiding button bar 3 6 field labels 8 33 formatting characters 4 6 graphics grid 5 7 page guides and margins 3 11 3 16 palettes 3 4 records 8 20 tulers 3 12 spreadsheet chart or frame 7 31 columns and rows 7 17 grid 7 19 Choose Index from the Help menu and scroll to the entry Then choose a topic from the list and click Go To Topic 1 6 AppleWorks User s Guide headings 7 19 tool panel 3 4 Home Finance Assistant 2 5 Horizontal lines in HTML files 11 4 Horizontal pane control 3 2 Host computer described 10 2 HTML Hypertext Markup Language HTML HTML files See also Hypertext Markup Language HTML Internet Web pages World Wide Web adding pictures to 11 5 creating 11 4 described 11 3 design tips 11 3 edi
35. Help index see gt Web browser launching Before you can use the Internet with AppleWorks you need to select a browser to use You can change your selection at any time To select a browser 1 Choose Preferences from the Edit menu 2 In the Preferences dialog box choose Communications from the Topic pop up menu 3 Under AppleWorks Web Browser click Change To 4 Locate and select the web browser to use and then click Open Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic AppleWorks and the Internet 11 3 Connecting to the Web Once you ve selected a browser to use you can quickly connect to the Web using the selected browser To do so on the Internet button bar click el Creating a Web page In the Help index see gt Web pages creating A Web page is an HTML file on the Web With the AppleWorks translator you can easily create an HTML file without understanding HTML or how it works You simply create a word processing document and save your work as an HTML file You see immediately how your document will look on the Web Note The AppleWorks HTML translator displays a Web page in a standard format However your Web page may appear different on different browsers You can customize the format for specific browsers by clicking the HTML Configuration button and adding or modifying the tags that are exporte
36. Help menu and type the first few letters of the entry Double click the entry and then double click a topic Sorting links In the Help index see gt links Using styles In the Help index see gt styles Beyond the basics 9 5 To display book marks or links in the links palette by name alphabetically or by position from first to last as they appear in the document 1 Open the document containing the book marks and links to sort 2 Choose Show Links Palette from the Window menu 3 Choose Sort By Name or Sort By Position from the Special menu on the links palette Your selection applies to links of all types in the current document Folders always appear at the end of list of links sorted alphabetically Styles are collections of formatting information you can apply to text objects spreadsheet cells or database fields Documents often use different elements with consistent formats such as chapter headings and subheadings tables and draw objects To ensure uniformity and to save time in formatting these elements you can create custom styles that store your formatting settings Or apply the preset styles that come with the AppleWorks stylesheet palette If you change your mind about the formatting in your document you can edit styles once and have the formatting change throughout the document You can also transfer custom styles between documents DSIMOD TEOD
37. Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 11 2 AppleWorks 5 User s Manual About browsers A Web page contains formatting information which determines how the document looks and how you can use it onscreen You can use AppleWorks to create and format a Web page without knowing HTML Create a word processing document that has the information you want on your Web page and then save the document in HTML format AppleWorks adds the correct HTML tags and your Web page is ready for delivery to your Web site To access view and place a Web page on the Web you need a modem internal or external a phone line or an Integrated Services Digital Network ISDN line a browser an application that displays information from the Internet For more information see About Browsers next software from an Internet service provider such as America Online or CompuServe For more information refer to a specific provider an account or connection with the Internet service provider To open read and work with Web pages you use a browser an application that displays information from the Web in a format you can read and work with Each browser interprets HTML tags differently For example one browser may display headings in color with an elegant typeface while another may display headings in capital letters Selecting a browser In the
38. Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 4 32 AppleWorks 5 User s Manual To insert an inline or a floating object in a document first show the tool panel choose Show Tools from the Window menu if the tool panel is hidden Then To insert Do this An inline object in text Select the text tool in the tool panel and then place the insertion point in the text before you paste or insert the object A floating object to a document Select the arrow pointer in the tool panel and then paste or insert the object Once you add an object you can change how it s placed in text To change Do this A floating object to an inline object Select the arrow pointer J in the tool panel and select the floating object Choose Cut or Copy from the Edit menu and then select the text tool in the tool panel Then place the insertion point in the text and choose Paste from the Edit menu An inline object to a floating object Select the text tool in the tool panel and select the inline object Choose Cut or Copy from the Edit menu and then select the arrow pointer JJ Then choose Paste from the Edit menu Aligning inline objects To move any inline object except equations and OLE objects above or below the baseline of the text double click the object In the Descent dialog box type the number of points between 255 and 255 you want th
39. Item 7 z Uoni Create a table in a so Uniforms spreadsheet frame Sincerely George DuPont Add a drawing and a spreadsheet frame AppleWorks word processing documents give you great flexibility in the way you present what you write Using multiple columns for example you can create professional looking catalogs and reports You can write better research papers by using AppleWorks to outline your ideas and to add footnotes or endnotes that number and renumber automatically You can format documents in sections like chapters in a book each with its own header footer column configuration and page numbering See chapter 4 Text word processing for more information about what you can do with word processing documents and text frames 1 10 AppleWorks 5 User s Manual Draw documents Use a draw document for artwork and page layout A draw document includes objects such as rectangles circles and lines that you can create select move and modify If you want to add text a spreadsheet or clip art you can do so in the same document File Edit Format Arrange Options window Help 18 x 2 3 By BS ey SS 22 85 8 Bl 8 Cl Bl Bl 7 Uy 25 55 1 Draw menus and Ss 181 l 23 4 E se vs we button bar Arial vjl vlla 5 eetautt KA Main Street Drawing tools and palettes 3 Traffic Study Main Street Text frames 4 Clip a
40. To lock a In the Help index see cell or a range of cells select the cells then choose Lock Calls from the Options gt locking menu To unlock a protected cell or cell range select the cells and then choose Unlock Cells from the Options menu Naming cells and ranges You can assign a name to any cell or range of cells Naming cells can In the Help index see help you gt named cells and ranges remember the purpose of data in a particular cell or range a visually locate a named cell or range a simplify formulas by using named cells instead of cell addresses When you select a named cell op Shares vlek Shares Price Cell B5 contains the range you see its name here you formula Shares Price must select every cell in a range to instead of B3 B4 see that range s name Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Assigning names to cells To name cells choose commands from the J menu in the entry bar Sa Se In the Help index see gt named cells and ranges To Name a cell or cell range Do this Select the cells to name and choose Define Name from the menu Type a name in the dialog box and then click Define Spreadsheet 7 13 Example Al Revenue Cell A1 is l Cell A1 is named unnamed Revenue Name cells or ranges using row and column titles you ve alre
41. Tom Ipam dee AF 7 7 Ky Stylesheet x Loem imi mdobr sit woven pales ad dm menm m yrth od z Amet dbacttyer Sedat restdshre nog igna art File Edit Doer ekanlarda Sipe Pma mm ste tein a a T marias mrd Si il n aiparu Hobart inde bed en HLA Utd m andar oom mode ogue Rockness nex dln separ upitati nil utal ydp anandan v Body keiini Da whe mad i oam Bullet Dii aitem Ibra doce i eerie k mm Intulperhivoltone malarka seroequvt oa Ihan Checklist thre dice hs haibuitaiyahieiun odvi dalare au Meuvtredts halls wtoare anos at Dae seek ou Mum dolora au Feuyetredle Pell stoar vom natured sev ateoum snatturh ofl Footer Lem Ipam dhe Atinat dboerhtre Laem Ipaim doke Kassab yadest ad A m rece m yrith wda od Footnote Atma dboerbtre wound asats dm meam m y tra oath woe quae art Pith wdvmed danh weeatdolees mayne dyna cdlupat Trot see admirim bariin gt Header seatoolirpit Thetd im vim Inde bard med rink papal arenai aard hion m oop auaiptthtort ents utilyip ax kedip m sandan aa modo anatas Avan aa m ode aneaut Dud urha ouam Mure delorinhardrartt Drd wha ou am Mure dolorinbardrarttin Rept Intudperhiv oal tava moarta aoeveyunt o Ihe Saatana melartaoeromqust od lha dolora vatan t n on a Flees uae paia 2 Doire nazan Ahremn sei 373 PEN pia e Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 9 6 AppleWorks 5 User s Manual About the stylesheet palette You u
42. a different part of the painting in the frame Select the frame and choose Framelnfo from the Edit menu Type values in the Origin box and then click OK The new values become the coordinates of the upper left corner of the frame For information about linking paint frames in a document see Linking frames on page 9 24 Working with images In a paint document you use the painting tools to create images painted shapes and effects Using the painting tools The painting tools include the drawing tools and additional painting tools For information on the drawing tools see Using the drawing tools on page 5 3 The remaining tools are unique to paintings Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic S In the Help index see gt tools Painting 6 5 To select a tool on the tool panel click it Once you select a tool it stays selected until you choose another tool To use the Select the tool and Example L Brush Drag the pointer to paint strokes with the current Avrr fill color pattern or texture EA Pencil Drag the pencil to paint fine lines in the current AAN fill color la Paint bucket Click an enclosed area to fill it with the current A 5 p A fill color and pattern gradient or texture Before After a Spray can Drag the pointer to spray the current fill color pattern
43. adjacent to lasso pixels of the selected color To select more than one color area click the magic wand and drag it across multiple colors K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 6 8 AppleWorks 5 User s Manual Deleting copying and duplicating images In the Help index see gt editing images You can move a selected image with the pointer or the arrow keys on the keyboard To Move a selected image with the pointer Do this Move the pointer over the image until it becomes an arrow and then drag the image to a new location The image stays selected until you click elsewhere in the document With the autogrid off choose Turn Autogrid Off from Move a selected image vertically or horizontally one pixel at a time the Options menu press the arrow keys Move a selected image eight pixels at a time With the autogrid on choose Turn Autogrid On from the Options menu press the arrow keys Change the distance that the image moves each time you press an arrow key Choose Turn Autogrid On from the Options menu Choose Grid Size from the Options menu and then select a size You can delete copy or duplicate an entire image part of an image or several images at once Remember that you can usually reverse your most recent action by choosing Undo from the Edit menu To revert to the most recen
44. allows you to view and work with many records at once In List mode you see all the fields in your database in a columnar layout To work in List mode choose List from the Layout menu Fields are n columns Street City State Postal Equestrian Books Treetop Books You work with records in List mode much like you do in Browse mode you can enter data select hide or sort records or create new records In addition you can resize or format rows and columns and reorder the columns K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 8 18 AppleWorks 5 User s Manual Selecting rows and columns In List mode you select a row or column with a single click Select multiple rows or columns when you want to resize or reformat several at once To select Do this Example of selected area One row Click the area to the left of the 6 E first column In the Help index see gt List mode Multiple rows Drag the pointer in the area to the left of the first column Equestrian Books One column Click the column heading Customer Multiple columns Shift click adjoining columns Customer Multiple fields Drag the pointer across the Customer fields If the first field in your OVENS BOOKS selection is a pop up menu or a checkbox field press Alt as you drag No
45. and then double click a topic 9 16 AppleWorks 5 User s Manual Importing and exporting styles You can export all or some of the styles on a stylesheet palette to a separate file and import them into other documents This is useful if you want to reuse your favorite styles in other documents or establish formatting standards for everyone in your organization to use and share To import or export styles start by clicking fs on the Default button bar or choosing Show Stylesheet from the Window menu to display the stylesheet palette a rT To Do this k m po Inthe Help index ee Export styles to a file Choose Export Styles from the stylesheet palette s File menu In the gt styles using dialog box click the styles to export and then click OK Type a name select a location for the export file and then click Save Import files that were Choose Import Styles from the stylesheet palette s File menu Select a saved to disk file containing exported style information and then click Open In the dialog box click the styles to import select or deselect Replace all styles with the same name and then click OK If a style you selected has the same name as a style in the current document you see a dialog box Type a new name for the style and then click Rename To replace the style on the palette with the imported style click Replace If you don t want to import that style click Skip Creating a slide presenta
46. arrow pointer 3 4 3 9 drawing 5 4 frame paint spreadsheet text 3 9 names of 1 7 painting 6 4 panels described 3 4 selecting drawing 5 3 for repeated use 5 5 frame 3 9 painting 6 5 selection rectangle paint 6 7 showing and hiding 3 4 Topics in outlines 4 13 Trailing grand summary See Parts database Transforming images 6 9 6 11 Translators using to save files 2 15 Transparent charts 7 32 fill 5 3 objects and frames 5 6 5 10 5 19 Transposing columns and rows 7 7 Troubleshooting troubleshooting Turning off styles 9 11 Typing in database fields 8 12 draw documents 5 19 paint documents 6 12 spreadsheets 7 5 U Underlined text 4 7 Undoing changes 3 10 Ungrouping objects 5 15 Uniform Resource Locator URL See also Links Linking documents creating links to 11 5 using in draw documents 5 21 paint documents 6 14 spreadsheet documents 7 34 word processing documents 4 34 Unit of measure changing for line and paragraph spacing 4 12 rulers 3 12 Unlocking and locking See Locking and unlocking Unprotecting spreadsheet cells 7 6 7 12 Unsmoothing objects 5 13 U RL See Uniform Resource Locator URL User dictionaries 4 29 v v5 0 version suffix on filenames 3 21 Values as lists in databases 8 8 in functions 7 27 7 28 Vertical pane control 3 2 Video for Windows See Movies Viewing documents as printed 2 16 fields 8 13 linked frames 9 26 pixels 6 9 recor
47. as Shares or Price with cell addresses such as A5 or B1 B3 in a formula To do so choose Replace Names from the menu in the entry bar To replace cell addresses with named cells or ranges in a formula choose Replace References from the menu in the entry bar To Do this Replace named cells with Select the cell or range that holds the formula you want to work cell addresses in formulas with Choose Replace Names from the menu in the entry bar Deselect the names you want to exclude from replacement with cell addresses and click Replace Replace cell addresses with Select the cell or range that holds the formula you want to work named cells or ranges in with Choose Replace References from the M menu in the entry formulas bar Then deselect the cell addresses that you want to exclude from replacement with named cells or ranges and click Replace Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Spreadsheet 7 15 Example 1 Using cell names in a formula This example shows you how to name two cells and use the names in a formula 1 Open anew blank spreadsheet document and then type Income Expenses and Profit incells Al A2 and A3 respectively 2 Format column B for currency vieii Select the entire column click on the Default button bar or choose Number from the Format menu select Currency and then cli
48. can reuse in a document Libraries are useful if you want to store copies of items you ve created A library can contain draw objects spreadsheet cells text paint images movies and frames You can add clip art commercially produced graphics to a library or you can add items you create yourself Tip AppleWorks includes several libraries with ready made objects If the libraries are installed on your hard drive you can find them in the AppleWorks Libraries folder in the AppleWorks 5 folder Busimage cwl Click to close the library File Edit View Scroll to see more items Click to see fewer options f Add _ Use f Rename Find Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 3 18 AppleWorks 5 User s Manual Creating opening and saving libraries In the Help index see gt libraries creating gt libraries opening Close Save As You create and open libraries as you do other AppleWorks documents To From the File menu choose Create a library Library and then choose New AppleWorks opens a new library and names it Library followed by a number Open a library Library and then choose a library from the submenu If you don t see the library you want choose Open and then locate the AppleWorks Libraries folder in the AppleWorks 5 Folder Select a library and click Open To
49. database You can use data from an existing AppleWorks database document or create a new database document Keep the following in mind In the Help index see databases documents gt found set gt sorting database data K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Beyond thebasics 9 21 Determine how the data will appear in the merge document and define the database fields accordingly For example to create a form letter with a salutation that includes a person s first name create separate fields for the first and last name Use a find request before merging to include only certain database records You may also want to sort the records before merging them AppleWorks prints only the found records in the order they were sorted Preparing the merge document To prepare the merge document open the AppleWorks document you want In the Help index see to merge the data into Then choose Mail Merge from the File menu select the gt mail merge AppleWorks database document that contains the data you want to insert and click Open Note If you are merging data into a draw document you must merge the data into a text or spreadsheet frame within that document In the merge document position the insertion point where you want to insert the data from the database field In the mail merge palette select field names
50. entry and then double click a topic Database 8 25 As you work with find requests keep the following tips in mind You can save and reuse a find request by creating a named search For more information see Saving a find request named search next Pop up menus radio buttons or checkbox fields are initially excluded from a find request If you select a value for a find request and then change your mind you can still exclude the value To exclude a Pop up menu Do this in the find request Choose Don t Care Radio button Click the radio button again Checkbox field Click the checkbox until you see a hyphen When you sort search for or hide records AppleWorks renumbers the set of displayed records beginning with 1 for the first record in the current set To display all records in the database click on the Default button bar or choose Show All Records from the Organize menu Saving a find request named search You can save a find request by creating a named search Once you create a named search you can use it whenever you want to find records You can also rename modify or delete named searches In the Help index see gt named searches me ec Edit Searches DALE Western Region California Selecting a named search To Create a named search From the Search A pop up menu choose New Search Type a name for the search criteria and then cli
51. few letters of the entry Double click the entry and then double click a topic 3 12 AppleWorks 5 User s Manual ES ERREREREREERRERREREE Normal view z a EERE Using rulers The text ruler and graphics ruler help you measure and align text objects and frames You can show one ruler at a time To show or hide a ruler choose Show Rulers or Hide Rulers from the Window menu To change the ruler settings choose Rulers from the Format menu and then select the settings you want in the Rulers dialog box In the Help index see gt rulers Rulers 21x m Ruler Type Units C Text Inches Milimeters Change between text a x and oraphics rulers Graphics C Picas Centimeters Select the unit of measure Points Cancel Divisions R Specify the number of divisions per unit For more information about rulers see Changing paragraph formats on page 4 8 and Using the graphics ruler and grids on page 5 7 Creating headers and footers You can have a document display the same information at the top or bottom of every page in a header or footer To create a header or footer choose Insert Header or Insert Footer from the Format menu In the Help index see gt headers amp Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic
52. frame as an object click once Handles indicate that the frame is selected Lorem ipsum dolor sit amet consectetuer ad laoreet dolore magna aliquam erat volutpat E SEE ullamco Lorem ipsum dolor sit amet consecte tuer adipiscing eli Duis aut laoreet dolore magna aliquam erat volutpat Ut wisi eni a suscipit facilisi Lorem ipsum dolor sit amet consectetuer adipi Duis autem vel eum iriure dolor in hendrerit To work in the rest of the document click twice outside the frame Here are some ways to adapt a spreadsheet frame to suit your needs Do this Select the frame and then drag a handle To a a In the Help index see Resize a spreadsheet frame gt frames formatting Open the frame to see more gt frames working in of the spreadsheet Select the frame and then choose Open Frame from the Window menu When you open the frame you see the spreadsheet in a new window The open frame is linked to the original document Any changes you make in the open frame are also made in the document Open a frame that s inline in text Select the spreadsheet tool choose Show Tools from the Window menu if it isn t visible click in the frame to select a cell and then choose Open Frame from the Window menu Change the number of rows and columns in the spreadsheet frame Close an open frame Select the frame and then choose Open Frame from the Window menu Choose Document from the Format menu
53. from the Edit menu and then choose Thesaurus You see the Thesaurus dialog box Word Finder Thesaurus x uncertainty sxs concern doubt dubiety incertitude indecision mistrust query question a skepticism suspicion wonder Select the synonym you want Find uncertainty lestord Cancel Replace Click to replace the selected word Click to see a list of all words you ve looked up recently Shows the selected word or type F a different word to look up f you type a different word click to see alist of synonyms X Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Text word processing 4 31 Changing dictionaries In the Help index see gt dictionaries To install and select additional dictionary hyphenation and thesaurus files choose Writing Tools from the Edit menu and then choose Sdect Dictionaries You can also create and select different user dictionaries for specialized terms or proper nouns that don t appear in the main dictionary For more instructions on changing dictionaries see onscreen Help Counting words In the Help index see gt counting words You can count words paragraphs and other text elements in any type of document except communications To count words choose Writing Tools from the Edit menu and then choose Word Count A dialog box appears that displ
54. from the Options menu Changing the display To change how AppleWorks displays the cell grid row and column In the Help index see headings formulas and circular references choose Display from the Options gt Display command menu Select or deselect options in the Display dialog box and click OK K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 7 20 AppleWorks 5 User s Manual Note If the spreadsheet is in a frame you must first open the frame before changing the display To open the frame select the frame and choose Open Frame from the Options menu See Working with spreadsheet frames on page 7 4 This option Displays Call Grid Dotted gridlines that separate the rows and columns Solid Lines The cell grid with solid gridlines Call Grid must be selected Formulas Formulas rather than computed values in cells that contain formulas Column Headings Column and row headings Row Headings Mark Circular References Dots in cells that contain circular cell references Formulas must be deselected Printing a spreadsheet document You can control various aspects of how your spreadsheet document prints To print Choose EEE es In the Help index see Row and column titles on every page Lock Title Position from the Options menu gt printing spreadsheets The range of cells that you Set Print Range fr
55. ha menu in the entry bar For more information see Naming cells and ranges on page 7 12 AppleWorks provides many ways to modify and correct your data Note You can t edit delete or move data in locked cells To unlock cells select the cells and then choose Unlock Cells from the Options menu Edit data in the entry bar or use AppleWorks commands to check spelling or find and change cell data To Edit the data in a cell Do this Select the cell In the entry bar make your changes and then click M to confirm the entry Move the insertion point right or left in the entry bar Click where you want the insertion point to be Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Moving data aS ae Se Se In the Help index see gt entering spreadsheet data gt transposing rows and columns Spreadsheet 7 7 To Do this Check spelling Choose Writing Tools from the Edit menu and then choose Check Document Spelling Find and change cell data Choose Find Change from the Edit menu and then choose Find Change Type in the Find what and Change to boxes and then click Find Next or Change All Find data that matches a Select a cell or text choose Find Change from the Edit menu and selection then choose Find Selection Note When the insertion point is active in the entry bar the arrow keys move the inserti
56. i Ole es lz Paint image aja Sja Painting tools and palettes a AE ale Rose Text frame om Bu JE EE oo a Apicture in a paint document See chapter 6 Painting for more information about what you can do with paint documents and paint frames Spreadsheet documents Use a spreadsheet document to organize numeric information make calculations and create professional looking reports You can also use a spreadsheet for any type of information such as a schedule that you want to present in a columnar format You can add a headline or pictures or turn the numbers into charts to aid comprehension right in the spreadsheet document 1 12 AppleWorks 5 User s Manual File Edit Format sT ze jindow la x s 2 21 3 G e2 B Z ul al TE a la a af Le bal E Spreadsheet menus and button bar Entry bar Add data to a spreadsheet Chart document October November December Create z a chart to add clarity or show data in n perspective See chapter 7 Spreadsheet for information about what you can do with spreadsheet documents and spreadsheet frames Database documents Database documents are useful for managing and organizing collections of information such as address lists student or customer records or research notes In a data
57. items 3 19 Viewing library items 3 19 Setting preferences 3 20 Chapter 4 Text word processing When to use a word processing document 4 1 Text basics 4 2 Creating a word processing document or frame 4 2 About the word processing window 4 2 Working with text frames 4 3 Typing text 4 4 Typing equations 4 5 Selecting text 4 5 Cutting copying and pasting text 4 6 Showing formatting characters 4 6 Changing text appearance 4 7 Changing paragraph formats 4 8 Setting and changing tabs 4 10 Indenting paragraphs 4 10 Adding bullets numbers and checkboxes to paragraphs 4 11 Aligning paragraph text 4 12 Changing line and paragraph spacing 4 12 Copying text ruler settings 4 13 Sorting paragraphs 4 13 Outlining 4 13 Creating an outline 4 14 Modifying and removing outline labels 4 15 Rearranging outline topics 4 16 Collapsing and expanding outline topics 4 16 Modifying an outline style 4 17 Creating tables 4 18 Working with pages 4 19 VI AppleWorks 5 User s Manual Creating a title page 4 19 Creating and changing columns 4 20 Breaking a page or column 4 21 Scrolling pages 4 22 Dividing a document into sections 4 22 Inserting and deleting a section 4 23 Formatting sections 4 23 Varying the number of columns on a page 4 25 Numbering sections 4 25 Adding footnotes and endnotes 4 26 Finding and changing text 4 27 Finding special characters 4 28 Using writing tools 4 28 Checking your spelling 4 29 Hyphenating words 4 30 Finding
58. links For example create a link from statistics in a financial report to the original data in a spreadsheet When other people view your report onscreen they can also see how you obtained your results by clicking the link to open the spreadsheet Note The following steps describe how to create a link from one document to another or to another area in the same document To create a link to a URL see Linking Web pages on page 11 5 Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Editing links Sa ae In the Help index see gt links Beyond the basics 9 3 The pointer changes to when you move it over a link If the link is text the text appears underlined Tip To create a document link quickly select the text a spreadsheet cell paint image frame or object Then click S on the Default button bar Type a name for the document link select a document and click OK Select the text object cell paint image or frame to create the link from Choose Show Links Palette from the Window menu Choose Document Links from the pop up menu on the links palette Choose New Document Link from the Links menu In the New Document Link dialog box type a name for the link and then choose the destination a Aa O N 6 To link to an area in a different document click Choose Document select the document and then c
59. merge See Merging data into documents mail merge on page 9 19 Linking frames You can link a series of text paint or spreadsheet frames to break up In the Help index see information that s normally confined to one area of a document You can gt layering information then move and resize frames to control the layout of your document gt frames linking Ut wisi enim 129252 166566 34467 44091 fma hoo 2350 p8 f Link text frames for Link paint or spreadsheet complex page layouts frames to show parts of a painting or spreadsheet x Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Beyond the basics 9 25 When you create linked frames you see indicators that provide information about the frames A continue indicator shows that a frame is not yet linked to another frame A link indicator shows that the frame is linked to another frame Anything you type paste or paint into the first frame continues into the next frame A text overflow indicator shows that the frame contents extend beyond the last frame Top of frame indicator Je utem Vel lit esse molestie consequat vel laoreet dolore magna aliquam illum dolore eu feugiat nulla rat volutpat Ut wisi enim ad inim veniam quis nostrud exerci ation ullamcorper suscipit lobortis is ut aliquip ex easden commodo facilisis at vero eros et accum
60. mode rows and columns in List mode and text in text fields in Browse mode Paragraph Formats fields in Layout mode Applying a style To apply a style using the pop up menu place the insertion point In the Help index see in a paragraph or select several paragraphs and choose a style If you don t gt styles using see the pop up menu choose Show Button Bar from the Window menu If you select a style before typing the next text you type uses the selected style Bullet X v Bullet Checklist Default Footer Footnote Styles on the stylesheet Header Number pop up menu Diamond Harvard Legal amp Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Beyond the basics 9 9 To apply a style using the stylesheet palette click on the Default button bar or choose Show Stylesheet from the Window menu Click in a paragraph or select the item that you want to apply the style to and then select a style If nothing is selected when you click a style name the style you select is used for the next text you type object you draw or spreadsheet element you modify Stylesheet x Fie Edit Footnote Index Body Bullet Checklist Default Footer Footnote Header Selected paragraphs V Number Diamond 3 ESTP eet ncidunt ut laoreet dolore pe A 9 A A A A 8 Click to apply the Number style To res
61. page or column f break character where you inserted the break For more information about preferences see Setting preferences on page 3 20 K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 4 22 AppleWorks 5 User s Manual Tip To show or hide formatting characters quickly click 4 on the Default button bar or type Ctrl semicolon To remove a break click at the beginning of the line that follows the break and press Backspace Scrolling pages In the Help index see gt pages guides In a multiple page word processing document you can scroll pages from side to side or one page on top of the next To change how the pages scroll choose Document from the Format menu In the Document dialog box select One Page Above The Next or Facing Pages Side By Side and then click OK Dividing a document into sections In the Help index see gt sections In AppleWorks sections in documents act like chapters in books each section can have a different format You can change its header and footer text page numbering and number of columns You can also place a special title page with no header or footer at the start of a section see Creating a title page on page 4 19 You can also divide a single page into multiple sections each with different formatting amp Choose Index from the Help me
62. print and onscreen that you received with your computer When you re ready to learn about AppleWorks start by running the onscreen tour Introduction to AppleWorks For instructions on starting AppleWorks and running the onscreen tour see How to start on page 1 1 The tour is an easy way to see what AppleWorks can do for you What s a document Document types You use the AppleWorks application to create documents A document is a computer file in which you enter information You can create open change save print delete and duplicate documents When saved a document appears as an icon in a folder When you create a document it appears in its own window with the tools needed for that document type When a document is open you see its contents such as a letter or a drawing displayed in the window When printed a document looks just as it does on the screen You can create six different types of documents with AppleWorks word processing drawing painting spreadsheet database and communications As you look at the document windows on the following pages notice that each document type has its own menus and tools While each type of document is mainly for a certain type of work such as writing a letter or drawing a picture you can use AppleWorks to combine different kinds of work within a single document by using a frame a view of one document within a different type of document For example you can add
63. relative reference to another cell AppleWorks changes the reference to reflect the relative position from the new source cell An absolute reference stays the same when you copy and paste a formula To enter an absolute cell reference type a dollar sign before each part of the cell address You can also mix absolute and relative addresses in the same formula for example A 1 B 1 Relative reference Absolute reference The formula in cell A3 is A1 A2 If The formula in cell A3 is A 1 A 2 you copy the data in cell A3 to B3 If you copy the data in cell A3 to B3 the the formula becomes B1 B2 formula is still A 1 A 2 Circular references Avoid circular references in a spreadsheet A circular reference occurs when two or more cells refer to each other for example when cell Al contains B2 3 and cell B2 contains A1 4 A circular reference also occurs when a cell refers to itself for example in the formula AI10 SUM A1 A10 AppleWorks marks cells that contain circular references with bullets To turn off the markings choose Display from the Options menu and then deselect Mark circular refs X Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Spreadsheet 7 23 Entering formulas In the Help index see gt arithmetic operators gt spreadsheets calculations You can type each of the formula elements or have App
64. searches 8 25 Finding formatting characters 4 28 library items 3 19 records and matching 8 23 8 27 synonyms 4 30 text and changing 4 27 in onscreen Help Help searching Flipping images 6 10 objects 5 15 Fonts attributes changing 4 7 changing in databases 8 19 8 33 outlines 4 17 spreadsheets 7 10 text 4 7 text frames 4 6 5 19 default changing 3 21 displaying in menu 3 21 in paintings 6 12 Footer part See Parts database Footers dates and times in 3 14 in database documents 8 35 inserting 3 12 on title pages 3 14 4 19 page numbers in 3 15 previewing 3 11 removing 3 14 Footnotes deleting 4 27 inserting at end of document 4 26 inserting at end of page 4 26 inserting using Assistant 2 5 4 26 Formats copying cell 7 10 paragraph 4 13 saving stationery 2 11 Formatting AVI movies database fields in 8 33 cell data 7 9 dates times and numbers in Choose Index from the Help menu and scroll to the entry Then choose a topic from the list and click Go To Topic databases 8 19 8 33 documents 7 21 8 8 spreadsheets 7 10 outlines 4 16 4 17 paragraphs 4 8 4 13 pictures in database fields 8 33 QuickTime movies database fields in 8 33 rows and columns in databases 8 19 spreadsheets 7 18 7 19 sections 4 23 text characters 4 7 databases in 8 19 8 33 drawings in 5 19 paintings in 6 12 spreadsheets in 7 10 text frames in 5 19 with custom styles 9 5 Formatting characters describ
65. step 4 6 Choose Number from the pop up menu Place the insertion point at the end of the third numbered item and then press Enter twice 8 Choose Body from the aay z pop up menu For the last line type We 11 see you at the campsite next weekend Your letter should look like this Camping Supplies Be sure to bring these things on our camping trip 1 Tent 2 Compass 3 Sleeping bags We ll see you atthe campsite next weekend K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 9 12 AppleWorks 5 User s Manual Part 2 Add a basic style to the stylesheet palette 1 Click 3s on the Default button bar or choose Show Stylesheet from the Window menu Click the New button on the stylesheet palette wo N In the New Style dialog box type Bold Italic in the Style name box gt Set the following options in the New Style dialog box Select Basic for Style type Choose None from the Based on pop up menu Deselect Inherit document selection format if it is selected 5 Click OK 6 Click B on the Default button bar or choose Bold from the Style menu 7 8 File Edit Click Z on the Default button bar or choose Italic from the Style menu Click Done on the stylesheet palette Footnote Index Body 4 The new basic style is added to the stylesheet palette Part 3 Add a paragraph
66. steps 5 and 6 for any other levels you want to change 8 When you finish click Done on the stylesheet palette amp Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 4 18 AppleWorks 5 User s Manual Creating tables There are several ways to create a table in AppleWorks word processing In the Help index see documents You can gt Assistants use the text ruler to set a tab for each column after you enter the text you r a tool can convert the tabbed table to a spreadsheet frame using a shortcut gt tables draw a spreadsheet frame that contains the number of rows and columns you want and then enter the text use the AppleWorks Assistant for making tables which sets up a spreadsheet frame for you Tab stops Lorem si amet ipsum hhh S amat rene adipiscing sed dem aliquam eeee net eee ae ae eulsrnod lacreet magna eulsmod lacreet magna Tabbed table Table in a spreadsheet frame Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Text word processing 4 19 Use any of the following methods to make a table To make a table Do this By setting tabs Use the pointer to drag tab stops to the text ruler See Setting and changing tabs on page 4 10 To convert the tabbed table to a spreadsheet frame select th
67. synonyms 4 30 Changing dictionaries 4 31 Counting words 4 31 Adding pictures and frames to text 4 31 Wrapping text around pictures 4 32 Creating links in word processing documents 4 34 Chapter 5 Drawing When to use a drawing 5 1 Drawing basics 5 2 Creating a drawing 5 2 About the draw window 5 2 What are objects 5 3 Using the drawing tools 5 3 Selecting and deselecting objects 5 6 Using the graphics ruler and grids 5 7 Moving objects 5 7 Duplicating copying and deleting objects 5 8 Changing the appearance of objects 5 9 Changing lines borders colors patterns and textures 5 9 Copying an object s attributes Resizing objects Reshaping and smoothing objects Connecting objects Arranging objects Locking objects to prevent changes Creating a master page Adding pages to a draw document Creating custom colors patterns gradients and textures Adding clip art Adding text spreadsheet or paint frames Creating links in draw documents Chapter 6 Painting When to use a painting Painting basics Creating a painting About the paint window Working with paint frames Working with images Using the painting tools Setting lines colors patterns and textures Selecting and moving images Deleting copying and duplicating images Magnifying an image Transforming a selection Reshaping a selection Resizing or turning a selection Coloring and tinting images Replacing images Adding text and spreadsheets Adding clip art Customiz
68. the database as needed For more information about using Assistants see Using an Assistant on page 2 3 Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Database 8 7 Defining database fields Once you plan the design of a database the next step is to define the fields to store the data When you define a field you give it a name and then select a field type to determine what kind of data for example numbers or a date can be stored in the field When you open a new database document you see the Define Database Fields dialog box where you set up database fields In the Help index see gt fields defining Define Database Fields 2 xi Field Name Field Type Invoice Date Invoice Number Field names and field Book Tite Author types appear in a list Number Number Qty Sold Price Field Name Oty Sold Field Type Number x Select a field type Delete Click to set up entry options for a field Type a field name reate Select a field and click Options to change attributes or change the name or Done field type and then click Modify Note You can also change the appearance of text and the format of numbers dates and times for existing fields For more information see Changing the appearance of data on page 8 372 Adding fields to an existing database To add fields to an exist
69. the entry and then double click a topic 7 8 AppleWorks 5 User s Manual Copying and deleting data In the Help index see gt entering spreadsheet data Copy and delete procedures are the same throughout AppleWorks The AppleWorks spreadsheet also provides other methods to copy and delete data To Do this Copy or cut cell contents Select the cells you want to work with Then on the Default and formatting button bar click to copy or to cut or choose Copy or Cut from the Edit menu You can also copy cell contents by pressing Alt and dragging the cells to a new location on the spreadsheet Copy only the value of a Select the source cell or cell range click on the Default cell that contains a formula button bar or choose Copy from the Edit menu and then select the target cell or range Choose Paste Special from the Edit menu select Paste Values Only in the Paste Special dialog box and then click OK Paste cut or copied data Select the cell or cell range where you want the data to go and then click on the Default button bar to paste or choose Paste from the Edit menu Delete the cell contents Select the cells and choose Clear from the Edit menu and formatting Delete the cell contents and Select the cells and press the Delete key retain the cell formatting Important When you cut or copy cells that are part of an absolute reference in a formula be sure to cut or copy the entire range of ce
70. the footnote reference and choose Insert Footnote from the Format menu You can later change a footnote to an endnote in the Document dialog box explained in the table on the next page AppleWorks assigns the footnote an incremental number and creates space at the end of the page or document for the footnote or endnote text As you type the footnote text the document text adjusts to accommodate the length of the footnote When you re finished typing the footnote text click the main text area or press Enter on the numeric keypad USIMOD Loem ipsum dolor sit amet cibsectetyer aduouscubg ekut sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat Ut wisi enim ad minim beniam quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex easden commodo cosequat Duis autem vel eum iriure dolor in hendrerit in bulputate velit esse molestie consequat vel illum dolore eu feugiat nulla facilsis at vero eros et post et accumsan et iusto odio 2 nis ot ie dolor i at ete se pem v ese moleste aye jese sa eles fe in nent pum js a Loem ipsum dolor sit amet cibsectetyer pawl aduouscubg ekut sed diam nonummy nibh euismod olor ius tincidunt ut laoreet dolore magna aliquam erat a volutpat Ut wisi enim ad minim beniam quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex easden commodo cosequat 3 cine cs si nonumm on erat ipa dolot Si gjar DOn am el ros etr
71. word processing document Create a word processing document when you want to write and format text For example you can use an AppleWorks word processing document to compose letters and memos create lists and outlines keep a personal journal write research papers lesson or business plans reports contracts and meeting minutes write copy for newsletters announcements brochures and advertisements 15 March 1997 45 S Webster Avenue Santa Fe NM 87155 Tyrone Damon 872 Newton Road Lakewood CO 54321 Lorem ipsum Lorem ipsum dolor sit amet consectetuer adipiscing elit sed diam nonn y nibs e vismod tincidunt ut laoreet dolore magna aliquam erat volupap Ut wisi enum ad minim veniam quis nostrud exercitation ullam corper suscipit Adipiscing Laura Epson Create a word processing document to contain text 4 2 AppleWorks 5 User s Manual Text basics You can work with text in a word processing document or in a text frame In either case you use the same techniques tools and commands to enter and format the text Creating a word processing document or frame To Do this Example In the Help in dex see Create a blank Choose New from the File s Ee Edt Fount Foy Sew Sye Osie Widow word processing menu click Word Processing and gt frames creating document then click OK opening Or click on the Default button bar If you don t see the b
72. 0 X Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Text word processing 4 7 gt AEL 1 2 EF MAA fo 2 3 4 Space character gt 12 Avril 1 998 va Mme Brigitte DURAND Return character 34 Rue St Sauveured 75009 PARIS4 France Tab character Note Formatting characters never appear in the printed document Changing text appearance You can change the appearance of text in your document by applying In the Help index see different fonts type sizes and colors To change the appearance of gt modifying text characters you can apply various text attributes using commands in the word processing menus or button bar If you don t see the button bar choose Show Button Bar from the Window menu To change Select the text or frame and choose The font A font from the pop up menu on the button bar or from the Font menu The size A point size from the pop up menu on the button bar or from the Size menu The attribute such as bold italic An attribute from the pop up menu on the button underline subscript superscript bar or from the Style menu superior or inferior The color A color from the pop up menu on the button bar The style A style from the 8edy z pop up menu on the button bar amp Choose Index from the Help menu and type the first few letters of the entry
73. 1 10 2 10 2 10 3 10 3 10 4 11 1 11 2 11 2 11 3 11 3 11 3 11 4 11 5 11 5 11 9 11 9 11 10 Chapter 1 Introduction This User s Manual introduces you to the AppleWorks 5 application from Apple Computer Inc AppleWorks is an all in one software package offering seamless integration of word processing outlining presentations drawing painting spreadsheet computation and charting database management and communications including support for HTML and linking to the Internet Registration and customer support How to start Please take the time to mail the product registration card included with AppleWorks or register your copy of AppleWorks at the following Web site http www applereg com For information about customer support see the Apple Service Directory included with your copy of AppleWorks or see the following Web site http support info apple com support supportoptions supportoptions html For information about AppleWorks see the following Web site http www apple com appleworks This User s Manual is designed to get you started quickly whether you re a new or experienced AppleWorks user If Do this You re new to AppleWorks Become familiar with Windows 95 techniques such as using or want a complete the mouse and saving documents For such information see the understanding of documentation that comes with your computer AppleWorks View the onscreen tour Introduction to AppleWo
74. 1 8 39 objects 5 15 text 4 6 4 12 text in text frames 4 6 5 19 Alphabetizing library items 3 19 AppleArt See Libraries AppleWorks 2 1 3 3 AppleWorks stationery See Stationery AppleWorks Web site address 1 1 Applying styles 9 8 9 11 9 12 Arcs See also Objects reshaping 5 13 6 5 tool for drawing 5 4 Arrow keys preferences for 3 21 Arrow pointer 3 4 3 9 Arrowheads adding to lines 5 10 6 6 copying settings for 5 11 Art See Clip art Pictures Assistants Address List 8 6 Create Labels 8 30 described 1 7 2 3 Envelope 9 23 Insert Footnote 4 26 Paragraph Sorter 4 13 Table Maker 4 19 Attributes changing for text 4 7 Auto Cale 7 24 Autogrid 5 7 5 15 6 8 AVERAGE function example 7 27 Avery labels See Labels Axes 7 29 7 30 7 32 Backup copy 2 8 Bar charts changing 7 32 Basic styles 9 6 9 12 Bezigons 5 4 5 13 See also Objects Blank documents creating 2 1 Blending image colors 6 11 Body part See Parts database Bold text 4 7 Book marks creating 9 2 deleting 9 4 editing 9 3 going to in document 9 4 HTML files in 11 8 sorting names 9 5 using in draw documents 5 21 paint documents 6 14 spreadsheet documents 7 34 word processing documents 4 34 Web pages in 11 8 Bookmarks in Help Help customizing Borders cell 7 18 chart 7 32 field 8 33 image 6 6 object and frame 5 3 5 10 Browse mode database 8 2 8 12 Browsers described 11 2 selecting 11 2 starting 11 3 Bru
75. 1 7 4 To test the link choose Show Links Palette from the Window menu and make sure Live Links is selected In an HTML file the area linked to a URL appears underlined in the AppleWorks document and the pointer changes appearance over the underlined area To view the linked URL click the underlined area Espresso Cafe The pointer looks like this over a link Click the underlined area to go to the linked information A link can jump to a document called a document link or to a specific location within a document called a book mark If you create a document link clicking the link opens the document If you create a book mark clicking the link opens the document and locates the book mark within the document To create a link to another document 1 Open the Web page document from which to create the link and then select the item to create the link from 2 On the Internet or Default button bar click W to create a link to another document 3 In the New Document Link dialog box create a link and then click OK New Document Link Type aname for the link Name Document Coffee Bean Roasting cwk Book Mark None x Choose Document Cancel_ Select the document to link to 4 To test the link choose Show Links Palette from the Window menu and make sure Live Links is selected 11 8 AppleWorks 5 User s Manual To create a link to another part of your Web page 1 N oo g
76. 2 3 Use automated assistance in performing complex tasks such as adding footnotes or tables to a document Choose AppleWorks Assistants from the AppleWorks Help menu Use Tool Help to see the names of AppleWorks tools controls and buttons when they re displayed Hold the pointer over the item for a few seconds For tools controls and buttons you see a pop up label See brief descriptions of AppleWorks menu commands tools controls and buttons when they re displayed Hold the pointer over the item for a few seconds You see information about the item in the status bar at the bottom of the window Tip To show or hide Tool Tips or the status bar choose Preferences from the Edit menu In the Preferences dialog box choose Genera from the Topic pop up menu and then select or deselect Tool Tips or Show Status Bar Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 1 8 AppleWorks 5 User s Manual Working with AppleWorks With the AppleWorks application you can do all the jobs you perform most often on a personal computer word processing outlining drawing and painting presentations spreadsheet computation and charting database management and telecommunications The rest of this chapter describes the different types of work you can do with AppleWorks First go through the introductory material both in
77. 23 60 98 10 A header part repeats information above the data on every page of a layout in a database document You can place text or pictures here Asub summary part contains one or more summary fields that summarize data in a group of sorted records It appears only when records are sorted by the field it summarizes in this example records are sorted by the Name field You can place a sub summary part above or below the data it Keep the following points in mind summarizes A footer part repeats information below the data on every page of a layout in a database document You can place text or pictures in a footer part A header or footer part differs from a page header or footer A page header or footer is text or pictures that appears at the top or bottom of a page in any AppleWorks document except communications It appears on every page of a document unless you create a title page in a word processing document using the Section command A header or footer part appears on every page of a database document To add a page header or footer to a database document in Browse or List mode choose Insert Header or Insert Footer from the Format menu These commands aren t available in Layout mode 8 36 AppleWorks 5 User s Manual To display or print summary data on separate pages add a page break before or after a sub summary part In Layout mode choose Insert Pat from the Layout menu In the Inse
78. 4 Size changing See Resizing Slide show options 9 18 Slides 9 16 9 19 Smart quotes 3 21 Smoothing objects 5 13 Soft return 4 4 Sorting database for mail merge 9 21 name fields 8 13 records 8 7 8 21 8 25 links 9 5 paragraphs 2 5 4 13 spreadsheet data 7 11 Spaces non breaking 4 4 Spelling See also Dictionaries Thesaurus checking 4 29 user dictionaries 4 31 Splitting windows into panes 3 2 Spray can 6 5 Spreadsheet documents See also Charts Formulas Functions Spreadsheet frames e bullets in cells 7 22 book marks in 7 34 creating 7 3 described 1 11 7 3 entering data in 7 5 errors 7 24 7 25 font default for 7 10 links to different or same document 7 34 movies in 9 26 page breaks in 7 19 pictures adding to 7 32 preferences for 3 20 3 21 printing 7 20 resizing 7 18 slides in 9 17 text frames adding to 7 32 when to use 7 1 Spreadsheet frames See also Charts Frames Spreadsheet documents changing 7 4 7 5 creating in any document 7 3 draw documents 5 20 paint documents 6 12 spreadsheet documents 7 3 word processing documents 4 19 Choose Index from the Help menu and scroll to the entry Then choose a topic from the list and click Go To Topic described 7 4 linking 9 24 opening and closing 7 4 point of origin 7 4 resizing 7 18 showing and hiding 7 31 tables as text 4 19 7 2 Spreadsheet tool 3 4 Spreadsheets and databases differences 7 2 Squares drawing 5 4 See
79. 7 7 18 7 18 7 19 7 19 7 19 7 20 7 20 Understanding formulas Cell references in formulas Entering formulas Calculating formula results Making corrections Examples Entering formulas Working with functions Entering functions Example Using the AVERAGE function Displaying data in charts graphs Making charts Changing chart options Deleting copying or moving a chart Enhancing a chart s appearance Adding pictures or a text frame Creating links in spreadsheet documents Chapter 8 Database When to use a database Database basics What s a database Using Browse List Find and Layout modes Creating a database document Example Creating a simple database Part 1 Start a new database document Part 2 Define two fields Part 3 Enter two values into the fields Part 4 Make new records Part 5 Finish entering data in the new records Part 6 Close the database Designing a database Defining database fields Adding fields to an existing database Assigning field types Checking or entering data automatically Contents 7 21 7 22 7 23 7 24 7 24 7 25 7 26 7 27 7 27 7 28 7 29 7 29 7 30 7 31 7 32 7 34 8 1 8 1 8 1 8 2 8 3 8 4 8 4 8 5 8 5 8 5 8 5 8 6 8 7 8 7 8 7 8 9 IX X AppleWorks 5 User s Manual Defining calculation and summary fields Adding changing and deleting fields Entering data in fields Adding records Changing the tab order Duplicating deleting and moving records
80. C1 cell reference address that you want to make absolute and then type a dollar sign Enter a reference to Choose the name of the cell or range from the Revenue Expenses a named cell or menu in the entry bar range 8 For more information see Naming cells and ranges on page 7 12 amp Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 7 24 AppleWorks 5 User s Manual In the Help index see gt Help printing To Do this Example Have AppleWorks Begin and end the entry with a double quotation _ 1992 interpreta number mark pP or punctuation as i text Use a function See Entering functions on page 7 27 DATE 95 10 10 ready made formula Tip If you want a paper copy of all the AppleWorks functions you can print an alphabetical summary from onscreen Help See Printing a document or Help topic on page 2 16 Calculating formula results In the Help index see gt Auto Calc command When you enter and confirm a formula AppleWorks computes the result AppleWorks is preset to calculate formulas automatically each time you confirm an entry in a cell To turn automatic calculation on or off choose Auto Calc from the Calculate menu When Auto Calc is on you see a checkmark next to the Auto Calc command Because automatic recalculation of large spreadsheets can be time consum
81. Double click the entry and then double click a topic Spreadsheet 7 19 Tip AppleWorks comes with preset table styles that you can use to change a cell s appearance and formatting in one step To apply a style or create your own see Using styles on page 9 5 Locking row and column titles To lock row and column titles in a spreadsheet document so they won t In the Help index see move as you scroll the rest of the spreadsheet select the rows or columns gt locking and choose Lock Title Position from the Options menu Choose it again when you want to unlock titles This cell was selected when tfrear wan Feb Cells in the locked area have solid borders Lock Title Position was chosen Note You can t select cells in locked titles and you can t lock titles in a spreadsheet frame Adding and removing page breaks Spreadsheet pages break automatically when the page is full In the Help index see gt pages breaks To Do this Add page breaks manually that Select the cell row or columns where you want the page occur before the automatic page to end Then choose Add Page Break from the Options breaks menu AppleWorks marks the break with a dotted line Remove a manual page break Select the cell row or column where you previously set the page break and then choose Remove Page Break from the Options menu Remove all manual page breaks Choose Remove All Breaks
82. Double click the entry and then double click a topic 4 8 AppleWorks 5 User s Manual Tip You can create styles combinations of formatting information and apply the styles to text with a single click using the stylesheet palette To gt styles show the stylesheet palette click f on the Default button bar or choose Show Stylesheet from the Window menu For example if you create a style called Bold Italic you can apply it to text any time you want When you change a style all the text with the same style also changes For information on creating and using styles see onscreen Help and Using styles on page In the Help index see 9 5 Select the text you want to change Lorem ENEE sit amet Lorem psum dolorsit amet Before After Stylesheet x File Edit File Edit Then click to apply a oki talic v Bok italic style that you ve created Footnote Index Dateuk ee Body Footnote In Properties of the Bulet 7 Paragraph style Bold Italic Checklist Body Default Bullet Footer Checklist Footnote Default To see a style s properties click Edit and then select the style Changing paragraph formats Each paragraph has a particular format indentation tab settings and line spacing The text ruler indicates the format of the current paragraph the paragraph that contains the insertion point Using the text ruler or the Paragraph dialog box you can change the format of paragraphs before or after yo
83. Function from the Edit menu or click on the entry bar o N Choose the type of function you want from the Category pop up menu in the Paste Function dialog box select a function from the alphabetical list and then click OK In the entry bar select the sample values and replace them with values named cells or cell references gt For more information see Naming cells and ranges on page 7 12 and Cell references in formulas on page 7 22 5 When you re satisfied with your entry click YJ to confirm it Select the sample values Replace the sample values SUM gaat A cee B3 MAANGA lias Cell address of result Function Click to cancel or confirm entry Tip If you know the name and format of a function you can type it rather than paste it in the entry bar Example Using the AVERAGE function This example shows how to use the AVERAGE function to calculate the average of three numbers 1 In your spreadsheet type 74 88 and 93 in cells Al B1 and C1 2 Click cell D1 to select it Function s result goes here Numbers to average K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 7 28 AppleWorks 5 User s Manual 3 Choose Paste Function from the Edit menu 4 Select AVERAGE from the list and click OK 5 Hold down the mouse button and drag the I beam pointer in the entry
84. Layout Continent Country rows and fields in menu columns South America View one record at Select Browse from the Layout k Continent South America a time menu and then deselect Country Uruguay Show Multiple from the Layout menu If Show Multiple is dimmed deselect Page View from the Window menu first 9 View the records Select Page View from the as they will print Window menu on paper p p Continent Europe Country France Records Continent Asia Country Japan poe Continent South America amp Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Database 8 17 Playing movies in multimedia fields In the Help index see gt playing movies When a field contains a QuickTime or AVI movie you see a preview image of the movie To play a movie in a multimedia field in Browse or List mode double click the field containing the movie To pause the movie click outside the field Important Ifa database document includes a multimedia field that displays movies and you move the document to a different computer you must move the movie files to the same computer Note You can also add a movie to an entire document For more information see Working with movies on page 9 26 Working with rows and columns in List mode In the Help index see gt List mode Records are in rows List mode
85. Moving through records Viewing records Playing movies in multimedia fields Working with rows and columns in List mode Selecting rows and columns Resizing rows and columns Moving columns and formatting data Selecting and hiding records Sorting records Finding information Finding text Finding records with a find request Saving a find request named search Matching records Working with layouts Understanding layouts Creating a layout Editing a layout Deleting duplicating and renaming a layout Changing the appearance of data Presenting and summarizing data with parts Copying summary data Resizing and deleting parts Creating reports Importing data from other documents Printing a database document Printing labels Closing up space when you print 8 10 8 12 8 12 8 14 8 14 8 15 8 15 8 16 8 17 8 17 8 18 8 18 8 19 8 20 8 21 8 23 8 23 8 23 8 25 8 26 8 27 8 27 8 29 8 31 8 32 8 32 8 34 8 36 8 36 8 36 8 37 8 38 8 39 8 39 Chapter 9 Beyond the basics Creating links Creating book marks Creating document links Editing links Deleting links Going to a specific link Sorting links Using styles About the stylesheet palette Styles in documents and frames Applying a style Creating a style Turning off a style Example Applying and creating styles Editing styles Copying pasting and deleting styles and properties Importing and exporting styles Creating a slide presentation Creating slides Setting up slides Reo
86. Or choose a Move command from the Outline menu In an ordered list AppleWorks relabels the moved item 1 Duis autem 1 Duis autem 4 Consectetuer 2 ESEE Og RmLorem ipsum dolor 3 Consectetuer Before After Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 4 12 AppleWorks 5 User s Manual Aligning paragraph text In the Help index see alignment control on the ruler gt text alignment blandit praesent luptatum blandit praesent luptatum zzril delenit augue zzril delenit augue duis dolore te feugait duis dolore te feugait nulla facilisi Lorem ipsum nulla facilisi Lorem ipsum dolor sit amet consectetuer dolor sit amet consectetuer adipiscing elit sed diam adipiscing elit ed diam Centered E Aligned left Changing line and paragraph spacing In the Help index see gt paragraphs Line spacing indicator A delenit augue duis dolore te feugait nulla facilisi Lorem ipsum dolor sit amet conzec Esi I Decrease spacing control Increase spacing control Single spaced text blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi Lorem ipsum dolor sit amet consectetuer adipiscing elit sed diam sit amet consec Aligned right blandit praesent lupt atum zzril tetuer adipiscing elit sed diam To align a paragraph place the insertion point in the paragraph a
87. Wong pictures references to movies or Month January formulas that calculate values Contribution 10 Name Elena Galdez Aset of fields is a record F Month February Contribution 10 65 Using Browse List Find and Layout modes In AppleWorks there are four modes in which to work with a database Browse List Find and Layout You select a mode using the corresponding command in the Layout menu n Name Chris Van Gough view add change and delete Month February records Contribution 4 56 Name Month Contribution Name Pat Wong Chris Van Gough 56 Records Month January 2 Contribution 10 Unsorted 10 Browse mode Records Maria Durand 10 List mode amp Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Database 8 3 Name Month Contribution Month Cortribution Contribution Name Name In Find mode you search for specific records to work with In Layout mode you design the way you want the data to appear when viewed or printed Creating a database document In the Help index see gt documents creating Note You can t create a database document within another document To create a database document when AppleWorks is running choose New from the File menu In the New Document dialog box select Database and then click OK Or click on the Default button bar If you don t see the b
88. a single object Group EA ws Separate grouped objects Ungroup You can ungroup objects more than once if necessary Di ah Change how objects overlap Move Forward Move To Front Move Backward or Move To Back Min fin Important If you see Ungroup Picture in the Arrange menu it means the selected object is an imported PICT file If you continue you may lose some of the picture To regroup the picture immediately choose Undo from the Edit menu K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 5 16 AppleWorks 5 User s Manual Locking objects to prevent changes To protect objects from being changed or frames from being deleted or moved lock them Unlocked objects have black handles thcked objects have dimmed handles To Do this EES a z In the Help index see Lock objects Select one or more objects and choose Lock from the Arrange menu gt locking Lock an Choose Sdect All from the Edit menu and then choose Lock from the entire drawing Arrange menu Unlock locked Select the objects and choose Unlock from the Arrange menu objects As you work with locked objects keep these points in mind You can change the contents of a locked frame Ifyou group an object with a locked object AppleWorks locks the entire group Choose Index from the Help menu and type the first few letters of
89. abases summary calculations To Do this Select a record Click anywhere in the record outside of a field Example Continent Asia Country Japan In Browse mode Continent click here 7 Continent Country In List mode i iJ i pan click here na Select multiple Drag through the records to records select or select a record and then Shift click another record to extend the selection Continent Country Continent Country Continent Europe Country France Hide unselected Select the records you don t records want to hide and then choose Hide Unselected from the Organize menu Continent Continent Asia Country Country Japan Continent Continent Asia Country Wore Country Yietnam Continent Europe Country France Before After Hide selected Select the records you want records to hide and then click on the Default button bar or choose Hide Selected from the Organize menu Continent Continent Asia Country a Country Japan Continent Asia Continent Country ag Country vietnam Continent Europe Country France Before After amp Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Sorting records In the Help index see gt records sorting Database 8 21 To Do this Example Deselect records Ctrl click the record Continent in a selection Country or select non
90. ady typed Select all of the cells to name include both row and column headings in the selection and choose Auto Name from the menu in the entry bar Select a name then click Define You can assign more than one name to a cell or range Cells B3 and C3 are named Shares Cells B4 and C4 are named Price Cells B3 and B4 are named January Cells C3 and C4 are named February Note Some characters such as operators like or and punctuation marks cannot be included in a cell name For complete information about naming a cell see onscreen Help Editing and deleting names If you change your mind about the name or location of a named cell or range or if you want to delete a name choose Edit Names from the menu in the entry bar Then make changes in the Edit Names dialog box To Rename a cell or range Select a name from the scrolling list and then Type a new name and then click Modify Change the cell address referenced by a name Delete the name of a cell or range Type a new address for the cell or range and then click Modify Click Remove If the name you want to delete is used in a formula you must first replace the names in the formula with cell references See Replacing cell references with named cells on page 7 14 Note When you edit a name AppleWorks updates all of the formulas that use the name you edited Choose Index from the Help menu and type the first few letter
91. age with the colors and patterns of another select an image or area and move it over the image whose color and pattern you want to pick up Then click is on the Default button bar or choose Pick Up from the Transform menu Before Image of horse replaced with the background After K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 6 12 AppleWorks 5 User s Manual Adding text and spreadsheets In the Help index see gt frames creating gt text frames AB To add text or a spreadsheet to a paint document 1 Click the text or spreadsheet tool move the pointer into the document and then drag to draw the frame 2 Choose options from the Font Size and Style menus and then type the text or numbers 3 When you finish click outside the frame The frame contents become part of the painting You can change the pixels that make up the image but you can t edit the contents by using text or spreadsheet commands Tip To include a spreadsheet frame in a painting create and add data to the spreadsheet frame in a draw or text document and then copy the frame and paste it in the paint document ABC Text in a painting Spreadsheet in a painting Creating text effects Add interesting visual effects to text by creating a text frame in a paint document Try typing a newsletter title in a bold font style Zoom in to enla
92. alette type a new name in the Name box and then click Rename Duplicating deleting and moving library items In the Help index see gt libraries items in To duplicate or delete library items or move them between libraries select a library item Shift click to select more than one item To deselect selected items or to select noncontiguous items Ctrl click the items To select every item in a library choose Select All from the library palette s Edit menu Select the object s and from the library palette s Edit menu choose Duplicate Delete Edit To Cut Copy Duplicate library items Paste Delete Delete library items Duplicate Select All Move items between libraries Cut or Copy and then open the other library and choose Paste from that library palette s Edit menu Or you can drag library items between libraries Viewing library items In the Help index see gt libraries palette To Choose a command from the library palette s View menu to change the way items are shown on the library palette From the library palette s View menu choose View library items as pictures By Object View library items as a list By Name when you view by name you see an item s scaled size Alphabetize items in a library Alphabetize v by Object Set the number of pixels used to by Name Alphabetize when you view by object View Options and th
93. all records that contain Colorado in the State field click in a State field that contains Colorado and then click In Browse or List mode click in a field To find records that and on the Default button bar click Match the value in the selected field Do not match the value in the selected field z Contain a value less than the value in the lt selected field Contain a value greater than the value in the Dy selected field To match records in Browse or List mode choose Match Records from the Organize menu Important To search for specific text values surround the values with double quotation marks In Browse or List mode Tomatchrecords choose Match Records from that contain the Organize menu and then Example formula A specific value Click the field name click the City 7 ity Petaluma operator and then type the value in double quotation marks Selects restaurants in Petaluma Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Database 8 27 In Browse or List mode To match records choose Match Records from that contain the Organize menu and then Example formula A specific value in Click the NUMTOTEXT number NUMTOTENTCType Italian a pop up menu or function and replace number by radio button field selecting it and clicking the field name Click the operator and Selects the Italian re
94. also Objects SS document type 2 3 3 9 Starting AppleWorks 2 1 Stationery creating AppleWorks 2 10 default Options 2 11 envelope 9 23 described 2 10 opening 2 5 opening with password 2 14 Status bar 1 7 3 1 3 9 Storing text and art in libraries 3 17 Styles applying 9 8 9 11 9 12 changing for outlines 4 17 text 4 7 text frames 4 6 copying pasting and deleting 9 15 creating 9 9 9 11 described 9 5 editing 4 17 9 13 importing and exporting 9 16 in documents 9 7 outline 4 17 9 7 turning off 9 11 types of 9 6 using in an outline 4 13 4 14 4 17 any document 9 5 9 16 database documents 8 19 8 33 draw documents 5 11 paint documents 6 6 spreadsheet documents 7 11 text 4 8 4 9 Stylesheet palette 9 12 Subscript text 4 7 Subtopics in outlines 4 13 Summary fields 8 9 8 10 8 11 Superior text 4 7 Superscript text 4 7 Symbols spreadsheet chart 7 29 Synonyms finding 4 30 T Table styles 9 7 Tables creating with Assistants 2 4 4 18 Make Table shortcut 4 19 spreadsheet tool 4 19 tabs in text 4 10 4 19 in text 4 18 4 19 7 2 styles for 7 11 9 7 Tabs setting and changing 4 10 Templates See Stationery Terminal described 10 2 Text See also Frames Text frames Word processing documents attributes changing 4 6 4 7 5 19 7 10 7 32 8 19 8 33 counting words 4 31 custom styles for 4 8 4 9 4 13 9 5 cutting copying and pasting 4 6 deleting 4 4 finding and changing 4 27
95. and click Inset Field for each one Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 9 22 AppleWorks 5 User s Manual Select to show merged data or deselect to show merge field names Shows the current database Field Names Merge Database addresslist cwk Show Field Data Select the field you want to insert into the merge document Switch Database Click to switch databases Click to insert the selected field into the merge document Insert Field 4120196 Kim Chen Merged deta 31 Richards Ave Butte MT 12345 Print Merge Click to print the merge document Dear Kim Thank you for leading the art class at Happy Yalley Resort this year Merge document You can move the mail merge palette around the window as you work to view the merge document Printing the merge documents ees When you re finished inserting fields or field data into your merge In the Help index see document click Print Merge on the mail merge palette In the Print dialog box gt merging data click OK AppleWorks prints one merge document for each record in the database document s found set Tip To print only one record select Show Field Data on the mail merge palette click an arrow to go to a record and then choose Print from the File menu Addressing envelopes If your printer can be set up to print on envelopes y
96. and paint frames to add a professional touch to a S drawing Once you add a frame to a drawing it becomes an object that you 3 can select and then work with just as you can any object For example you a can rotate it change its borders or make it transparent Rotated text frame If you don t see the tool panel choose Show Tools from the Window menu To do this in a draw document Do this Example O a o In the Help index Type text Select the text tool and click once in the EP ge Aa document Choose from the Font Size and XYZ gt frames creating Style menus and then type your text Change the appearance of Select the text frame and choose from the Byz tyz text in a text frame Font Size Style Text Color Alignment and Spacing AAAA a Aiii commands in the Format menu or choose Before After from the pop up menus below the buttons on the button bar K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 5 20 AppleWorks 5 User s Manual To do this ina draw document Do this Example Add a spreadsheet frame Select the spreadsheet tool and drag in the document to create a spreadsheet frame You see the spreadsheet pointer and spreadsheet menus Column and row headers have been hidden Paint Select the paint tool and drag in the document to create a paint frame You see the a7 d pencil painting tool
97. and right pages in a section Add a title page to the current section Select Title Page Specify the number of columns in a section Type a number for Number Of Columns Vary the widths of columns if you have multiple columns Select Variable Width Columns and then type widths for Space Before Column Width and Space After Create a mirrored column layout left facing pages and right facing pages have the opposite column layout Select Mirror On Facing Pages Set the width of equal width columns Type widths for Column Width and Space Between Text word processing 4 25 Varying the number of columns on a page If you add more than one section to a page you can vary the number of columns on the page For example to create a page with one column on the top half of the page and two columns on the bottom half add a second section to the page set the section to start on a new line and then add another column to that section In the Help index see gt sections Lom Ipam debe Atuat dboerbtre naa abp shart oad daa Perum my riba med iant ut news dokram bye igun arodu Trold ede ede inde bard m yd rovid aara tone aor aw dp thor A utWigdp am adan cm m odo angut Duds aha oam Mure dlceintanrdractt in bedpastts odite motets crv aqunt of Hum dikea a Muy at Pe A storo sevatioadthet odo Lom ipams doke Atwaat dboerbtre wove yest 4d dm mom n yribhvda od And dit ut rewtdel orem npa kyu ariboctipa
98. and then type the number of columns across and rows down Large spreadsheets may appear on multiple slides Database Set up a layout that displays one record per page slide one record does not automatically equal one slide Enter the information you want on each page To see what appears on each slide choose Page View from the Window menu Setting up slides In the Help index see gt slide shows options Once you have created slides on the pages of a document you can set up the slide show reorder the slides and specify visual effects If you have QuickTime or Video for Windows installed you can also include QuickTime or AVI movies in the slide show To run a slide show using the preset options see Showing the slides on page 9 19 Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 9 18 AppleWorks 5 User s Manual Click the icon to change the slide display the icon appearance changes to indicate that it s opaque transparent or hidden Icon appearance indicates the slide display To set slide options choose Slide Show from the Window menu In the Slide Show dialog box change options to customize your slide show and click Done Special effects options Slide Show Tx a a r Slide Options M Fitto screen M Center I Loop M Show cursor I Advance every 5 seconds Background Bord
99. arance of data on page 8 32 You control the appearance of data in Layout mode To Do this Insert a field in the Choose Insert Fidd from the Layout menu and then select a field and layout click OK Move a field or Select the field or field name and drag it to the new location field name Resize a field or field Select the field or field name and drag a handle name Align fields or field Hold down Shift select the fields and field names to align and names then choose Align Objects from the Arrange menu or click one of the alignment buttons on the Default button bar Add text to the layout Select the text tool A click in the document and then type the text Text added to the Header part appears only at the top of each page text added to the Body part is repeated with each record 8 32 AppleWorks 5 User s Manual To Add a picture SSS SS Se In the Help index see gt fields arranging gt layouts editing Do this Use one of the following methods Choose Library from the File menu choose Open and then choose a category In the library palette select an item and then click Use For more information see Using libraries on page 3 17 Copy and paste a picture from a different document Click B on the Default button bar or choose Insert from the File menu and then select the picture file using the Insert dialog box Use the drawing tools to draw directly in the layout C
100. are in onscreen Help Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Drawing 5 19 Adding clip art You can incorporate AppleWorks clip art and other types of art in a drawing Anything that you add to a drawing becomes an object To Do this Oae Se Se TA a R a a R In the Help index see Add AppleWorks clip art to Choose Library from the File menu choose Open and gt duplicati a drawing then choose a category In the library palette select an uplicating image and click Use For more information see Using gt Insert command libraries on page 3 17 gt libraries overview Copy one or more pictures from an Open the document containing the picture to copy AppleWorks document or a select the picture and click on the Default button document from a different bar or choose Copy from the Edit menu Open the application to a draw document AppleWorks document to contain the copy click where you want the picture to go and then click IG on the Default button bar or choose Paste from the Edit menu Import pictures created in a Click on the Default button bar or choose Insert different application from the File menu In the Insert dialog box select a file type from the Files of Type pop up menu locate the document to import and then click Inset Adding text soreadsheet or paint frames aiig Use text spreadsheet
101. atabase to a maintain address lists and then print names and addresses onto labels form letters and personalized notices maintain customer lists for automated mass mailings or information about guests and vendors for parties and events create attractive invoices and reports create lists you need to sort such as bibliographies for school papers catalog recordings stamps and other collections Database basics If you have not previously worked with AppleWorks database documents take a few minutes to read about some general database concepts the basics of setting up a database and entering information What s a database In the Help index see databases documents A database is a collection of related information or data which you can sort search through and print as needed Using a database you can organize and analyze information in various ways so that you understand its significance K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic In the Help index see gt Browse mode In Browse and List modes you AppleWorks 5 User s Manual These are the elements that make up a database Name Chris Yan Gough Month February Each category of information Contribution 4 55 The information in each field is a value is a field values can be text numbers dates times Name Pat
102. ating and opening 10 2 described 1 13 10 1 10 3 requirements 10 1 session described 10 2 spelling checking in 4 30 when to use 10 1 Contents Help 1 3 Continue indicators 9 25 Controls database 8 15 increase or decrease columns 4 20 line spacing 4 12 pane 3 2 paragraph and outline style 4 14 show hide tools 3 1 3 4 tab 4 10 text alignment 4 12 zoom 3 1 Converting documents by importing 2 15 to HTML format 11 9 Copying See also Cutting Duplicating Pasting cell formats 7 10 formulas or values 7 8 references 7 22 charts spreadsheet 7 29 7 30 database layouts 8 28 records 8 15 summary data 8 36 described 3 10 formats paragraph 4 13 spreadsheet cell 7 10 help text Help copying images 6 8 images colors of 6 6 library items 3 19 objects 5 9 objects attributes of 5 11 pictures 5 19 6 13 styles 9 15 Choose Index from the Help menu and scroll to the entry Then choose a topic from the list and click Go To Topic text tuler settings for 4 13 selected 4 6 using the eyedropper 5 11 6 6 Counting characters words lines paragraphs pages and sections 4 31 Create Labels Assistant 2 5 8 30 Custom buttons on button bar creating 9 28 styles in outlines 4 17 text 9 5 9 16 Cutting See also Copying Pasting cell data 7 8 described 3 10 library items 3 19 styles 9 15 text 4 6 D Database documents See also Databases Fields Layouts Records calculations 8 11
103. ays the number of characters words lines paragraphs pages and sections in the current document Note If you select Count Sdectionin the Word Count dialog box you get a word count for the current selection only Adding pictures and frames to text In the Help index see gt artwork text gt drawing tools gt libraries overview There are two ways to place pictures and frames such as clip art spreadsheets drawings and paintings in a word processing document You can insert them as inline objects so that they move along or flow with your text or place them as independent objects that float on the page and are not affected by the text Insert an object as an inline object when you want the object always to appear next to specific text or flow to the next line as you type more text Add a floating object when you want to wrap text around the object see the next section or move the object with the arrow pointer Lorem ipsum dolor Lorem ipsum dolor st amet euismod tincidunt L euismod tincidunt ub laoreet lt quis nosirt veniam quis satr A floating object has exea com mock four handles when you vu utate velit esse select the object An inline object has one factisisat j vero ee m commo handle when you select praesert Iup atur Lorem ipsum dolor st amet euismod tincidunt ut laoreet lt veniam quis nostrud exerci t vuputate velit esse the object eros et accumsan K Choose
104. b you need to save it in two formats as an AppleWorks document and as HTML When you edit the Web page later you open the AppleWorks document not the HTML file When you save a document in HTML format a URL links are translated into HTML links book marks are translated into HTML anchors most styles are translated into HTML styles To save a document in HTML format 1 Choose Save As from the File menu 2 Save your document first by choosing AppleWorks from the Save As pop up menu 3 Type a name for the document keep the filename extension cwk and then click OK 4 Save the document again and choose HTML from the Save As pop up menu 5 Type aname for the file keep the filename extension htm and then click OK Opening and editing HTML files In the Help index see Web pages editing When you edit your HTML file or Web page you open the original AppleWorks word processing document After you make changes to the document you must save it again as an HTML file Choose Open from the File menu In the Document Type pop up menu select Word Processing In the Files Of Type pop up menu select cwk Locate and then select the document View the document and then make any changes you want ao oa FF OO N a If you made changes save the document as described in the previous section Saving a document in HTML format K Choose Index from the Help menu and type the first few lett
105. bar to select the sample values between the parentheses Address of cell where Select the sample values function is stored but not the parentheses 6 In the spreadsheet hold down the mouse button and drag the pointer over the three cells whose values you want to average and then click x to accept the function AppleWorks replaces the sample values with the selected cell range and displays the average value 85 of the selected cells as the result Cell range poet ee The result Displaying data in charts graphs A chart or graph shows graphic relationships and trends among data You In the Help index see can chart data in a spreadsheet frame as well as in a spreadsheet document gt charts creating Unit Sales Data Opal B siver Line chart T T T IstQtr 2ndQtr ZrdQtr 4th Otr Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Spreadsheet 7 29 Making charts In the Help index see gt charts creating gt charts modifying To make a chart select a cell range and then choose Make Chart from the Options menu In the Chart Options dialog box click a chart type in the Gallery and then click OK AppleWorks draws the chart and places it on top of the spreadsheet Tip To create a chart quickly select the cells and click one of the chart buttons on the Default bu
106. base document you can accumulate information sort it and print attractive reports You can also perform sophisticated searches to find and work with only the information you want By creating different layouts views of the data you can organize and present the same data in many different ways You can also enhance the data by adding pictures patterned lines or other objects to the database document Database controls Introduction 1 13 File Edit Format Layout Organize Window Help la x 2 BB 2 8 8 S S 29 83 8 2 S GY Gl Bl 7 Ul 3 24 Hy Database menus H 4 lt J Jee ae and button bar ba 2 _ a fe none ___ Customer Cooks and Books Address 45 First St City Belmont State CA Recods Postal 94002 2 Fils 103 Customer Jones Electronics Sifa Address 12 Main Street ME City Woodside State CA Postal 94072 Fils 101 Customer Titan Books Bo gh 2 1 Address 78 South St 1 1 T f 1 6 1 1 f Clip art Austin Hite Customer Adgrese chy Sate Postal i 103 CooksandBooks 45FictSt Bemon CA M4002 101 Jones Electronics 12 Main Street Woodside CA 4072 Enter names and addresses 102 Than Books 78 South St Austin MN 55912 in a database document Alphabetize the list and add a picture See chapter 8 Database for more information about database documents Communications documents A communications document is di
107. bh euisr ut lacreet dobre magna aliquam erat volutpat Ut wisi enim ad minim ver nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea corr consequat Click twice outside the frame to work in the rest of the document and frames Click once to select the frame as an object Click again to work inside the frame Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 6 4 AppleWorks 5 User s Manual In the Help index see gt frames formatting gt frames working in Here are some ways to adapt a paint frame to suit your needs To Resize a paint frame Do this Select the frame and drag a handle Open the frame to see more of the painting Select the frame and choose Open Frame from the Window menu When you open the frame you see the painting in a new window The open frame is linked to the original document Any changes you make in the open frame are also made in the document To close an open frame choose Close from the File menu Change the width and height of the painting Select the frame and choose Open Frame from the Window menu When you open the frame you see the painting in a new window Choose Document from the Format menu and then type new size values To close an open frame choose Close from the File menu Close an open frame Choose Close from the File menu Display
108. billed only for connect time Online service A host computer that gives you access to a variety of information such as weather forecasts airline schedules databases used for research and bulletin boards for communicating with other users AppleWorks supports only text based online services and cannot be used to browse the World Wide Web Creating a communications document To create a communications document choose New from the File menu select Communications and then click OK Or click on the Default button bar If you don t see the button bar choose Show Button Bar from the Window menu Important To open a saved communications document you must use HyperTerminal You can t open a saved communications document using AppleWorks Communications 10 3 About the communications window All communication between your computer and an online service or another computer appears in the HyperTerminal window e School HyperTerminal lol x File Edit View Call Transfer Help HyperTerminal menus Use scroll bars to see more of the screen Type or receive communications text in the work area Connected 0 01 24 Auto detect Auto detect SCROLL CAPS Connecting to another computer After you open a communications document you re ready to connect to an online service or a remote computer using a modem receive a call from another computer using a modem connect directly to another comp
109. c About the paint window Paint menus Painting 6 3 When you open a paint document or create a paint frame you see the paint menus and the tool panel Tool panel File Edit Format Transform Options Window Help la x 8 a BI BY 8 2 Sl SI 2 el 8 S GY SI Bl 7 U sl Bo Sal T S OY fa al 7 S O ba Je Ia see 2 Buttons for common tasks in paint documents Working with paint frames A paint frame provides a view into a painting A paint frame is like any other object You can move it resize it change or delete the border or apply a fill color Within a frame you have full access to the paint tools and commands In the Help index see gt frames working in gt paint frames Handles show that the frame is selected O eee o_o Base E eth U P E a E R F B a N E a a A Lorem ipsum dolor st amet consectetuer adipiscing el Jd nonummy nbh euismod tincidunt ut laoreet dolore mac erat volutpat Ut wisi enim ad minim veniam quis nosh tation ullamcorper suscipt lobortis nisl ut aliquip ex ea consequat Duis autem vel eum iriure dolor in hendrer velit esse molestie consequat vel illum dolore eu feugi facilisis at vero eros et accumsan et iusto odio dignissit praesert lup tatum zzril dent augue duis dolore te feugait nulla facilisi dolor sitamet consectetuer adipiscing elt sed diam nonummy ni
110. ck OK Type the search criteria in the find request and then click Store on the status panel Use a named search The named search Modify a named search Edit Searches Modify the search criteria and then click Store Rename a named search Edit Searches Select a named search from the list and click Modify Type a new name click OK and then click Store Delete a named search Edit Searches Select a named search from the list click Delete click OK and then click Store K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 8 26 AppleWorks 5 User s Manual Matching records In the Help index see gt matching records For complex searches use the Match Records feature in Browse mode or List mode When you match records you enter a formula in a field to use for the search AppleWorks selects records that match the result of the formula When you find records AppleWorks shows the records it finds and hides the rest When you match records AppleWorks selects the matching records and leaves all other records in the document open on the screen To work only with the matching records hide the others by choosing Hide Unselected from the Organize menu Tip To match records quickly in Browse or List mode click in a field and then click one of the operator buttons on the Default button bar For example to find
111. ck OK 3 Select cell B1 and choose Deine Name from the 7 menu in the entry bar 4 Click Define to accept the suggested name Income 5 Select cell B2 and choose Define Name from the menu in the entry bar 6 Click Define to accept the suggested name Expenses 7 Cells B1 and B2 are now named Income and Expenses Cell name appears here Expenses v fx S 9 Select cell B3 and type an equal sign 10 Choose Incomefrom the menu in the entry bar and type a minus sign 11 Choose Expenses from the J menu in the entry bar and then press Enter 7 16 AppleWorks 5 User s Manual The formula contains the named cells Income and Expenses Example 2 Replacing named cells with cell references This example shows you how to replace the named cells you defined in Example 1 with cell references 1 Select cell B3 and choose Replace Names from the menu in the entry bar 2 In the dialog box note that Expenses and Income are suggested for replacement with cell addresses You want to replace them both so click Replace The named cells are replaced with their corresponding cell addresses 200 008 Changing cells rows and columns There are several features that control how you display and work with data in rows and columns You can resize hide insert and delete rows and columns Resizing or hiding rows and columns In the Help index
112. culation Produce the result of a formula that Weeklytotal 4 500 55 calculates values from the current record in the database For more information see Defining calculation and summary fields on page 8 10 Summary Produce the result of a formula that Yearlytotal 33 075 30 summarizes values from one or more records in the database The field appears only in the summary part of a layout For more information see Creating a layout on page 8 29 Checking or entering data automatically In the Help index see gt fields defining AppleWorks can enter or check data when you create records For example you may want the data in a number field to be unique and within a certain range To set up a field for data checking or automatic entry select the field from the list in the Define Database Fields dialog box and click Options You see the options available for the type of field you selected For example this dialog box shows the options available for number fields Choose Index from the Help menu and scroll to the entry Double click the entry and then double click a topic 8 10 AppleWorks 5 User s Manual Field type Field name P Options for Number Field PO Number 2 x Verification Default Data T Cannot Be Empty Automatically Enter T Must Be Unique a Type the data you want Set criteria for having J Must Be In Range ee to enter AppleWorks check the se automatically da
113. d Designing your Web page Before you create a Web page it s a good idea to learn about effective Web page design You can find such information in the computer and software sections of bookstores in computer industry magazines in classes and seminars and on the Internet In addition browse the Web and note aspects of other Web pages that you d like to use in your own As you create a Web page with AppleWorks keep the following design tips in mind Keep your design simple and uncluttered An orderly design makes it easier to scan the page to find information Limit the size of your page so that users scroll no more than three screens Use headings so that users can scan the page and read the portions they want Consider separating areas of text with horizontal lines Organize related information in lists K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 11 4 AppleWorks 5 User s Manual Use boldface and italic styles sparingly Too much emphasis makes text difficult to read Don t use underline because underlined text indicates a jump to related information Choose typefaces and colors that are easy to read onscreen Creating an HTML file To create an HTML file for a Web page start by creating a word processing document and then save your work as an HTML file In the Help index see gt Web page
114. d Working with text frames In the Help index see gt frames creating gt frames working in gt text tool Use a text frame when you want to add a block of text to a spreadsheet draw or paint document or to a database document in Layout mode You can t create a text frame in a database document in Browse Find or List modes When you finish working with the text inside a text frame click outside the frame to make the frame s handles reappear and to restore the main document s menu bar and functions When you draw a text frame in a word processing draw spreadsheet or database document you can move resize or reshape the text frame Select the arrow pointer on the tool panel J and select the text frame To resize or reshape the text frame click a corner handle and drag it to a new position Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 4 4 AppleWorks 5 User s Manual Typing text In the Help index see gt deleting text gt text shortcuts gt undoing actions _ ___ Drag ahandle to resize or Text in a Fra Draw document with a text frame me reshape the text frame Note If you create a text frame and then click outside the frame before you enter text the frame disappears To type text place the pointer where you want the text and click the mouse Then To Typ
115. d Type Continent Text 3 Click Done You see the first record of your database in Browse mode Continent Type field values here Country Field names Database 8 5 Part 3 Enter two values into the fields 1 Click in the Continent field and type Europe If the entire record becomes highlighted it means you clicked outside the field To select a field click inside the field borders Don t click the field name 2 Press Tab or click in the Country field and type France 3 The first record Continent Europe looks like this Country Fra nce Part 4 Make new records 1 Click E on the Default button bar or choose New Record from the Edit menu You see a new record under the first record 2 Choose New Record from the Edit menu again Three records now appear in the database Part 5 Finish entering data in the new records 1 In the second record click in the Continent field type Asia and then press Tab 2 Click in the Country field of the same record and type Japan 3 In the third record type South America in the Continent field press Tab and then type Brazil in the Country field Continent Europe Country France Continent Asia Country Japan Continent South America Country Brazif Your database with three records Part 6 Close the database Note You may want to save your example database and use it to practice other database operations described in this cha
116. d click OK You can also click a a or foo on the Default button bar Some number date and time formats Copy a cell s format to other cells Select the cell whose format you want to copy and Before choose Copy Format from the Edit menu Then select the cell or range where you want to apply the format and choose Paste Format from the Edit menu Set the default font Choose Default Font from the EU Options menu Choose a um font and font size and then click OK aaron i 4 Spreadsheet 7 11 In the Help index see gt styles Tip AppleWorks comes with preset table styles that you can use to change a cell s formatting and appearance in one step For example you can apply a style to format the data highlight the titles and apply colors to the rows Start by creating a small spreadsheet and entering some data Then click on the Default button bar or choose Show Stylesheet from the Window menu to display the stylesheet Select rows and columns that you want to highlight and click 3D Tale 1 AppleWorks applies the 3D Table 1 style to the selected cells For information on applying styles or creating your own see Using styles on page 9 5 Stylesheet x Edit Style ix File Edit File Edit Select the cells to format Default SS pw30 Table 1 Base Style None gt 3D Table 2 Text Font Arial gt Accounting Text Size 10 pt gt Blue Gray 1 Cell Alignment
117. d in a different application if AppleWorks supports the format You open the entire database as an AppleWorks document insert information from another AppleWorks database AppleWorks pastes the whole database into the current database insert information from saved ASCII DBF DIF or SYLK formats You select the fields to insert from the other database Any changes you make in AppleWorks affect only the AppleWorks document into which you import or insert the data The document that the data comes from remains unchanged K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 8 38 AppleWorks 5 User s Manual Important Make a backup copy of your AppleWorks database before you insert from another document To Do this Import a database Choose Open from the File menu and then choose Database from the Document Type pop up menu Choose a file format from the Files of type pop up menu and then click Open Insert a database Create a database or open a database to insert into Click on the Default button bar or choose Inset from the File menu and then select the file to insert If you selected an AppleWorks database AppleWorks inserts it If you selected an ASCII DBF DIF or SYLK database choose the fields to insert in the Import Field Order dialog box and then click OK AppleWorks supports these formats Supported forma
118. d text within a field choose Find Change from the Edit menu For more information about finding and changing text see Finding and changing text on page 4 27 Finding records with a find request The status panel changes in Find mode Create a find request to find and display only the records that satisfy the search criteria that you set After the search AppleWorks displays the results in Browse mode To create a find request choose Find from the Layout menu type or select the search criteria in the find request and then click Find Restaurant Type Type or select the City value you want to find Avg Price E Reviewed in one or more fields Search visible records or all records including hidden records Click to show records that do not meet your search criteria Click to start the search Click to create or choose anamed search K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 8 24 AppleWorks 5 User s Manual In the Help index see gt New Request command gt operators To narrow your search you can use relational operators such as lt and gt enter values in multiple fields or require that a record meet either one set of search criteria or another There are many ways to combine different search methods The following table provides some common examples For example to f
119. dd are a header summaries database sub summaries grand summaries leading and trailing and a footer To insert a layout part choose Layout from the Layout menu choose Insert Part from the Layout menu and then select the part to add Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Parts in Layout mode Quarterly contributions Database 8 35 Name Month Contribution Name JMr J Contribution Bod Contributor total Contributor total Sub summary by Name Summary fields are defined with Total contributions Total contributions the formula SUM Contribution Quarterly contributions Q1 1995 page 1 Parts in Browse mode Page View on The body part contains the data from individual records Quarterly contributions j Name Month Cris Van Gough January Cris Van Gough February Maren Cris Van Gough Contributer tatal Elena Gaiez January Elena Gaiser Feteuary Elena Gaiser Maren Contributer tetal January Pat Wong February Pat Wong March Contributertetal 7625 A grand summary contains one or more summary fields that summarize data in all records in a document A leading grand summary goes above the information and a trailing grand summary goes below Tets contributions Quarter orkribuons O1 199 Contribution 20 35 456 421 50 12 20 1 10 65 30
120. ddress 1 You can also use List mode to see data in columns by choosing List from the Layout menu See Working with rows and columns in List mode on page 8 17 Fields are arranged horizontally Labels Shows and prints field Name Address 1 contents arranged for use with adress 3 mailing or other labels City ST ZIP Avery 5160 5260 5660 mailing label format In all layouts you can add objects and other enhancements add rearrange or delete fields change the appearance of text change the format of numbers dates and times change the appearance of pictures and movies in fields change the appearance of pop up menus radio buttons and checkboxes add layout parts to organize and summarize data see Presenting and summarizing data with parts on page 8 34 Creating a layout To create a layout choose New Layout from the Layout menu or from the Layout Si pop up menu In the Help index see gt New Layout command New Layout 21x Name weekly Repor Type a name for the layout Type Standard Columnar report Duplicate C Labels Select the layout type C Blank E ustom z cr K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 8 30 AppleWorks 5 User s Manual New Layout im Edit Layouts Data Entry For Printing Avery 5160 Selecting a layout
121. ddressing envelopes Some Assistants are gt Assistants available when you first create a document and others are available while you re working with a document To use an Assistant when you first create a document choose New from the File menu In the New Document dialog box select Use Assistant or Stationery Choose a category from the pop up menu and then select an Assistant name from the scrolling list K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 2 4 AppleWorks 5 User s Manual Select an Assistant Thir darida wi baigt pe arhh g rka Wed idha drii Dad You can use other Assistants to help you perform a specific task in a document yov ve already opened These Assistants are available in certain types of documents only For example the Assistant for creating tables is available with draw and word processing documents To use an Assistant for the current document choose AppleWorks Assistants from the Help menu in the AppleWorks window Select an Assistant and then click OK Table Assistant 2 xi Table Assistant H The Table Assistant makes it easy to add complete formatted tables to your document Begin by selecting the type of information you want in your table Select Table Typi Days C Months C Quarters Years Numeric Range C Custom y Days Use this for calendars or to do lists
122. de Web sending and receiving on Internet 11 10 Elements chart 7 29 Email See Electronic mail Endnotes See Footnotes Enlarged view See Zooming Enter key changing preferences for 3 21 Envelope Assistant 2 5 9 22 9 23 Envelopes addressing 2 5 9 22 Eraser 6 5 Errors memory 6 14 spreadsheet in cells 7 24 e bullets in cells 7 22 formula 7 25 troubleshooting troubleshooting Expanding outlines 4 16 Exporting AppleWorks documents 2 15 HTML files 11 9 styles 9 16 Eyedropper 5 11 6 6 F Fields See also Database documents Layouts Records adding 8 12 8 31 aligning 8 31 calculation 8 9 8 10 8 11 changing 8 12 coloring 8 33 defining naming 8 3 8 7 8 12 deleting 8 12 described 8 2 entering data in 8 12 labels hiding 8 33 moving 8 31 multimedia 8 9 number of characters in text 8 8 objects in 3 10 options entry for 8 9 resizing 8 31 selecting 8 12 summary 8 9 8 10 8 11 tab order changing 8 14 text attributes of 8 19 8 33 types of 8 3 8 7 8 12 File formats database 8 38 saving for export 2 15 reuse stationery 2 10 FileMaker Pro exporting and importing 8 38 Fill command paint 6 10 Filling cell data 7 8 images 6 5 6 6 6 10 objects and frames 5 10 Fills copying from objects 5 11 described 5 3 Filters See Translators Finances home 2 5 Find mode database 8 2 8 23 Find requests and merging data 9 21 and record numbers 8 25 described 8 23 saving named
123. ded by other OLE applications Applications that provide objects are called OLE server applications When you insert OLE objects pictures sounds video clips and other information in an AppleWorks document you use the server application not AppleWorks to create the object and to change the way it looks in your AppleWorks document You can include OLE objects in AppleWorks word processing draw and spreadsheet documents You can also include OLE objects in Layout mode in database but not in a database field You can insert embedded objects and linked objects into your AppleWorks documents Insert To Embedded objects Store the object in your AppleWorks document Linked objects Maintain a connection to the source original file Changes you make to the object within AppleWorks are reflected in the source file Or you can use the server application to change the source file and those changes are reflected in your AppleWorks document Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Beyond thebasics 9 31 Inserting OLE objects This section provides information on inserting OLE objects using the menu commands You can also insert OLE objects using the OLE tools palette In the Help index see gt object linking and embedding OLE To insert an OLE object into an AppleWorks document 1 Prepare your document to recei
124. des three preset outlines for you to use You can modify the preset outline or create new outline styles For information on modifying styles see Modifying an outline style on page 4 17 To create a style see Using styles on page 9 5 K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 4 14 AppleWorks 5 User s Manual I Planning 1 Planning Planning II Funding 2 Funding Funding A Grants 21 Grants Grants B Loans 22 Loans Loans 1 Institutional 22 1 Institutional Institutional 2 Government 2 2 2 Government Government 3 Private Sector _ 2 2 3 Private Sector Private Sector III Building 3 Building Building Harvard format Legal format Diamond format You can add an outline at any point in a text document or frame by choosing an outline label from the pop up menu on the text ruler To format existing text as an outline select the text and choose an outline label When you re finished typing the outline you can begin typing paragraphs again by choosing a paragraph label from the pop up menu on the text ruler v None Diamond Bullet Check Box Harvard Leader Paragraph and Legal outline labels Letter Caps Letter Numeric Roman Caps Roman See the next section for more information about creating and adding topics to an outline Tip If you want to organize your thoughts but you don t want to create an o
125. document as regular stationery and store it in the AppleWorks Stationery folder you see the document s summary information in the New Document dialog box K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 2 14 AppleWorks 5 User s Manual What you enter for Appears in the New Document dialog box as the Title Document name in the scrolling list Category Category name Description Document s description Note You can enter more than one category For example if you enter Business Home Education the document appears in the Business category the Home category and the Education category Protecting documents with passwords You can protect a document or stationery by setting a password which you and other users must type before you can open the document or stationery using AppleWorks In the Help index see gt passwords 1 Choose Document Summary from the File menu 2 Click Set Password type a password up to 255 characters of letters numbers or symbols and then click OK 3 In the confirmation dialog box type the password again and then click OK Important Keep the following points in mind If you set a password for default Options stationery you must type the password each time you open the stationery document If you don t type the correct password when you try to open the document AppleW
126. ds 8 16 WwW Web pages See also HTML files Hypertext Markup Language HTML Internet World Wide Web creating 11 4 described 11 3 design tips 11 3 editing 11 9 linking to Uniform Resource Locator URL 11 5 opening 11 9 saving 11 9 Web See World Wide Web Windows arranging 3 3 described 3 1 document for databases 8 31 drawing 5 2 painting 6 3 spreadsheet 7 3 word processing 4 2 splitting into panes 3 2 zooming 3 2 Windows Help application 1 3 Word count 4 31 Word processing documents See also Text Text frames book marks in 4 34 changing text attributes 4 7 columns in 4 20 4 22 counting words 4 31 described 1 9 4 2 footnotes and endnotes 4 26 formatting characters 4 6 linked frames in 9 26 links to different or same document 4 34 movies in 9 26 9 27 outlines in 4 13 page breaks in 4 21 pictures in 4 31 preferences for 3 20 sections 4 22 sorting in 4 13 spreadsheets in 4 18 4 31 tables in 4 18 tabs setting and changing 4 10 title page for 4 19 when to use 4 1 word count 4 31 Word processing frames See Text frames World Wide Web See also Electronic Mail HTML files Hypertext Markup Language HTML Internet Web pages browsers 11 2 connecting to 11 3 described 11 1 WP document type 2 3 3 9 Wrapping text around pictures 4 32 at end of line 4 4 in spreadsheet cells 7 10 WWW See World Wide Web Choose Index from the Help menu and scroll to the entry Then choose a topic fro
127. e Printing a document or Help topic on page 2 16 Word processing documents always appear in page view To preview a word processing document without margins and page guides choose Document from the Format menu and then deselect Show margins and Show page guides The Soccer Company The Seccer Company igue duis dolare te faugad cwihe Hodis La Tendtait in vulputate wait ess augue dus oles te fenga outs feds Lo dolar st amet coresaten e molestie c m sum dolor s amet coesecteuer re E ud dam eon tiny that anedier geese coma elite Halted dua reenn o ens mdee adiguam erat volutpat vero aioe at aseumaan etiusto Ut horer dolore magra aliquam erat volutpat veniam is vod GSS 2S Sein gi Unwiticedm ad miram venam is coetud itato utlamecrper mseipir Lebar ie pasas upis m za exami tation ullamearper meiit Ioba cael Aliquip ax sazdan commodo eoreegnt Duis Augue duis dolore te fenga cut Aliquip lt x sasden commodo consequat Duis tam vel cum kiue doke beret P arem poum dol ait a autem vel eum dite doe i bender melanie soc eqat veld Rccesttena adhere sik saddam Wille welt core melee eoeeagnt vel Sugat culls facilisis at vero aros lt b Inonu mmy nibb euis mod tincidunt ut Jaccect dace eu gt eth fede at vero ae l m quit oie m sam ent volutpat Ue wii accumsan at ais s iuge papai pi atm aad dina maia eee te Gugait th Sedlied Lorem ipaum lation uthmecper suscipk kbatisritut te ugaiteuth Seilisi Lorem ipaum doke irg lt s
128. e Custom in the New Layout dialog box AppleWorks asks you to specify the size and number of the labels on the page Tip To create labels quickly create your database and then use the Create Labels Assistant Choose AppleWorks Assistants from the Help menu choose CreateLabels and then click OK For more information about Assistants see Using an Assistant on page 2 3 Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Database 8 31 Editing a layout To change the arrangement and appearance of data you must be in Layout mode You can use the tool panel to make changes Tip When you work in Layout mode it s often convenient to use two views of the document one in Layout mode and the other in Browse mode to see your changes immediately as you make them Choose New View from the Window menu and then click 88 on the Default button bar or choose Tile Windows from the Window menu For more information about arranging windows see Arranging windows on page 3 3 In Layout mode fields and field labels appear as objects You can add modify resize or move a field or field label in the layout without changing the data in the database You change only the field s appearance and not its data To change field data see Adding changing and deleting fields on page 8 12 To change the way data appears see Changing the appe
129. e Edit menu Then choose Reshape again Create a pattern of duplicate Click 4 on the Default button Y SX A A 7 connected shapes bar or choose Paste from the Edit menu one or more times Then choose Peshape again X Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Arranging objects In the Help index see gt objects arranging Drawing 5 15 To align rotate flip or group the objects you draw or to change how they overlap select the object or objects to arrange and then choose a command from the Arrange menu Start by selecting one or more objects To Align objects to the autogrid Select the object s and choose this command from the Arrange menu Align to Grid Example before and after Align objects to each other or distribute space evenly between objects Align Objects In the Align Objects dialog box select a Top to Bottom and Left to Right option click Apply and then click OK You can also choose the appropriate button on the Default button bar in An fin fii Rotate objects freely Free Potate Select the object to rotate and drag a corner handle Then choose Free Rotate again Rotate objects Rotate Type a value for the degree of rotation and then click OK DA D Flip objects Flip Horizontally or Flip Vertically at av Group two or more objects into
130. e a link to information on the Internet see Linking Web pages on page 11 5 X Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Chapter 6 Painting This chapter describes what you can do with an AppleWorks paint document or paint frame All paint features including procedures buttons and troubleshooting are described completely in onscreen Help When to use a painting Use a painting when you want to create airbrush or brushstroke effects to tint colors or to transform shapes for example to add perspective to an image or add special effects for example blurring an image Because paintings are made of individual pixels dots that you can change you have very precise control over textures colors and shapes Use an AppleWorks paint document or frame to create hand painted artwork for invitations holiday decorations posters and announcements a illustrate reports work with scanned pictures When you are painting you use the same tools used to make drawings described in Using the drawing tools on page 5 3 plus additional painting tools such as the spray can 6 2 AppleWorks 5 User s Manual In the Help index see gt pixels m oS St hes less In adrawing changes affect he entire selected object 2 2 a Lps Painting basics How paintings and drawings differ Drawings are made of objec
131. e a paragraph Do this Begin typing the text Don t press Enter when you reach the end of a line AppleWorks wraps the words to the next line End one paragraph and start another Press Enter once to end the paragraph Press Enter again to insert a blank line Move the insertion point Move the I beam pointer to where you want to insert text and click You can also move the insertion point by pressing an arrow key Use a line break or soft return to end one line and start another without creating a new paragraph Hold down Shift and press Enter Insert a non breaking space to keep two words on the same line Delete the character to the left of the insertion point Hold down the Ctrl key and press the Space bar Press Backspace Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Text word processing 4 5 Typing equations In the Help index see gt Equation Editor You can use Equation Editor to add equations to an AppleWorks word processing document or frame Equation Editor an application by Design Science Inc is installed on your hard drive with AppleWorks To add an equation at the insertion point of a text document or frame choose Insert Equation from the Edit menu You see the equation editor which you can use to add the mathematical components to build the equation To edit an equa
132. e click a topic Drawing 5 7 Using the graphics ruler and grids Dotted lines move with the pointer In the Help index see gt autogrid gt graphics grid gt rulers The graphics grid graphics ruler and autogrid an alignment feature that helps you draw or move objects in precise increments help you size position and align objects in a draw document Graphics ruler Graphics grid ae Th R Pointer You can change the ruler settings turn the autogrid off or hide the graphics grid To Choose Show or hide the graphics grid Show Graphics Grid or Hide Graphics Grid from the Options menu Show or hide the ruler Show Rulers or Hide Rulers from the Window menu Set ruler type divisions and units Rulers from the Format menu choose options from the Rulers dialog box and then click OK Move objects freely without being Turn Autogrid Off from the Options menu constrained to the autogrid Turn on the autogrid so objects Turn Autogrid On from the Options menu snap to the grid Moving objects Move selected objects with the pointer the keyboard or by using menu commands Remember that you can usually reverse your most recent action by clicking on the Default button bar or choosing Undo from the Edit menu To revert to the most recently saved version of your document choose Revert from the File menu K Choose Index from the Help menu and type the first few lette
133. e fill and pen palettes to set the fill color and pattern gradient or texture and set the line color pattern width and arrowhead style Select the fill and pen settings before you paint an image It s easier to set them up ahead of time than to change an image once it s been painted Use To OM Fil palettes Set the fill color and pattern gradient or texture used for closed l images such as the oval and the paint bucket tool and set the fill color and the pattern gradient or texture used for the brush tool and spray can tool Pen palettes Change settings for lines and image borders or to add arrowheads OEE sH You can use the eyedropper to pick up copy a color from an image to use in the fill or pen palettes without having to select it from a palette Click the eyedropper and then click in the image where the color you want appears The color of the pixel you click appears in the fill sample To change the pen color instead of the fill color hold down Alt as you click Tip Save combinations of fill and pen attributes as a style and then apply the style to change the palette settings in one step To open the stylesheet click 3s on the Default button bar or choose Show Stylesheet from the Window menu For more information on styles see Using styles on page 9 5 Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Paint
134. e object to move Type a positive number to move the object below the line of text or type a negative number to move it above the line of text Wrapping text around pictures In the Help index see gt text wrap You can wrap text so that it flows around a picture or frame either in a rectangular shape or around the contours of the object Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic ut laoreet dolore Text word processing 4 33 magna aliquo excr ript nec gt ponam In he utlaoreet ye dolore magr donam Ut suscript nod tncidunt ut n ullamcorpe m In henderet il dolore magna alic donam Ut suscript r nod tneidunt ut le n ullamcorper sic etdonam Uts Picture placed as an object with text wrapped around it To Wrap text around a picture in a word processing document Do this Place the picture in your document as an object see the previous section Click the picture to select it and then choose Text Wrap from the Options menu To wrap text around the contours of the object choose Irregular The number in the Gutter box determines how close the wrap is to the object You can also click on the Default button bar for an irregular wrap Wrap text within a text frame Select the item you want to wrap text around and place it over a linked text frame Select the frame and see if Frame Links in the Op
135. e other special characters use the Windows Character Map For more information see the documentation that comes with your computer Adding bullets numbers and checkboxes to paragraphs In the Help index see gt bulleted lists gt labels paragraphs AppleWorks comes with a series of special characters called paragraph styles that you can use to convert paragraphs to lists such as bulleted lists numbered lists and checklists Saturday s trip Weekend chores Class Schedule e Call Linda Click to check off Arrange decorations 1 English Pack items Shop for groceries 2 History e Call hotel o Wrap gifts 3 Chemistry Tickets o Order fruit 4 French Today 5 Literature e Check parking e Pick up laundry Bulleted list Checklist Numbered list Tip If you want to label most or all of the paragraphs in a document use an outline style See Outlining on page 4 13 for more information To create a list select one or more paragraphs and click the pop up menu on the text ruler and choose a paragraph style Or choose Paragraph from the Format menu and choose a paragraph style such as Bullet Check Box or Numeric from the F pop up menu and then click OK If you don t see the paragraph label on your text type a number such as 25 for Left Indent in the Paragraph dialog box To reorder labeled paragraphs click to the left of a paragraph label and drag the paragraph to a new place in the outline
136. e text in the table and click E on the button bar See Using the button bar on page 3 5 By creating a Select the spreadsheet tool from the tool panel and drag the spreadsheet frame spreadsheet pointer diagonally If you don t see the tool panel choose Show Tools from the Window menu To make the spreadsheet frame move along with the text when you make changes in the document insert the spreadsheet frame as an inline object as if it were a character in the text For more information see Adding pictures and frames to text on page 4 31 For more information abut creating and using a spreadsheet frame see Spreadsheet basics on page 7 2 Using an Assistant Choose AppleWorks Assistants from the Help menu Select Make Table and click OK See Creating a document on page 2 1 for more information about Assistants Working with pages You can change the design of all or some of the pages in a document by formatting text in columns putting text in tables and adjusting page and column breaks You can also add headers and footers to pages and show the current page number date and time in the document See Creating headers and footers on page 3 12 Adding a date or time on page 3 14 and Numbering pages on page 3 15 Creating a title page In the Help index see gt cover pages If you ve added a header or footer to a word processing document you can create a title page s
137. ect Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 5 12 AppleWorks 5 User s Manual To copy an object s attributes select the eyedropper and click the object whose attributes you want to copy The fill and pen samples change to reflect the new settings To apply the new settings to another object select the eyedropper position it over the object and hold down Ctrl as you click Resizing objects In the Help index see gt resizing objects To resize one or more objects or frames use the mouse or AppleWorks commands To resize objects by Select the objects and Example Using the mouse Place the pointer on a handle and hold down the mouse button as you drag a handle To scale proportionally hold down Shift as you drag Specifying a Choose Scale by Percent from the Arrange percentage scaling menu Type values in the boxes for the percentage by which to enlarge or reduce the area and then click OK Setting new Choose Object Size from the Options dimensions menu type values in the bottom three Use these boxes in the size palette and then L settings to press Enter reposition the object Type here See onscreen Help for additional information on resizing objects and frames For information on In the Help index see Adding extra handles to objects to help you change gra
138. ected you see the number of the first section in the title bar of the Section dialog box Changes you make in the Section dialog box apply to the first section in the selection only K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 4 24 AppleWorks 5 User s Manual Shows the number of the section you re formatting Note You cannot insert a section with the Section dialog box For information on inserting a section see Inserting and deleting a section on page 4 23 Section 1 21x r Start Section Columns New Page it Number Of Columns fl m Page Numbers a Vareble width Golumns I Mirror On Facing Pages Continue From Previous Section ie poe f Settings For Single Column m Headers and Footers Space Beroe E Continue From Previous Section Column width asin C Different For This Section a yo Space BEWEET E T Left and Right Are Different T Title Page Cancel To Set where the section begins Do this Select an option from the Start Section pop up menu Change the starting page number for a section Select Restart Page Number and type the starting page number for the current section Make the header and footer information Select Different For This Section different from the previous section Use different headers and footers on the Select Left amp Right Are Different left
139. ed 4 6 searching for finding 4 28 showing hiding 4 6 11 4 Formulas See also Functions Spreadsheet documents calculating 7 24 database 8 9 8 10 described 7 20 displaying in cells 7 19 entering in databases 8 9 8 10 spreadsheets 7 23 errors in 7 25 examples 7 21 7 25 named cells in 7 14 operators entering 7 23 order of precedence of operators Frames See also Paint frames Spreadsheet frames Text frames documents in paint 6 12 spreadsheet 7 4 filling 5 10 inline 4 31 inserting in text 4 31 linked 9 24 9 26 locked 5 16 selecting 5 6 5 20 text changing appearance of 5 10 5 19 transparent 5 3 5 10 5 19 Freehand objects See also Objects connecting 5 13 drawing 5 4 reshaping 5 13 Function button 7 27 Functions See also Formulas Spreadsheet documents described 7 26 entering in databases 8 11 spreadsheets 7 27 example 7 27 for matching records 8 27 values selecting 7 28 G Gallery 7 30 General preferences 3 21 Getting help See Help Glossary terms in Help glossary user s guide 1 2 Go to page 3 4 record 8 15 spreadsheet cell 7 6 Gradients See also Palettes copying from objects 5 11 displaying faster graphics preferences preferences for 3 21 setting for database fields 8 33 images 6 6 objects 5 10 Graphics preferences 3 21 Graphics ruler See Rulers Graphics See Clip art Pictures Graphs See Charts Grids 5 7 6 8 Grouping objects 5 15 5 16 Index 1 5
140. ed dam hatiguip lt x sasden commodo coreequat Dui Amet coceestetu irg elt sad dam famy eh ci mod eased ot aaraa utd vel eum ace doler p bende xy Dee tomy edb euie med tidak ut cee e a aerea Uk wi an otepa oeaan e ri fees ser TA imeapa seipa bbais rie ut ak fice at acciiean a aao od derusamga fice ulameaper aiseip baie oa ut aik easda commodo bendkent in wiputate va uptahum zit delenit augue den commodo bertar in wilputate Pi louie dolre te gait cute Seiisi Laram Seint cu Scaled at vero aros 2 MENMA eom deiae ot vn creenvar vipwery Eighth Seti aaao zo aeoaea azio aesert dam cccnmmy nb ens dole magpa agian ar GRIM zzi le dii dobre te timide ut ect dolce ngpa aliguam er Metalu m zal delan augue diis doers te NSbtpar Uwal ain ad nai wam gi Svea mia Selon Larem spam dake sit pet Ue wet anan ad aeua Sig cuia Seed Latem ipaum dk sit nid azari niicnulhmmorpar siciph Aat coceastetuer seddam libertis n st ut aliquip ex eazden commodo Dcu mmy ribb suie mod tawiduct ut taceset korseg Duss utam ian larzaga Dux aitim vel aum kiua dake Gola magen aliquam em volutpat Ue wii endeerk wiputate vel t endear in wiputate veld osse maleic enim ad minim veniam quis costnd exami onsequat vel illum dolare eu mia leoceequat mia lation uihmecper ssip iobatis nist st ali ilka af wero eroe et accumaan a iusto od etic at vao ce a accu duo of X eas den contado socken Due witen iiseim qui jm zai diericeim qui bland passert luptatum zal lt u x
141. ee OOI Be peris cidunt snim 30 rper Ht er a Un nilameorPes coset ose cle enti jsut aliqui dolor in Ben el ito m emelet nosie met in bulputate velit esse molestie consequat vel illum n is faei n Duis autem vel eum iriure dolor in hendrerit per Sy puis aute velit 8 dolore eu feugiat nulla facilsis at vero eros et inal eet accumsan et iusto odio te feugait nulla faclisi deo ist T Dolore magna Aliquam erat 1972 2 Esse Molestie consequat 1987 3 Feugiat nulla facilsis Footnotes Endnotes If you need help adding or formatting footnotes or endnotes use the AppleWorks Assistant for inserting footnotes Choose AppleWorks Assistants from the Help menu Select Insert Footnote and then click OK See Creating a document on page 2 1 for more information about Assistants Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Text word processing 4 27 To set options for footnotes and endnotes in the Document dialog box choose Document from the Format menu Then To Do this in the Document dialog box Change all the footnotes in the document to Select At Bottom of Page or At End of Document endnotes or change all the endnotes to footnotes Use footnote characters other than numbers Deselect Automatic Numbering such as or Start numbering footnotes at a number other Type a number for Stat At than 1
142. eet For more information on merging documents and printing them see Merging data into documents mail merge on page 9 19 Selecting cells and ranges In the Help index see gt Go To Cell command gt selecting cells You must select a cell or cell range group of adjacent cells before you can change format or work with data K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 7 6 AppleWorks 5 User s Manual Address of selected cell Modifying cell data Editing data st In the Help index see gt entering spreadsheet data gt finding text gt spelling gt spreadsheets preferences Address of upper left cell in the selected range The selected cell has AppleWorks highlights a heavy border the selected cell range To Select a cell Do this Place the pointer in the cell and click the mouse button Select a cell range Hold down the mouse button and drag the pointer over the cells you want to select Select an entire row or column Select the entire spreadsheet Click the row or column heading Choose Select All from the Edit menu Go to a cell Choose Go To Call from the Options menu type the cell address for example A42 or R7 and then click OK Go to a named cell or cell range Choose the name of the cell or range from the bottom of the
143. en type a size in pixels for Horizontal display items on the library palette and Vertical View Options K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 3 20 AppleWorks 5 User s Manual To From the library palette s View menu choose Set the number of rows when you View Options and then type numbers for Rows and Columns view by name and columns when you view by object on a library palette Setting preferences You can customize AppleWorks by setting options in the Preferences dialog In the Help index see box Some options you set apply to the current document only and others gt preferences apply to new documents you create To have settings take effect whenever you create a new document click Make Default in the Preferences dialog box Tip You can also set specific preferences in a document and save the document as stationery that you can reuse For more information on stationery see Saving document formatting as templates stationery on page 2 10 Choose Preferences from the Edit menu In the Preferences dialog box choose a category General Text Graphics Spreadsheet Palettes or Communications from the Topic pop up menu Select options and then click OK Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic
144. ename K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 2 12 AppleWorks 5 User s Manual Save As Save in ja AppleWorks Stationery X ce f Type aname for the document FISTS Lettethead cows Save as type AppleWorks Stationery cws x Cancel Choose the AppleWorks Stationery file format 4 Select the folder into which you want to save the stationery If you re creating default stationery or if you plan to open stationery from the New Document dialog box save the stationery in the AppleWorks Stationery folder which is in the AppleWorks 5 folder If you re setting up regular stationery to open from the Open dialog box you can save the stationery in any folder 5 Click Save Opening stationery When you open a stationery template document AppleWorks opens it as a new untitled document and the original document remains unaffected You change the document as necessary and then assign it a new name when you save it To open default stationery 1 Choose New from the File menu 2 Select the type of document to open such as Word Processing or Drawing and then Click OK Note To create a document without the default stationery settings select a standard document type such as Standard Word Processing from the scrolling list in the New Document dialog box ey In the Help index see gt statio
145. ent type values for the percentage to enlarge or reduce the selection and then click OK LE E mert w E When you finish resizing or turning click outside the selection rectangle Coloring and tinting images To refine an image s color select the area you want to change and then choose a command from the Transform menu To Choose La ac u SS Example before and after In the Help index see Fill the selected part ofan Fill or click gt transforming a gradient image or fill an image thatis on the Default already partly filled as with button bar amp Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Replacing images In the Help index see gt picking up attributes Background To Reverse the colors in a selection to make a negative image Painting 6 11 Choose Example before and after Invert or click on the Default button bar Blend the edges of an image Blend or click a with the background color on the Default button bar Tint the color in a selection Tint or click with the current fill color on the Default button bar Lighten or darken each pixel in a selection Lighter or Darker or click or on the Default button bar When you finish coloring and tinting click outside the selection rectangle To replace the colors and patterns of one im
146. enu From the Size pop up menu choose an envelope setting and an orientation landscape for standard business envelopes and then click OK To create the envelope stationery click the text tool A click in the document where you want the beginning of the sending address to go and then type an address or placeholder text Be sure to press Enter at the end of every line of text You may have to resize the address by dragging its handles Repeat to place text for the return address RETURN ADDRESS Address text frame PENDING ADDRESS AIR MAIL K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 9 24 AppleWorks 5 User s Manual Choose SaveAs from the File menu and save the document as stationery See Saving document formatting as templates stationery on page 2 10 for more information Addressing an envelope To address an envelope choose New from the File menu select Use Assistant or Stationery and a category from the Category pop up menu and then choose your envelope stationery Double click the sending address text frame and type the address you want to use Repeat for the return address text frame In the Help index see gt envelopes gt stationery using Insert the envelope into your printer and then print the envelope stationery document You can also print addresses from a database document using mail
147. er __sy Opaque QuickTime Options Transparent j a Simultaneous gi Hidden g vancing To end show press q Type q to end the slide show Cancel QuickTime movie options Select To do this Fit to screen Fit the entire slide within the boundaries of the screen Center Center the slide vertically and horizontally within the screen Show cursor Show the arrow pointer during the slide show You can move the pointer around when each slide is displayed Background Select the background color or texture for the slide Border Select the color or texture displayed around the slide Loop Repeat the slide show continuously until you stop it by pressing q Advance every number seconds Automatically advance to the next slide after the specified number of seconds Auto play Make a movie play automatically when it is displayed on a slide Simultaneous Make all QuickTime movies play simultaneously when Auto play is selected and more than one movie appears on a slide Complete play before advancing Display the current slide until the movie has finished Beyond the basics 9 19 Reordering slides Once you ve created a slide show you can reorder the slides To change the order of your slides choose Slide Show from the Window menu In the Slide Show dialog box drag a slide up or down The pointer changes to a double arrow Showing the slide
148. er of the page you want and then click OK If you gt going to a page don t see the page indicator choose Page View from the Window menu 100 Page 1 4 Page indicator Using the tool panel The tool panel contains icons that represent the tools used to work in In the Help index see AppleWorks You use these tools to paint images draw objects and frames gt tools a special type of object and change the appearance of objects and frames For more information on frames see the next section Use the arrow pointer to select move and reshape Use the text tool to create objects and frames text frames and type text Use the spreadsheet tool to Use the paint tool to create create spreadsheet frames paint frames Use the drawing tools to draw objects in documents and frames Use the painting and drawing tools to paint images in a paint document or frame Fill sample Use the fill sample and palettes to select the fill color pattern gradient or texture for objects and images Pen sample Use the pen sample and palettes to select attributes for lines and borders of objects and images If you don t see the tool panel click the show hide tools control or choose Show Tools from the Window menu Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Basics 3 5 Using the button bar When you open an AppleWorks docume
149. ers of the entry Double click the entry and then double click a topic 11 10 AppleWorks 5 User s Manual Working with electronic mail In the Help index see gt email With AppleWorks you can send and receive email messages to and from many types of computers and mail systems locally or in remote locations You can work with electronic mail on the Internet or over a different computer network To work with electronic mail you must have the appropriate hardware such as a modem and phone line In addition your computer must be connected to an Internet service provider or another network that provides electronic mail services You also need Microsoft Exchange an application that comes with Windows For more information about sending and receiving electronic mail see onscreen Help In addition see the documentation that comes with your computer browser Internet service provider and operating system software Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Index Symbols error 7 24 e in spreadsheet cells 7 22 A Absolute references 7 22 Active cell 7 3 7 25 Address Envelope Assistant 9 22 Address labels See Labels Address List Assistant 2 5 Address cell 7 6 Addresses and names list 2 5 8 6 Addressing envelopes 2 5 9 22 Airbrush Spray can 6 5 Aligning data in cells 7 10 fields 8 33 fields 8 3
150. ert an OLE object into an AppleWorks document what you can do with the object depends on the type of object and its server application To work with an OLE object select the object and choose Object from the server application s Edit menu the name of the command varies depending on the server application The Object command s submenu contains additional commands for working with the selected object For further information about working with OLE objects see onscreen Help For information on In the Help index see Opening editing and deleting OLE objects OLE objects editing gt OLE objects deleting Making a copy of an OLE object by OLE objects drag and drop dragging it to or from another document another application or the desktop Deleting a linked object and replacing it OLE objects replacing with another linked object Setting when changes are updated in gt OLE objects updating linked objects Setting the display of OLE objects gt OLE objects editing Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Chapter 10 Communications This chapter explains how to use AppleWorks and the HyperTerminal application to establish communication between your computer and another computer All communications features are described in the onscreen Help system of the HyperTerminal application When to use a commu
151. ery To use stationery a template with preformatted settings and options choose New from the File menu and then select Use Assistant or Stationery Choose a category from the pop up menu and then select a stationery name from the scrolling list For information about setting up stationery see Saving document formatting as templates stationery on page 2 10 In the Help index see gt stationery using K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 2 6 AppleWorks 5 User s Manual A cared Le i EEL Preece C Creis H H Eveni Bige env Dnes Select a stationery document f Eveni Bahad Daish E manhta Sione i Everi Bohsia Dh E agih S Larda A description for the currently Aaa Fei a ariki khi kg baver ad bedir bed ep pE Fal selected stationery appears here EOL EOE Le m Use stationery to create a document using a template such as a letterhead an envelope or a fax cover sheet that you customize for your own use AA HN a The Soccer Company Specials Kree pods 2500 Arm pods 7 Pool as oe 2750 FA tos e The Soccer Company Creating opening and printing documents 2 7 Saving a document When you finish working with a document you save it to retain all your In the Help index see changes You can also save text draw objects paint images formatting and gt saving
152. ery can contain text draw objects paint images formatting and other options you routinely use There are two ways to set up stationery in AppleWorks regular and default Setting up regular stationery In the Help index see gt stationery creating If you plan to reuse the same combinations of text objects or settings you can create templates called regular stationery for specific uses For example you might want to create regular stationery for your letterhead or a newsletter You can set up regular stationery to open from the New Document dialog box or from the Open dialog box Stationery set up to open from the New Document dialog box can be organized into categories to make it easier to find To assign a category to a regular stationery document 1 Choose Document Summary from the File menu 2 Type a brief label in the Category box and enter any other summary information you want to save with the stationery If you don t provide a category label AppleWorks assigns the stationery document to the None category Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Creating opening and printing documents 2 11 3 Click OK Your label shows in the Category pop up menu in the New Document dialog box click UseAssistantor Stationery to see the Category pop up menu For more information about entering document summary
153. eselect pop up menus on the button bar options Tip To move a button to a new location on the button bar hold down Ctrl Alt and drag the icon to where you want it Adding and removing buttons In the Help index see gt buttons To add or remove buttons choose Edit Button Bars from the M menu on the button bar In the Edit Button Bars dialog box choose the name of the button bar you want to edit and then click Modify In the dialog box add and remove buttons and then click OK Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Basics 3 7 Select a category from which you want to add or remove buttons Edit Default Button Bar Button Category General Description 53 Pai i J FE MT Double click a button to E z u 2j 5 5 Ic Creates a word processing add it to the button bar B g z Ss jee 5 al Serius Boa ala Sl 5 ol oI Remove Shows a brief description of the button s purpose when you click a button New Word Processing Document Select a button to add or remove and then click to add or remove the selected button Note The buttons you see in the button bar depend on the type of document or frame you re working in For example you see the button for rotating objects 90 degrees only when you re working in a paint document or frame Creating your own button ba
154. estore the record Temporarily delete a record Click J on the Default button bar or choose Cut from the Edit that you want to move or menu Keep in mind that if any other records or text are copied paste back in later or cut in the meantime the record is lost Moving through records In the Help index see gt databases using Use the record book to move or browse through records Start by choosing Browse or List from the Layout menu K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 8 16 AppleWorks 5 User s Manual Click to go to the previous record Click to go to the next record Viewing records In the Help index see gt records viewing Drag to move across many records at once Click here type the number of the record to go to and then press Enter To go to the same field in the next record press Ctrl j To go to the same field in the previous record press Ctrl 7 You can view records in various ways to suit your needs To Do this Example View records ina Select Browse from the Layout Continent Europe continuous list menu and then choose Country France Show Multiple If Show Multiple is PRE ER Asia dimmed deselect Page View Contry Japan from the Window menu first Records Continent South America Uesi Country Brazil View records in Select List from the
155. ex Help topics Getting help What s new AppleWorks basics Text QQ Drawing e Overview Drawing tools and palettes Ne Double click a book icon to see alist of subtopics A 2 Select objects and frames 2 Delete objects Copy and paste objects Duplicate objects Group objects Double click a topic you want to see Lock objects Arrange objects xl PEELS Print Cancel Navigating AppleWorks Help When you select a topic you see the AppleWorks Help window To navigate AppleWorks Help click buttons and underlined text Introduction 1 5 Click to retrace your Click to print the current topic path through Help Click to minimize onscreen Help and le amp AppleWorks Help Click to see the index Click to see the table of contents Click to move to the next or previous related topic Click dotted text to see a definition The tools for drawing objects are in the tool panel If you dont see the tool panel choose Show Tools from the Window menu The drawing draw solid black lines one point wide Objects have a white fill color To draw an object click a tool and drag the crosshair pointer in the drawing area Release the mouse button when the object is the size you want To use a tool repeatedly double click the tool You can draw shapes of that type until you click another tool Click an underlined title for more information on draw
156. ex from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Chapter 5 Drawing This chapter describes what you can do with the AppleWorks drawing tools All draw features including procedures shortcuts and troubleshooting are described completely in onscreen Help When to use a drawing Use a drawing whenever you want to create simple shapes such as rectangles circles lines and polygons You can combine these simple shapes to create designs such as a map or a quick sketch in any type of document except a communications document You don t need to create a frame first Consider using a draw document for large drawings or for designing or laying out a page For example you can create layouts for newsletters brochures and announcements design a logo or letterhead create professional looking forms such as invoices and project planning sheets design a border or background and create a master page to place the border or background on every page of a presentation make flowcharts or seating and organizational charts illustrate floor plans and furniture arrangements Main Street Elm Street t Combine lines text frames and ready made pictures to create a simple map Belvedere Avenue Chestnut Street 5 2 AppleWorks 5 User s Manual Drawing basics You use the same tools and commands any time you work with the drawing tools
157. f the entry Double click the entry and then double click a topic 9 2 AppleWorks 5 User s Manual Creating book marks Tip To create a book mark quickly select the text object cell frame or paint image Then click J on the Default button bar Type a name for the book mark and click OK To create a book mark 1 Select the text object cell frame or paint image in which to place the In the Help index see bookmark gt book mark oo ae 2 Choose Show Links Palette from the Window menu 3 Choose Book Marks from the pop up menu on the links palette Links Special Choose the type of fecactiaus J link to create GEN Chapter 4 synopsis 4 Ifyou want to create a folder for book marks choose New Folder from the Special menu on the links palette type a name for the folder and then click OK 5 Choose New Book Mark from the Links menu on the links palette 6 In the New Book Mark dialog box type a name for the book mark select a folder from the pop up menu if you want and then click OK Choose from the links palette menus List of links for the current document To go to a book mark you created see Going to a specific link on page 9 4 Creating document links You can create a link a connection or jump from text a spreadsheet cell In the Help index see paint image frame or object such as a graphic object in a drawing to a gt links different document gt URL
158. fferent from other AppleWorks documents It uses the HyperTerminal application to connect your computer to an online information service a bulletin board or another computer ze HyperTerminal File Edit View Call Transfer Help Ole el3 cls l Communications menus and button bar Sysop The database can give you immediate answers to questions technical notes offer product hints and tips and more and added more records of information to our online sear A Windows HyperTerminal document With a communications document you can connect to a remote computer and receive send and save data For information on HyperTerminal see chapter 10 Communications and the HyperTerminal documentation that comes with your computer 1 14 AppleWorks 5 User s Manual Where to go from here Now you re ready to start AppleWorks and create some documents of your own If you haven t looked over the section How to start on page 1 1 do so now It shows you how to use the User s Manual and the onscreen Help system together to find information Then go to Starting AppleWorks on page 2 1 Chapter 2 Creating opening and printing documents In the Help index see gt Help finding This chapter provides basic information about using AppleWorks that in general applies to all document types These topics are covered starting and stopping AppleWorks creating and saving documents printing d
159. gt stationery settings in stationery templates that you can later reuse See Saving document formatting as templates stationery on page 2 10 To save a document click on the Default button bar or choose Save or Save As from the File menu Choose Save to save changes to a document you ve previously saved Choose SaveAs to save another version of a document with a new name in a different format or in a separate location You see the Save As dialog box any time you choose Save As from the File menu In the Save As dialog box type a name for the document and then click Save See all your Move up one level in the folder hierarchy folders and drives Create a new folder in the selected folder or drive Currently open folder Show or hide file and folder details Contents of the selected folder or drive double click a folder to make it the selected location Click to save the document Type anew name for the E document File name untitled cwk Save as type AppleWorks cwk RS Cancel Choose a file format If you try to save a document with the same name as another document in the same folder you see a message asking if you want to replace the existing document with the current document K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 2 8 AppleWorks 5 User s Manual After you save a document for
160. h as 4 95 Ms Jane Smith or February 2 1997 operators such as gt or cell references such as B2 P66 or D7 functions such as SUM B2 N66 or PRODUCT A1 C1 named ranges Formulas can be simple or very complex with many parts All of these are legitimate and simple formulas This formula Does this B6 B8 Adds the values in cells B6 and B8 E9 3 5 Multiplies the value in cell E9 by 3 5 a constant fixed value that you supply Shares Price Multiplies the values in two named cells see Naming cells and ranges on page 7 12 California Places a text constant California in a cell SUM D4 D12 Uses the SUM function a predefined formula to add the values in the cell range D4 to D12 See Working with functions on page 7 26 for more information on functions K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 7 22 AppleWorks 5 User s Manual Cell references in formulas In the Help index see gt cells references Circular reference A formula can contain references to a cell or a range of cells AppleWorks uses the data in the cells to compute the formula s result There are two types of references relative and absolute A relative reference gives the location of a cell relative to the location of the current cell If you copy and paste a formula with a
161. he Arrange menu Click an anchor point on the curve to change and drag either end of the control handle Then choose Reshape again Control handle rap om Anchor point Smooth out or restore sharp angles of a polygon bezigon or freehand shape Smooth or Unsmooth from the Edit menu SF SF When you want to make an intricate design with many curves or angles you can connect a series of shapes You can connect any combination of freehand shapes polygons regular polygons and bezigons K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 5 14 AppleWorks 5 User s Manual Start by creating the two objects you want to connect Then select one of the objects and choose Reshape from the Arrange menu You see anchor points on the object and the reshape pointer Anchor point Reshape pointer Ly Objects to be connected Choose Cut or Copy from Example To the Edit menu and then before and after Connect the end of one Select the second object and click ye object to the start of another on the Default button bar or at eh In the Help index see choose Paste from the Edit menu 7 gt connecting objects Then choose Reshape again Connect the starting points Select the starting point Gj the of two objects second object and click fe on the ye oe Default button bar or choose Paste O7 from th
162. he bottom of the parts of a window and then drag the bar document atone to a new position Drag down time Drag right Restore a split Double click the vertical or window horizontal line between the panes 1000 October November December Double click to restore the window Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Basics 3 3 Arranging windows In the Help index see gt Cascade command AppleWorks can tile or cascade open document windows so they are arranged neatly on the screen To Do this Example Tile windows in a grid Click on the TT Default button bar 2 00 2 20 2 2 lm 924 1 I ETE EEE i or choose Tile from ros the Window menu Cascade layer windows Choose Cascade from the Window menu Arrange minimized Choose Arrange Icons AppleWorks documents from the Window neatly at the bottom of the menu AppleWorks window Arranged icons Tip To bring a document to the front choose its name from the Window menu x Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 3 4 AppleWorks 5 User s Manual Going to a page To go directly to a page double click the page indicator at the bottom of the In the Help index see window type the numb
163. hyphen or current time in a time field Enter a date time or number Type numerals and punctuation characters Enter a name in a name field For names that you want to sort by the last word in the field type the first and last name for example Jane Adams sorts by Adams For names that end with a title type Ctrl space between the last name and the title for example James Smith Jr sorts by Smith For names that you want to sort by the first word in the field type at the beginning of the field for example Treetop Books sorts by Treetop You see the symbol only when you select the field 8 14 AppleWorks 5 User s Manual To Do this Enter a picture or movie in a Use one of the following methods multimedia field Copy and paste a picture or movie from a different document Choose Inset from the File menu and then select the picture or movie file using the Insert dialog box Add an object from a library palette m Choose OLE Options from the Edit menu and then choose Insert OLE Object When a field contains a picture you see the picture in the field When the field contains a movie you see a preview image of the movie To play a movie see Playing movies in multimedia fields on page 8 17 Choose a value from a Select the field to see the predefined list Then predefined list double click a value or select the value and press Enter on the numeric keypad Adding record
164. i ji A R A consectetuer consectetuer consectetuer 123 9 corsectetuer 12 nonummy nonummy nonummy 15 nonurmmy 4 magna magna magna 23 8 To set the fill character double click the tab marker Indenting paragraphs In the Help index see gt indentation To change the indentation for a paragraph position the insertion point in the paragraph and drag the first line indent marker 7 left margin marker Q or right margin marker a to a new position on the text ruler 1 7 2 1 V 2 Yi 2 Lorem ipsum dolor si Lorem ipsum dola euismod tincidunt ut euismod tincidunt Ut wisi enim adm nisl ut aliquip ex Duis autem vel eu Duis autem vel eum i Duis autem vel eu aliquip ex ea comr aliquip ex ea commo aliquip ex ea comr To indent the first line of a To indent a paragraph drag To make a hanging indent paragraph drag the first the left margin marker grab drag the left margin marker line indent marker the bottom part only grab the top part only K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Text word processing 4 11 Tip for hanging indents After setting up your tabs you can set apart hanging indents by typing a character such as a number or bullet in the margin to the left of the paragraph To type a bullet hold down Alt and then type 0149 on the keypad Press Tab and then begin typing the paragraph To typ
165. ie Edt File Edt Footnote Index a Bold Italic Body Default SS Base Style None Then click to apply a Z Bulet Footnote In Para tet Line Indent O in f preset style Checklist Paragraph Para Left indent 0 5 in Properties of Para Topic Label Bulet the style Bullet Default Body Footer Bullet Footnote Checklist Header Defaut To see a style s properties click Edit and then select the style K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 4 10 AppleWorks 5 User s Manual Setting and changing tabs In the Help index see gt tabbing Use tabs when you create tables or need to control how text aligns lines up in a document The text ruler has preset left tabs every one half inch Preset tabs do not appear on the ruler You can move the tabs to different locations remove tabs add tabs and use different tab alignments When you set tabs any preset tabs to the right of the tabs you set remain effective To set tabs select all the paragraphs you want to change Then click the type of tab marker you want and then click a position on the text ruler To remove a tab drag the tab marker up and off the ruler Click one of these tab markers and drag to the ruler position you want Right tab marker with Left tab marker Center tab marker Align on tab marker fill character Ga es Sem ses eso o Yi 2 3 4 5 6 7 A
166. ield s format in one step you can create styles combinations of formatting information For example create a style called Highlight and then apply it to selected fields objects when you re working in Layout mode When you change a style all the fields with the same style also change To create styles click s on the Default button bar or choose Show Stylesheet from the Window menu For more information see Using styles on page 9 5 8 34 AppleWorks 5 User s Manual Price Price In Layout mode select File Edit File Edit the fields to change Total Then click to es Hianilaht lt Basic Styles Properties Before apply a style Default SS Base Style None you created Bullet Highlight Obj Pen Size None Checklist vy Paragraph Obj Fill Color 7 Price Price Default Body Bullet a ee Footer Checklist Default Total Total Highlighted field UA in Layout mode Nuaber Price 10 95 Price 12 95 yal PEET To see astyle s properties Properties of the style Total 23 90 Highlighted field in click the Edit button and Highlight After Browse mode select the style Presenting and summarizing data with parts You use database parts to present and summarize data on the screen and In the Help index see when printed A standard layout has one part a body which contains the gt layouts parts for data from all current records Other parts you can a
167. iewing empty frames Empty linked text frames do not show when you are adding new ones You can add a border by selecting the frame and choosing a width from the pen width palette Working with movies In the Help index see gt movies in documents If you have QuickTime or Microsoft Video for Windows AVT installed in your system you can add movies to your documents play them on the screen and make simple changes You can work with movies in word processing draw and spreadsheet documents and in multimedia fields and Layout mode of a database document Choose Index from the Help menu and scroll to the entry Double click the entry and then double click a topic Beyond the basics 9 27 Adding a movie to a document You can import insert or paste a movie into any document type except communications and into a multimedia field in a database document See Importing and exporting documents on page 2 15 for more information Movies appear in the document as a picture with a control badge in the lower left corner Note In a word processing document the QuickTime movie control bar is not available when the movie has been inserted or pasted as an inline object in text To play a movie inserted this way double click the movie frame To stop the movie single click the movie frame To make the movie control bar available in a word processing document insert the movie as an object select the arrow pointer and ch
168. in the document or frame choose Copy from the Edit menu Cut Select the text object or Removes the selected text object or image to cut and click on image from a document or frame and the Default button bar or places it on the Clipboard choose Cut from the Edit menu Paste Position the insertion point Places the cut or copied text object or where you want to place the image at the insertion point or the last cut or copied text object or place you clicked image and click on the Default button bar or choose Paste from the Edit menu Note You can t paste objects into a spreadsheet cell In a database document you can paste objects only in Layout mode or into a multimedia field Changing your mind If you make a mistake or change your mind while you re working in AppleWorks you can undo the latest change or go back to the last saved version of your document To Do this Undo your most recent action Click on the Default button bar or choose Undo from the Edit menu Remove all the changes you ve Choose Revet from the File menu made since you last saved the document Basics 3 11 Previewing pages for printing You can preview a document on the screen in page view before actually In the Help index see printing it In page view you see the margins headers footers and page gt pages viewing numbers if there are any gt Show Margins command For information on printing a document se
169. ind Only records that contain a specific value In Find mode do this in the find request Type or select the value Example Restaurant Type City Avg Price E Reviewed Finds the Italian restaurants Only records that contain a set of specific values Type or select the set of values Restaurant Type City Avg Price Reviewed Finds the Italian restaurants that have been reviewed All records that contain one or the other set of values Type or select the first value or set of values and then choose New Request from the Edit menu Enter another value or set of values in the new find request Restaurant Type City Avg Price E Reviewed Restaurant Type Dort Care Care City Calistoga Avg Price CO Reviewed Finds the Italian restaurants and any restaurant in Calistoga All records that do not contain a specific value Type lt gt before the value to find records not including empty fields Or type or select the value and then click the Omit box to find all records including ones with empty fields Restaurant Avg Price El Reviewed Finds all restaurants not in Napa Records with a value less than a specific number Type lt before the value Restaurant Type City El Reviewed Avg Price Finds restaurants with average meal prices less than 10 Choose Index from the Help menu and type the first few letters of the entry Double click the
170. indow The open frame is linked to the original document Any changes you make in the open frame are also made in the document To close the spreadsheet frame choose Close from the File menu Resize a spreadsheet frame to display more cells Select the frame and then drag a handle Adding borders colors and pattems to cells You can add borders colors and patterns to one or more cells or to entire In the Help index see gt borders spreadsheet cells gt spreadsheets formatting gt styles rows or columns To add a border color or pattern start by selecting the cells rows or columns you want to change If you need to use the tool panel choose Show Tools from the Window menu To Do this Add a border Choose Borders from the Format menu select border options and then click OK Or click one of the border buttons on the Default button bar Choose a color from the pen color palette on the tool panel Remove a border Choose Borders from the Format menu deselect border options and then click OK Or click the border button again Change acell s border Select a bordered cell and then choose a color from the pen color color palette on the tool panel Fill cells with color Click a cell and choose from the fill color and pattern palettes on or pattern the tool panel Textures and gradients cannot be added to cells Choose Index from the Help menu and type the first few letters of the entry
171. information see Identifying your documents on page 2 13 Setting up default stationery In the Help index see gt stationery creating If you plan to use certain settings every time you create a document set up a document as default stationery or Options stationery that opens automatically whenever you create a new document of that type For example you might want to change the default font used in a new word processing document Creating stationery In the Help index see gt stationery creating a In the Help index see gt documents creating To create a stationery document prepare a document with the settings and information you want to save as stationery and then follow these steps to save the document 1 Choose Save As from the File menu 2 In the Save as dialog box type a name for the document in the File name box If you re setting up default stationery there are specific naming conventions you must use For this document type Use this filename Word processing WPOPTION CWS Draw DROPTION CWS Paint PTOPTION CWS Spreadsheet SSOPTION CWS Database DBOPTION CWS a If you re setting up regular stationery you can save the document as any name It s best to give regular stationery a name that you can easily identify later such as Letterhead 3 From the Save as type pop up menu choose AppleWorks Stationery cws AppleWorks adds the CWS extension to the fil
172. information see the documentation that comes with your computer Open a document created by Choose Open from the File menu choose Show All Files AppleWorks for Mac OS from the Files of type pop up menu choose the document software and then click Open If you re asked for a password type the password and then click OK In the Open dialog box you can search for a document and choose the type of document you want to open Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Selected folder or drive Contents of the selected folder or drive double click a folder to select it Type the name of the document to open or double click its icon Finding documents Creating opening and printing documents 2 9 Choose a folder or disk to see Move up one level in the folder hierarchy documents and folders in that location Create a new folder in the selected folder or drive Show or hide file and folder details Choose the file type for the document to open such as GIF Files of type Show all files Document Type All Types z Choose the type of document to open such as Painting When you need help locating a document on your computer or in your computer system when you have external drives use the Find AppleWorks Documents Assistant For more information see Using an Assistan
173. ing you may want to work with Auto Calc off To calculate formula results when Auto Calc is off choose Calculate Now from the Calculate menu Making corrections In the Help index see gt formulas spreadsheet gt resizing spreadsheet cells gt troubleshooting If you see in a cell it means the column is too narrow to display the number To widen the column select the column and then increase its width by choosing Column Width from the Format menu Type a width and then click OK For more information on changing the size of a column see Resizing or hiding rows and columns on page 7 16 Before After Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Error messages Spreadsheet 7 25 AppleWorks tells you if it can t evaluate a formula you ve entered Error messages start with the symbol and end with an exclamation point or you may see a message on the screen Check your formula for the correct placement of parentheses be sure parentheses are correctly paired and check to see that you have entered operators between the cell references For more spreadsheet and formula tips see onscreen Help Examples Entering formulas Entry bar These examples show how to use formulas to add numbers Example 1 Simple arithmetic To enter a formula that sums three numbers 1 Click a cell to make it active 2 T
174. ing 6 7 Stylesheet x Edit Style x File Edit File Edit Create a style and then select it v Checked Fill Bord Checked Fill Base Style None to change the palette settings Red FWalue boder Defaut 88 Obj Pen Size None Default Red Fill Blu Obj FillCobr E gt Paragraph Obj Fill Pattern Mamaman Default gt Outline Sties i b Table Sties Bi To see astyle s properties click Properties of the style Edit and then select the style Checked Fill Borderless You can customize palettes by editing the colors patterns gradients and textures You can also load new color palettes See Creating custom colors patterns gradients and textures on page 5 18 Selecting and moving images Before you can change an image you must first select it In the Help index see gt images arranging To select Do this Example A rectangular area Click the selection rectangle and drag it over the area to select You can select all a or part of an image The outline of an image Hold down Ctrl as you drag the selection rectangle around the image you want to select Everything in the document Double click the selection rectangle E3 An irregular shape without Click the lasso and drag it around the selecting the surrounding area you want to select The loop closes white space automatically By color when you want to Click the magic wand and click an select shapes that are difficult area AppleWorks selects all
175. ing a specific shape Lines Y Rectangles and squhres Click underlined text to 5 wre re pe e jump to atopic or see a Rounded rectangles list of related topics Ss Ovals and circles hal Tip To see a sequential list of topics you ve viewed choose Display History Window from the Help window s Options menu Using the onscreen Help index To browse through the index click the button in the AppleWorks Help window or the Index tab in the Contents window and then scroll through the alphabetical list To go to a specific index entry for example if you re using the index entry in this manual to direct you to a topic in Help type the first few letters of the entry To see one screen of entries at a time press Page Up or Page Down 1 6 AppleWorks 5 User s Manual EEE ae You see this in the User s van In the Help index see gt frames Help Topics AppleWorks Help Contents Index Find 1 Type the first few letters of the word you re looking for Type all or part of framed the index entry 2 Click the index entry you want and then click Display Frame Links command Then double click the entry to select it creating formatting linking shortcuts tools working in Free Rotate command Topics Found BE Click a topic then click Display About documents and frames About frames You see a list of topics if there s only one topic for that entry
176. ing document choose Deine Fields from the Layout menu When you create new fields AppleWorks automatically adds them to the layout you have chosen Assigning field types To assign a field type to a field choose from the Field Type pop up menu in In the Help index see the Define Database Fields dialog box Field types affect the way you enter gt fields types and use your data Tip Use a text field or a field that holds text such as a pop up menu for postal codes so you can sort addresses by postal code number If the postal code is anumber field AppleWorks ignores leading zeros As text the codes are sorted properly and retain any leading zeros K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 8 8 AppleWorks 5 User s Manual Important The examples in this documentation are based on U S conventions and are shown in U S formats In English speaking countries other than the United States numbers dates times functions formulas and calculations might be formatted differently For example in the U S periods act as decimal points In other countries commas might be used as decimal points Use this field type To Example in Browse mode Text Enter any text numbers or symbols up to First name Luis amp Julia 1008 characters depending on custom Address 165 Belvedere Ave styles such as italic assig
177. ing resolution and depth Working with large files Changing the size of a painting Contents VII 5 11 5 12 5 13 5 13 5 15 5 16 5 17 5 18 5 18 5 19 5 19 5 21 6 1 6 2 6 3 6 3 6 4 6 4 6 6 6 7 6 9 6 9 6 9 6 10 6 10 6 11 6 12 6 13 6 13 6 13 6 14 Vill AppleWorks 5 User s Manual Creating links in paint documents Chapter 7 Spreadsheet When to use a spreadsheet Spreadsheet basics Creating a spreadsheet About the spreadsheet window Working with spreadsheet frames Typing in a spreadsheet Selecting cells and ranges Modifying cell data Editing data Moving data Copying and deleting data Filling a range of cells Formatting cell data Sorting cell data Locking cell data Naming cells and ranges Assigning names to cells Editing and deleting names Using named cells in formulas Replacing cell references with named cells Example 1 Using cell names in a formula Example 2 Replacing named cells with cell references Changing cells rows and columns Resizing or hiding rows and columns Inserting and deleting cells rows and columns Changing the number of rows and columns Adding borders colors and patterns to cells Locking row and column titles Adding and removing page breaks Changing the display Printing a spreadsheet document Working with formulas 7 1 7 2 7 3 7 3 7 4 7 5 7 5 7 6 7 6 7 7 7 8 7 8 7 9 7 11 7 12 7 12 7 13 7 13 7 14 7 14 7 15 7 16 7 16 7 16 7 1
178. ink dialog box make your changes and then click OK Deleting links In the Help index see gt links When you delete a book mark or document link using the Links menu in the links palette the part of the document containing the book mark or link is not deleted To delete a link 1 Open the document containing the book mark or link to delete 2 Choose Show Links Palette from the Window menu 3 From the pop up menu on the links palette choose the type of link to delete 4 Click the name of the book mark or link to delete If a link you want to delete is in a folder click the triangle to open the folder and then click the link name 5 Choose Delete Link for the selected link type from the Links menu If you select part of a document that contains a link and then delete the selection the links are also deleted Going to a specific link In the Help index see gt links To go to the location of a specific book mark or link within a document 1 Open the document containing the book mark or link to go to 2 Choose Show Links Palette from the Window menu 3 From the pop up menu on the links palette choose the type of link to go to 4 Click the name in the list and then choose Go to Link for the selected link type from the Links menu If a link you want is in a folder open the folder by clicking the triangle next to the folder name and then click the link name Choose Index from the
179. ion or refining its color Reshaping a selection In the Help index see gt transforming To reshape a selection select the area you want to change choose a command from the Transform menu and then drag the handles that appear To Select the area and choose Example Slant an image vertically or horizontally Shear Stretch an image in any direction Distort E Add the appearance of depth or distance Perspective When you finish reshaping click anywhere outside the selection rectangle K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 6 10 AppleWorks 5 User s Manual Resizing or tuming a selection To resize or turn a selection select the area you want to change and then choose a command from the Transform menu To e In the Help index see gt transforming Rotate an image freely Select the area and choose Free Rotate and then drag a handle to the degree of rotation you want Example Rotate an image by a set amount Rotate type a value for the degree of rotation and then click OK 7 Rotate an image by 90 on the Default button bar Flip an image horizontally or vertically Flip Horizontally or Flip Vertically Resize an image by dragging a handle Resize an image by specifying a set percentage Resize and then drag a handle to the size you want Scale By Perc
180. ions You can place the section number in a header or footer and have it print on every page of the section Doing so is useful if a section represents a chapter in a book and you want to show chapter and page numbers For example you can show In the Help index see gt Insert Page command a asection number by itself Chapter 3 Chapter 4 or with the current page number Page 3 11 Page 3 12 a page number within a section Page 1 of 10 and Page 2 of 10 where there are ten pages in the section the total number of pages in a section This chapter contains 32 pages K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 4 26 AppleWorks 5 User s Manual To insert the section number the page number or the total number of pages in the section or document choose Inset Page from the Edit menu Then select an option in the Insert Page Number dialog box To assign letters or Roman numerals instead of numbers to a section select an option from the Representation pop up menu Adding footnotes and endnotes In the Help index see gt footnotes In the Help index see gt Assistants Annotate your documents with footnotes notes at the bottom of a page or endnotes notes at the end of a document To add footnotes or endnotes to a document place the insertion point where you want
181. isible and drag the pointer in the document In a spreadsheet document hold down Option as you draw the A spreadsheet frame in a frame word processing document About the spreadsheet window When you create a spreadsheet document or frame you see the spreadsheet In the Help index see menus and the entry bar in the spreadsheet gt spreadsheets documents Spreadsheet menus File Edit Format Calculate Options Window Help 18 x Buttons for common 2 2 By BY 2 3 S SI 22 88 3 2 8 CG Gl BY 7 Ul 7s Bl al Se ae Se OEE documents or frames Entry bar _ headi Active cell Column headings Function button Cell grid Row headings Cell K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 7 4 AppleWorks 5 User s Manual Working with spreadsheet frames A spreadsheet frame provides a view into a spreadsheet A spreadsheet frame In the Help index see is like any other object You can move it resize it change or delete the gt frames creating border apply a fill color or wrap text around it Within a frame you have gt frames working in full access to the spreadsheet tools and commands To work inside the spreadsheet frame select the frame and then click to select the cell ba ie a EEEE To select the
182. itle and E Germination rate legend borders Change the data series symbol to a 3 point line Italicize the text Paste a picture into along the axes 20 1 the spreadsheet and 1 i mies rate saad drag the picture over the chart 7 32 AppleWorks 5 User s Manual SSS SS SS Se et In the Help index see gt charts creating gt charts formatting Choose Show Tools from the Window menu to display the tool panel then try some of the following techniques using the fill and pen palettes For information on using the pen and fill palettes see Changing lines borders colors patterns and textures on page 5 9 The effect you achieve varies with the type of chart Feel free to experiment If you don t like the results use Undo in the Edit menu or Revert in the File menu or delete the chart and make a new one To Select the chart or chart element and then Change the background of Choose from the fill color pattern texture or the chart title or legend gradient palettes Change the chart legend or title Choose from the pen color pattern and width border or the axis line palettes Hide the chart legend or title border Choose None from the pen width palette or the axis line Change the appearance of text Choose Font Size Style or Text Color from the Format along an axis menu and options from the submenu or use the pop up menus on the button bar Change the color pattern
183. ize documents To change the size of a painting choose Document from the Format menu In the Document dialog box type values for Pixels Across and Pixels Down and then click OK Tip Ina new paint document 72 pixels equals 1 inch To change the number of pixels per inch see Customizing resolution and depth on page 6 13 Creating links in paint documents In the Help index see gt book marks gt links When you plan to use an AppleWorks paint document or a document that contains a paint frame onscreen on the Internet or World Wide Web you can select an area of the document or frame and create a link a connection or jump to a different area of the same document a different document or a document or other information on the Internet To create a link in a paint document or frame use the lasso to select the area and then create the link For more information see Creating links on page 9 1 To create a link to information on the Internet see Linking Web pages on page 11 5 Note If you move the pixels in the area you selected the link remains with the area in the document or frame and does not move with the pixels amp Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Chapter 7 Spreadsheet This chapter describes what you can do with an AppleWorks spreadsheet document or spreadsheet frame All spreadsheet fea
184. ke your changes To view other chart options click the Gallery Axes Series Labels and General buttons and choose among the options that appear When you re satisfied with the chart click OK Use this option in the Chart Options dialog box To set or change Gallery Chart type Axes Label scale and tick marks on an axis Series Format and symbol for the data series value Labels Position and format of the title and legend General Chart range series orientation in rows or in columns How number data if any in the top row or left column is treated plotted or used for labels Note AppleWorks provides numerous techniques for setting and changing the chart s elements You can experiment with the various techniques for working with chart elements described in onscreen Help If you don t like the results click 2J on the Default button bar or choose Undo from the Edit menu You can also choose Revert from the File menu or delete the chart and make a new one Deleting copying or moving a chart SS In the Help index see gt charts modifying A chart is an object that you can delete cut copy move or resize To start select the chart by clicking it A selected chart has handles To Select the chart and then Cut or copy a chart On the Default button bar click to cut or to copy or choose Cut or Copy from the Edit menu Cutting or copying a chart breaks its link to the chart s spreadsheet
185. ks fills the selected cells with data Formatting cell data In the Help index see gt spreadsheets gt spreadsheets formatting You can change the format of any part of your spreadsheet Start by selecting the cell cell range column or row that you want to change K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 7 10 AppleWorks 5 User s Manual You can also copy a cell s formatting or specify a default font to be used in the entire spreadsheet To Change text appearance or alignment Do this Select the cells you want to change Choose Font Size Style Text Color or Alignment from the Format menu and then choose a formatting option from the appropriate submenu or use the pop up menus and buttons on the button bar Example Centered Plain text Wrap cell contents so that long entries aren t cut off Select the cells containing the text and click on the Default button bar or choose Alignment from the Format menu and then choose Wrap To adjust the row height see Resizing or hiding rows and columns on page 7 16 Unwrapped Format numbers dates and times for example to add a percent sign place negative numbers in parentheses or add a comma to large numbers Select a cell or cell range and then choose Number from the Format menu Select the options you want an
186. l an object with a color Changing the appearance of objects on pattern gradient or texture page 5 9 Pen palettes Change the color pattern or width of a line or an object s border or add arrowheads to a line Library palette Add AppleWorks clip art toa Using libraries on page 3 17 document or store items that you want to reuse Mail merge Merge database information Merging data into documents mail palette with a word processing or merge on page 9 19 spreadsheet document or a text frame in a draw document Stylesheet Create apply and edit styles Using styles on page 9 5 palette for formatting text paragraphs spreadsheets outlines and graphic objects Links palette Create and edit links Creating links on page 9 1 document links URL links and book marks OLE Tool Edit OLE objects gt Object Linking and Embedding OLE palette in the Help index Basics 3 9 Working with frames In the Help index see gt frames tools gt frames creating In AppleWorks you can add different types of information spreadsheet data text and paint images to the same document These different types of information are stored in special objects called frames A frame is an object that acts like a window to another type of document You can draw frames in every type of document To create a frame click to select a frame tool in the tool panel position the pointer ove
187. leWorks enter cell references and functions for you To enter a formula select the cell where you want the formula s result to go and type an equal sign in the entry bar Type the formula after the equal sign you can put a space before or after any operators and then click YJ to confirm your entry Tip You can quickly total the values in selected cells and display the result in the row or column cell adjacent to the selected cells Select the cells including a blank cell to display the total and click 2 on the Default button bar 5 Select the cells to be totaled and the cell for the result To Do this Example Enter a reference to Click to select the cell that you want to refer to B1 C1 a single cell AppleWorks enters a plus sign when you click the next cell To use a different operator such as to multiply type the operator before you click B1 C1 the next cell AppleWorks inserts the cell reference at the insertion point in the formula Enter a reference to Drag to select the range that you want to refer to SUM B1 C1 a cell range The reference to the cell range appears at the insertion point in the formula Then enclose the range in parentheses Or type the addresses of the cell at the upper left of the range and the cell at the lower right with two dots between them and enclose the range in parentheses Enter an absolute Click in the entry bar before the part of the cell A 1 B 14
188. leit augue duie seer i tase molestie coceaquat vel ium dolore au oiai Irim pom r a tc a A thc pm dor a Sm fugiat uia Geils at vero aos a euma fonsestanar adipiscie it sed diam eceeaat eter adipisi sed diam justo odio dignisim quibtand praesert roca ramy rdbh euis mod tinedduct ut laoreet lnoew mmy ribh nis mod tinciduct ut iaoreet Mptabum zal delend augue dui dolre te dolore magra aliquam emt volutpat Ub wisi doira masra aliquam amt volutpat Ut wisi ugai cuth Beilisi Lorem ipeum doke sit Lenina a mim veniam quis oosid exeri A erin ad acim vera que noctud exani ammit eneasttuer adipising l lt 4 dam htro utas batis nist ut harico uthmeaper aizeipk batis ris ut tomy rdbh euie mod tine duce ut Ponta agement E A eae eee Due dolce magma aigam ent voltpal whi Atem vel an doler i bendat stem vet eum ice doke bandat in dnim ad m n uscorind aani Auputate vet assa molestie vet pweutate welt aasa molestia ccesequat vel uthmearper ui M daea Don nth Rise a vce lin dies av Evga mik Acos a yao lt xexsden commodo cerceqiat DUE autem lane at aseumaan at iuto odio Jace ok accumean 2 iito odio digedceim gui eum t ie Emesene pte zail delende hndi precare Suptabumn ail delenit View without margins and page guides Normal view showing margins and page guides To preview a draw paint database or spreadsheet document choose Page View from the Window menu K Choose Index from the Help menu and type the first
189. licate from the Edit menu C H C Space duplicates evenly After duplicating the object move it immediately to a new position The next duplicate you create appears at the same distance from the last copy Copy an object and paste it elsewhere Click on the Default button bar or choose Copy from the Edit menu Click where you want the copy to go and choose Paste from the Edit menu Delete an object permanently Press Backspace Delete an object and store it on the Clipboard Click on the Default button bar or choose Cut from the Edit menu Anything you store on the Clipboard stays there until you cut or copy something else Changing the appearance of objects Use AppleWorks to change or fine tune the appearance of objects or frames Your changes affect all selected objects Changing lines borders colors pattems and textures Use the fill palettes to change an object s color pattern gradient or texture In the Help index see gt objects modifying Fill sample Fill color palette Fill pattern palette Fill gradient palette Fill texture palette Use the pen palettes to change lines and borders of objects Pen sample 15 Pen color palette s Pen pattern palette le Arrowhead palette Pen width palette K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 5 10 AppleWorks 5 User
190. lick Open From the Book Mark pop up menu choose the name of a book mark in the selected document 7 In the New Document Link dialog box click OK To open a linked document or go to a linked area in the same document make sure Live Links is selected in the links palette and click the area indicated by the pointer Keep the following points in mind Creating links to other areas of the same document is especially useful in the design of a Web page For more information see Linking Web pages on page 11 5 When you print a document that contains links to other documents the other documents are not printed When you edit a book mark or document link using the Links menu in the links palette the contents of the document containing the book mark or link remain unchanged To edit a link 1 Open the document containing the book mark or link to edit 2 Choose Show Links Palette from the Window menu K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 9 4 AppleWorks 5 User s Manual 3 From the pop up menu on the links palette choose the type of link to edit 4 Click the name of the book mark or link to edit If a link you want is in a folder open the folder by clicking the triangle next to the folder name and then click the link name 5 Choose Edit Link for the selected link type from the Links menu 6 In the Edit L
191. lls in the calculation Filling a range of cells Ss SS SS In the Help index see gt filling cells You can copy cell contents to adjacent cells and fill cells automatically with patterns of data such as the days of the week To copy cell contents including formulas into adjacent cells drag to select the cells with the data to duplicate and continue dragging down or to the right over the cells you want to fill Then choose Fill Down or Fill Right from the Calculate menu amp Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Result of a formula Cells filled with a sequence of times Spreadsheet 7 9 gt Fill Right Selected cells AppleWorks copies the formula to the selected cells Use the Fill Special command in the Calculation menu to fill cells with a logical series of numbers times or dates a day Monday month January or quarter name Qtr 1 any pattern of text or data For example you can prepare a schedule by filling a range of cells with times and another range of cells with the days of the week To fill a range of cells with a logical series or a repeated pattern of data select the cells and then choose Fill Specia from the Calculate menu Select options and click OK For a complete description of the Fill Special command see onscreen Help Fill Special Selected cells AppleWor
192. ls rows and columns Important When you delete a cell column or row you also delete its data To insert or delete an entire row or column click one or more headings to select rows or columns and then on the Default button bar click S to insert cells or click l to delete cells You can also choose Insert Calls or Delete Cells from the Calculate menu To insert or delete a few cells make a selection before you choose Insert Cells or Delete Cells In the dialog box specify how you want existing cells to be shifted and then click OK 34 45 Select the cells to delete The cells below are shifted up f X Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 7 18 AppleWorks 5 User s Manual Changing the number of rows and columns A new spreadsheet contains 500 rows and 40 columns A new spreadsheet frame contains 50 rows and 10 columns a In the Help index see gt Document command gt frames formatting gt opening To Change the number of rows and columns in a spreadsheet Do this Choose Document from the Format menu type numbers for Columns Across and Rows Down and then click OK Open a spreadsheet frame so that you can change the number of rows and columns in the spreadsheet Select the frame and choose Open Frame from the Window menu When you open the frame you see the spreadsheet in a new w
193. lumn heading The pointer changes to this 4 Drag the column to the new position Example Pointer state 4 Postal Postal State After Change the format of a column of number date or time fields Double click the column heading choose options in the Format dialog box and then click OK Change the appearance of text in a column Double click the column heading and select options in the Text Style dialog box Or select the column and choose from the Font Style Size and Text Color pop up menus in the button bar State lt gt Postal Change the appearance of all the text fields in one or more rows Select the rows and choose from the Font Style Size and Text Color pop up menus in the button bar Your changes don t affect number date or other non text fields Customer Street Adventure Books 100 Aspen Lane Note You can change the appearance of text in a column in one step by applying a style See Using styles on page 9 5 K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 8 20 AppleWorks 5 User s Manual Selecting and hiding records You can select and hide individual records or a range of records in Browse mode or List mode Hidden records are not printed sorted or included in In the Help index see gt status panel dat
194. lying the ruler Parulerg To copy the ruler place the insertion point in a paragraph that has the formats you want and click on the Default button bar or choose Copy Ruler from the Format menu To apply the ruler place the insertion point in the paragraph you want to format and click on the Default button bar or choose Apply Ruler from the Format menu Sorting paragraphs You can use the Paragraph Sorter Assistant to sort reorder paragraphs In the Help index see alphabetically numerically or by date in a word processing document or gt Assistants text frame To sort paragraphs select the paragraphs you want to sort and then choose AppleWorks Assistants from the Help menu Select Paragraph Sorter and then click OK Then select how you want the paragraph sorted AppleWorks sorts the paragraphs based on the selected text or the contents of the entire paragraph See Creating a document on page 2 1 for more information about Assistants Outlining An outline summarizes the major ideas of a written work in topics major In the Help index see headings and subtopics subordinate ideas You can indent the subtopics to gt outlines different levels to show their relative importance in the outline As you re organizing your ideas move topics up or down to change their level Hide collapse subtopics to highlight main ideas and show expand subtopics to focus on small details AppleWorks provi
195. m the list and click Go To Topic Index 1 13 X Y X Y scatter chart example 7 29 Z Zip codes in databases 8 7 Zooming controls for 3 1 documents 3 2 images paint 6 9 6 12 setting a custom scale 3 2 Choose Index from the Help menu and scroll to the entry Then choose a topic from the list and click Go To Topic
196. mation except paragraph Basic text styles Basic object styles formatting information Style type and symbol Paragraph 4 Description Formats entire paragraphs line spacing alignment indents tabs and labels Paragraph styles contain basic style information as well as paragraph formatting information Except for the Default paragraph style paragraph styles show only in Beyond the basics 9 7 Example s Lorem ipsum Dolor sit amet consectetuer adipiscing e Nibh euismod tincidunt ut laoreet dolore magna text documents and frames Outline Formats paragraphs as outlines Outline styles contain paragraph substyles for the levels of an outline Outline styles show only in text documents and text frames Lorem ipsum I Dolor sit amet A Consectetuer B Adipiscing elit sed II Nibh euismod Table spreadsheet BA Formats the text and cells ina range of spreadsheet cells Table styles contain the table substyles for different parts of a spreadsheet Table styles show only in spreadsheet documents and frames A B 1 p 2 97 20 88 90 EJ 33 00 100 00 _4 67 12 44 00 5 88 00 87 00 6 285 32 319 90 Styles in documents and frames You can use styles in frames and in every document type except communications This style type Does this Basic Formats text with combinations of font size and other attributes and enhancements but not paragraph forma
197. mple p Sa O Hl T ee In the Help index see Add AppleWorks From the File menu choose Library and then s clip art to a spreadsheet select a library In the library palette select mTl gt drawing tools the item you want and click Use Books 5 gt frames creating Add Use x gt libraries using Clip art in a library Draw directly in Select a drawing tool move the pointer into the spreadsheet the document and drag to create an object Add a paint frame to Select the paint tool move the pointer a spreadsheet into the document and drag to create the frame Then use the painting tools to paint in the frame Add a text frame Select the text tool and click once in the spreadsheet Select a font size and style and then type your text Display handles on a Click the frame once frame so you can treat it as an object For information on In the Help index see Copying and pasting pictures in a spreadsheet gt copying Inserting importing pictures created in another application gt Insert command K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 7 34 AppleWorks 5 User s Manual Creating links in spreadsheet documents In the Help index see gt book marks gt links When you plan to use an AppleWorks spreadsheet document or a document that contains a spreadsheet frame onscreen or
198. n each time you type values in the Qty Sold and Price fields the formula multiplies those values and displays the result in the Total field Enter Formula for Field Total 2 x Fields Operators Functions Invoice Date ABS numbed Invoice Number ACOS numbe Book Title AND logical logical Author AS IN numbep Qty Sold ATAN numbea ATAN2 amp numbery numbed AVERAGE Qumbert number2 Formula Oty Sold Price Format result as Number z Cancel Choose a format for Click field names operators and functions the formula result to include in the formula You enter a formula for a calculation or summary field just as you do for a spreadsheet cell See Working with formulas on page 7 20 The type of operation a formula performs depends on the field type of the values it calculates and whether the formula s field type is calculation or summary Usea calculation field to calculate a value from values in other fields in the current record Use asummary field to calculate a summary value using values from one or more records in the database You immediately see the result for a calculation field in Browse mode and List mode when you add records and when you change values used in a calculation Note To see the result for a summary field you must create a summary part in Layout mode and insert the summary field Then sort the records and switch to page view For more informa
199. n bar Select the button and click Modify A macro is one action that performs a series of actions You can create macros to automate tasks you do often For example you can create a macro that sorts a database prints a report and then closes the database document You can also create a button to execute a macro and add the button to the button bar See the previous section For information on In the Help index see Changing a macro gt macros Creating a macro Deleting a macro Making a shortcut button for a macro Running a macro K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 9 30 AppleWorks 5 User s Manual Including other applications in your documents OLE You can use Object Linking and Embedding OLE to combine information from other applications with information in AppleWorks files For complete information on using OLE with AppleWorks see onscreen Help For additional information on OLE see the documentation that comes with Windows 95 Understanding Object Linking and Embedding m Object Linking and Embedding is a feature of the Windows operating In me Help index SEEN system With OLE you can combine information from other applications an Linking and Embedding with information in AppleWorks AppleWorks is an OLE client application which means that AppleWorks can contain objects provi
200. n the order you created them You can now Start entering data You enter data in Browse mode or List mode when you select List from the Layout menu by selecting a field and typing a value in it You can t select a field that contains a formula or a field whose type is Record Info because AppleWorks enters those values for you Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Current number of records Click outside a field border to select the whole record Drag the control up or down to move quickly through records Customer Database 8 13 Cooks and Books Address 45 First St city Belmont Fields for one record Stats CA Postal 94002 File 103 customer JonesElectroniog SSC TO ae alee d Address 12 Main Street Mn iS ene Fields in a standard layout in Browse mode Note If the entire record becomes selected it means you clicked outside a field and selected the whole record To select a field click within the field borders To deselect a record press Enter on the numeric keypad and then try again Or make the first field active by pressing Tab To Do this Move to the next field Press Tab Move to the previous field Press Shift Tab Edit data in a field Click in the field and edit the data Insert a tab within a field Press Ctrl Alt Tab Enter the current date in a date field Press Ctrl
201. nd click an blandit praesent lupt atum zzril delenit augue duis dolore te feugait nulla facilisi Lorem ipsum dolor tetuer adipiscing elit sed diam Justified To set line spacing click the decrease spacing or increase spacing control on the ruler or the alignment buttons on the button bar blandit praesent lupt atum zzril delenit augue duis dolore te feugait nulla facilisi Lorem ipsum dolor sit amet conzec tetuer adipiscing elit sed diam Spacing increased to 1 5 lines Tip Double click the line spacing indicator to display the Paragraph dialog box and change the unit of measure To set the spacing between paragraphs choose Paragraph from the Format menu Type the number of units you want before the paragraph Paragraph Left Indent 0 5 ir Line Spacing First Line fo in Space Before Bight Indent fo in Space After Label Bulet z Alignment Left z Lines li Lines li dl Lines li iv coren Type the number of units you want after the paragraph Choose a unit of measure from a pop up menu amp Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Text word processing 4 13 Copying text ruler settings After setting tabs indents and line and paragraph spacing apply these In the Help index see settings to new or existing paragraphs by copying and app
202. nd using AppleWorks Help Contents and then click Getting Hep AppleWorks Help In many dialog boxes you see a 2 button You can click the 2 button to get Help for the task you re performing You can also press F1 for the current task when the dialog box is displayed Document 21x Margins _ Page Display Click this button or Top M Show margins press F1 for Help for Iv ishomtrenacuces the current task Bottom Tin One Page Above The Next Left C Facing Pages Side By Side Right Tin Le x Footnotes I Miror Facing Pages At Bottom of Page C At End of Document j 5 r Page Numbering IV Automatic Numbering Start at Page 1 Start At Cancel Note Whenever you open AppleWorks Help you start the Windows Help application which runs independently of AppleWorks This means you can open AppleWorks Help even when AppleWorks isn t running To do so click the Start menu and choose Programs Then choose AppleWorks Hap from the AppleWorks menu 1 4 AppleWorks 5 User s Manual Using the Help contents When you open AppleWorks Help you see a list of Help topics much like the table of contents in a book 3 z Help Topics AppleWorks Help x Click to see the index renee f Contents Index Find Click to search for specific slick any ime to Hse _ words in the AppleWorks O the contents window Click a topic and then click Display Or click another tab such as Ind
203. ned to the field Number Enter any number Score Score 55 Date Enter the day month and year Date lan1 1999 Date January 1 1999 Date 1 1 99 Time Enter hours minutes and seconds Time 2 35 15 Time 14 35 Name Enter names that sort by the last first or Name ane Adams other word in the field depending onhow Name Paul A Baker you type the name See Entering datain Name James Smith Jr fields on page 8 12 Name Treetop Books Pop up Menu Choose from a menu of preset values Department X Shipping _Marketing R Radio Buttons Check Box Choose among options Select or deselect the field Ship B OGround OAir Overnight K Sent sample Serial Number Have AppleWorks assign a unique sequential number to the field in each record Value List Choose from a scrolling list of preset values or enter a different value Ticket Ho fos Ticket Ho 104 Ticket Ho 105 Ticket Ho 106 code EE Database 8 9 Example Use this field type To in Browse mode Multimedia Display a picture movie or library or OLE object A picture in a multimedia field is stored with the database document A movie in a multimedia field is a reference to a movie file which is stored separate from the database document Record Info Display the time and date that the record stare er 5A was created or modified or the name of nn Time z the creator or modifier entered 239 Cal
204. nery using Creating opening and printing documents 2 13 You can open regular stationery from the New Document dialog box or from the Open dialog box To open regular stationery from the Do this New Document dialog box Choose New from the File menu and then select Use Assistant or Stationery Choose a category from the Category pop up menu select the stationery name in the scrolling list and then click OK Open dialog box Choose Open from the File menu select the drive or folder containing the stationery select the stationery name in the scrolling list and then click Open Identifying your documents In the Help index see gt Document Summary Info command Keep track of different versions of a document Identify important information in the document Save a description of your document when you want to include notes to yourself about the document s contents or when you plan to save the document as regular stationery See Saving document formatting as templates stationery on page 2 10 To save a description of a document choose Document Summary from the File menu and then type the information Document Summary x Title introductory Oer S OS Author JMEiy Version Second drat ti i C O OO OC S Keywords Promotion SSS SCSCisSCiS Category General Description i companion fare to UK in October Set Password Cancel When you save a
205. ng Ag S Grants B E Loans Harvard labels Diamond labels To remove an outline label such as the Roman numeral in a line of a Harvard style outline select one or more lines and choose None from the P pop up menu I Planning L Planning II Funding Il Funding Grants Loans Harvard labels No labels 4 16 AppleWorks 5 User s Manual Rearranging outline topics To move topics Do this Example before and after In the Help i Left or right Select the topic and choose A Grants 5 vane n the Help index see between outline MoveLetor MoveRightfrom the Loans Statina fai nstitutional gt topics levels Outline menu 2 Government 1 Government 3 Private Sector 2 Private Sector Move Left And subtopics Select the topic and choose A Grants up or down in the outline Move Above or Move Bdow from the Outline menu You can also drag topic labels up and down to reorder topics Move Above Subtopics move with topic Up one level Select the topic and choose A Grants A Grants B Loans B Loans Raise Topic from the Outline menu institutional 2 Government 3 Private Sector Raise Topic 1 Government 2 Private Sector institutional Collapsing and expanding outline topics You can collapse hide or expand show subtopics to highlight main ideas or show more details When the subtopics below a topic are collapsed the topic s paragraph label changes as follows
206. ng 7 16 selecting 7 6 titles 7 19 7 20 transposing with columns 7 7 Rulers changing 3 12 graphics 5 7 text copying settings for 4 13 setting tabs and margins 4 8 4 10 S Saving backup copies 2 8 documents 2 7 file formats for 2 15 formatting stationery 2 10 HTML files 11 9 libraries 3 18 Scaling objects 5 12 Scanned pictures 6 13 Scatter chart example 7 29 Searches named 8 25 Searching See Finding Section break character 4 23 Sections about 4 22 columns in 4 25 counting 4 31 formatting 4 23 inserting and deleting 4 23 numbering 4 25 title pages in 4 19 Selecting database columns and rows 8 18 fields 8 12 8 18 layouts 8 30 records 8 20 frames 5 6 5 20 images 6 7 library items 3 19 objects in documents 5 6 frames selecting objects spreadsheet cells 7 5 text 4 5 tools drawing 5 3 5 5 frame 3 9 painting 6 5 Selection rectangle paint 6 7 Selection tool See Arrow pointer Serial numbers in database fields 8 8 Series spreadsheet chart in 7 29 7 30 7 32 Session described 10 2 Shaping See also Reshaping or smoothing images 6 9 objects 5 13 Shearing an image 6 9 Shortcuts See Button bar Buttons Show hide tools control 3 1 Showing button bar 3 6 field labels 8 33 formatting characters 4 6 11 4 graphics grid 5 7 margins and page guides 3 11 3 16 palettes 3 4 records 8 21 tulers 3 12 spreadsheet chart or frame 7 31 columns and rows 7 17 grid 7 19 headings 7 19 tool panel 3
207. ng 7 30 described 7 28 elements described 7 29 modifying 7 29 7 32 examples 7 1 7 28 7 29 options for 7 30 resizing 7 30 showing and hiding 7 31 types of charts creating updating data for 7 29 Checkboxes as database fields described 8 8 finding 8 25 8 27 selecting 8 18 in text documents 4 11 Checking spelling See Spelling Checklists 4 11 Circles drawing 5 4 See also Objects Circular references 7 19 7 20 7 22 Clip art inserting in documents 2 15 storing in libraries 3 17 using 5 19 6 13 7 33 8 32 Closing documents 2 16 CM document type 2 3 Collapsing outlines 4 16 Colors See also Palettes changing in charts 7 32 databases 8 19 8 33 objects 5 10 outlines 4 13 text 4 7 text frames 4 6 5 19 copying from images 6 6 objects and frames 5 11 paint images setting 6 6 preferences for 3 21 tinting and shading paint 6 11 Column guides 4 21 Columns database labels for 8 39 layouts for 8 17 8 29 8 30 moving and formatting 8 19 resizing 8 18 8 19 selecting 8 18 spreadsheet changing number of 7 4 headings 7 3 7 19 inserting and deleting 7 17 printing headings for 7 20 resizing 7 16 selecting 7 6 titles 7 19 7 20 transposing with rows 7 7 text as linked frames 4 21 9 24 9 26 in word processing documents 4 20 4 22 varying on a page 4 25 Commas in numbers 7 10 Communications documents and HyperTerminal 10 1 communications program changing 10 4 concepts 10 2 connecting with 10 3 cre
208. ng down Shift also polygon bezigon and regular limits the movement of the arrow pointer as you polygon tools to 45 90 and 180 move selected objects Set the number of sides on a Select the regular polygon tool and choose Polygon regular polygon Sides from the Edit menu Type the number of sides from 3 to 40 and then click OK Set the angle of rounded corners Select the object and choose Corner Info from the Edit menu Choose an option type a value for the angle of curvature and then click OK Set the angle of an arc Select the object and choose Arc Info from the Edit menu Choose Normal to omit frame edges choose Frame Edges to include frame edges to make a wedge Type values for the position and angle of curvature and then click OK Use the same tool repeatedly Double click the tool This highlights the tool and locks it To unlock select another tool You ll find complete instructions for customizing the AppleWorks drawing tools in onscreen Help For information on In the Help index see Closing polygons automatically polygons Creating a custom line width pen Changing the constraint angle for lines rectangles graphics preferences rounded rectangles polygons and bezigons Automatically smoothing curved lines in freehand objects Speeding up the gradient display K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and
209. nge the width Press Alt and move the pointer Lorem ipsum blandit praesent i y dolor molestie luptatum sril delenit of two adjacent between the column guides until consequat el augue duis Ut wisi i ilum doloreea enumad mimin columns and keep the pointer looks like this fevgiat nolla ves benisum Se di the space between Then press the mouse button and them the same drag right or left Before Lorem ipsum benisum Se diam dolor molestie nonummy et crud liet parle consequat el Lorem ipsum dolor molestie ilum dolore consequat el illum dolore eu feugiat eu feugiat nulla facillisis at After column is moved left Using text frames to create columns In complex columnar documents such as newsletters or brochures try using linked text frames in a draw document instead of columns in a word processing document You ll have more flexibility to resize text frames and place them where you want Breaking a page or column In the Help index see gt columns breaks in Each page is preset to break end at the bottom of the page Text continues at the top of the next page or column You can end the page or column before it fills up by inserting a break at the insertion point To set a page or column break position the insertion point where you want the break and then choose Insert Column Break or Insert Page Break from the Format menu If Show Invisibles is selected in the Preferences dialog box you see a
210. nications document In the Help index see gt telecommunications Create a communications document when you want to exchange information with another computer Use an AppleWorks communications document to connect to a text based commercial online service such as CompuServe connect to a computer you can access at your business or school connect to a public or private bulletin board service BBS transfer files directly from one computer to another Communications basics The AppleWorks communications environment uses HyperTerminal to connect your computer to online services bulletin boards and other computers and to send receive and save information What you need Before you use the communications application environment be sure that you have the equipment and software you need See the documentation that came with your computer for information about HyperTerminal and its requirements If you plan to connect to a commercial online service you also need to register for an account Most popular services let you sign up when you first connect If you plan to connect to a computer at your business or school check with your site administrator for requirements K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 10 2 AppleWorks 5 User s Manual Communications terms and concepts If you re new to communications you need t
211. nt you see the button bar at the top In the Help index see of the document window below the menu bar The button bar saves time by gt button bars providing shortcuts to activities that would otherwise take several steps to complete The button bar is preset to include buttons for some common AppleWorks actions AppleWorks 5 0 untitled CWK WP iol x Fix Edit Format Font Size Style Outine Window Help le x giek t see options ef i i 3 D S E S S 22 s 2 3 G ef BZ Ul all al mow gawa aaaea E E 2 E7 E aaa s ni a E aaa of 2 3 4 o j4 5 6 7 8 e A e a The Default button bar for word processing documents To change the way you work with the button bar you can show or hide it change its position customize its appearance add or remove buttons create your own buttons to perform the tasks you choose see Creating and editing custom buttons on page 9 28 There are several preset button bars You can switch to a different one or create your own button bar For more information see Creating your own button bar on page 3 7 Switching button bars You can display only one button bar at a time and the buttons on the button bar change depending on the type of document The Default button bars include buttons for the most common actions for the current document type K Choose Index from the Help menu and type the first few letters of the entry Double click the ent
212. nt into sections each with its own distinct header and footer See Dividing a document into sections on page 4 22 Headers and footers if any do not appear on the first page of a word processing document or section that has a title page See Creating a title page on page 4 19 Adding a date or time In the Help index see gt headers gt Insert Date command You can display the current date or time on any page of a document AppleWorks updates the date and time with the current date and time when you close and reopen the document To change the format for the date see Setting preferences on page 3 20 Important Dates and times in this documentation are shown in U S formats using U S conventions In English speaking countries other than the United States dates and times might be formatted differently To repeat the date or time on every page of a document put it in a header or footer See Creating headers and footers on page 3 12 for more information To insert Do this Example The current date ortimeina Place the insertion point in the text frame or word document or frame and choose pale processing document Insert Date or Insert Time from the f Edit menu Date inserted in document or frame Dates and times are updated when you close and reopen the document The current date or timeina Place the insertion point in the Revised 4 4 97 header or footer header or footer and choose Insert Date o
213. nu and type the first few letters of the entry Double click the entry and then double click a topic Text word processing 4 23 USIMOD You can insert sections into a word processing document only You cannot insert a section into a header footer footnote or text frame Inserting and deleting a section To insert or delete a section click f 4 on the Default button bar or type Ctrl semicolon to display the formatting characters Then To Do this In the Help index see gt breaks Insert a section Choose Insert Section Break from the Format menu gt deleting text You see a section break character B where you inserted the section gt sections When page guides are visible you see a section break line at the end of each section See Previewing pages for printing on page 3 11 Delete a section Select the section break character for the section you want to delete and press Backspace For more information about formatting characters see Showing formatting characters on page 4 6 Formatting sections A new section uses the settings of the section preceding it To change the format of a section click anywhere in the section and then choose Section from the Format menu In the title bar of the Section dialog box you see the number of the section you re formatting In the Help index see gt columns text gt sections If more than one section is sel
214. o images 6 9 Depth and resolution paint 6 13 Dictionaries See also Spelling changing 4 31 Display options spreadsheet 7 19 Distance adding to images 6 9 Distorting images 6 9 Distributing objects 5 15 Document links See Links Document summary information 2 13 Documents Assistants 2 3 closing 2 16 creating 2 2 2 6 described 1 8 importing and exporting 2 15 linking to different or same document 2 9 9 2 to Uniform Resource Locator URL 11 6 opening 2 8 opening linked 9 3 previewing 2 16 3 11 printing 2 16 saving AppleWorks 2 7 formats stationery 2 10 in a different file format 2 15 size of paint 6 14 styles 9 7 DR document type 2 3 3 9 Draw documents book marks in 5 21 creating 5 2 described 1 10 5 2 links to different or same document 5 21 movies in 9 26 pages adding to 5 18 preferences for 3 20 slides in 9 17 Choose Index from the Help menu and scroll to the entry Then choose a topic from the list and click Go To Topic l 4 AppleWorks User s Guide text spreadsheets and paintings adding to 5 19 when to use 5 1 Drawing tools 5 3 5 5 Drawing in any document 5 2 Drawings and paintings differences between 6 2 Duplicating See also Copying cell data filling 7 8 images 6 8 layouts 8 28 8 32 library items 3 19 objects 5 9 records 8 15 styles 9 15 E Editing styles 4 17 9 13 Electronic mail See also Hyptertext Markup Language HTML Internet World Wi
215. o a different document or to other information on the Internet See Linking Web pages on page 11 5 Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic AppleWorks and the Internet 11 5 Adding pictures In the Help index see gt Web pages graphics for You can include pictures in any format supported by AppleWorks such as BMP and PCX When you save the document as HTML AppleWorks translates any art in the document to a format GIF or JPEG that is readable by Web browsers Important When you save an HTML file each picture is saved as a separate file in the same folder as the document If you move the HTML file to a different folder or computer you must move the picture files to the same location To make the pictures and documents easier to find save each HTML file with the pictures in its own folder To add a picture 1 Open or create the word processing document that you want to use as a Web page 2 Add art as an inline or floating object You can draw objects or paint frames directly in the document use art from a library or insert art from another document Linking Web pages In the Help index see gt Web pages linking You can create links connections or jumps from selected areas in a Web page to a different location in your Web page or to other Web pages Links can jump to a bookmarked locati
216. o be familiar with the following communications terms and concepts Term Definition Terminal A screen and keyboard used to communicate with a remote distant computer The remote computer can be as close as the same room or building or as far away as another country Using the terminal software included with Windows your computer can emulate act like a terminal so that your computer and the remote computer can communicate Host computer A computer that answers requests for information or that acts as a gateway to other computers You communicate with a host computer across a telephone line To communicate with a host computer you usually need an assigned user name and password When you identify yourself at connection time you re logging on When you disconnect you re logging off Connecting The process of establishing communication with another computer Communication from one computer to another requires a transmission channel usually a telephone line but sometimes a cable between two computers Connection by telephone requires a modem a device that turns data from your computer into a signal that can be transmitted over a telephone line The computer at the other end of the telephone connection also requires a modem Session The amount of time from when you connect to an online service or another computer to when you disconnect also called connect time When you use a commercial online service you re usually
217. o that the header or footer doesn t print on the first page To create a title page choose Section from the Format menu In the Section dialog box select Title Page and then click OK For information on creating more than one title page in a document see Dividing a document into sections on page 4 22 amp Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 4 20 AppleWorks 5 User s Manual Creating and changing columns In the Help index see gt columns text You can arrange text in multiple columns on every page of a document As you type text flows from the end of one column to the beginning of the next When you make changes to the width or number of columns the text adjusts accordingly Note You can set up different column formats from page to page or on the same page using sections See Dividing a document into sections on page 4 22 and Varying the number of columns on a page on page 4 25 Lorem ipsum dolor feugiat nulla facilisis at molestie consequat ver eros et accu Qui el ilum dolore eu blandit praesent ut let feugiat nulla vos et luptatum sril delenit facilisis at ver eros augue duis Ut wisi etaccu Qui blandit enum ad mimin praesent luptatum beniswmn Se diam Text formatted in columns To specify the number of columns in your document or text frame choose Section from the Format men
218. ocuments For information on working with windows pages libraries and buttons see chapter 3 Basics For information unique to a particular type of document or frame see the appropriate chapter in this User s Manual All features including procedures and shortcuts are described completely in onscreen Help See Using AppleWorks Help on page 1 3 if you are not familiar with onscreen Help or how this User s Manual and Help work together Starting AppleWorks To start AppleWorks click the Start menu and choose Programs Then choose AppleWorks from the AppleWorks 5 menu If you re new to AppleWorks or unfamiliar with the new features in AppleWorks run the onscreen tour You can run the tour at any time by choosing Introduction to AppleWorks from the Help menu in the AppleWorks window Creating a document In the Help index see gt documents creating To create a document you can start with a blank document use the AppleWorks Assistants which help you create specific documents to meet your home and office needs open custom templates called stationery K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 2 2 AppleWorks 5 User s Manual Creating a blank document You can create a document when you start AppleWorks or when In the Help index see AppleWorks is already running To create a document when
219. om the Options menu In the gt Set Print Range command specify rather than all formatted Print Range dialog box click Print Cell Range type cells and cells that contain data the range you want to print and then click OK Row and column headings or the Click amp on the Default button bar or choose Print cell grid from the File menu In the dialog box select or deselect the Print Column Headings Print Row Headings and Print Cell Grid checkboxes Working with formulas Use formulas to perform calculations on spreadsheet data You can combine numbers cell references named cells or ranges and functions predefined formulas to build your formulas For some simple formula examples see Examples Entering formulas on page 7 25 Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Spreadsheet 7 21 Important The examples in this documentation are based on U S conventions For example dates and numbers are shown in U S formats In English speaking countries other than the United States functions formulas and calculations might be formatted differently For example in the U S commas act as separators in formulas In other countries semicolons might be used as separators Understanding formulas In the Help index see gt spreadsheets calculations Within a single formula you can calculate a result using values suc
220. on or to a Uniform Resource Locator URL Links to a book mark are called document links Links to a Web page are called URL links For example create a link from a button in your HTML file to related sites K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 11 6 AppleWorks 5 User s Manual URL address for this Web page These links jump to a different location on the Web page About our coffees About our recipes Other sites This button jumps to a different Web page Click here for a complete explanation of the coffee bean roasting process Note You can also create a link to a different document or a different area of the same document even when the linked documents are not on the Web For more information see Creating links on page 9 1 You can attach links to selected text an object or to paint and spreadsheet frames To create a link to a URL 1 Open the Web page document from which to create the link and then select the item to create the link from 2 Click 88 on the Internet or Default button bar If you don t see the button bar choose Show Button Bar from the Window menu 3 In the New URL Link dialog box create a link and then click OK New URL Link x Name Espresso Cafe URL ee Cancel Type aname for the link Type the URL address AppleWorks and the Internet 1
221. on point Otherwise the arrow keys select an adjacent cell To use the arrow keys to always select cells choose Preferences from the Edit menu In the Preferences dialog box choose Spreadsheet from the Topic pop up menu select Always Selects Another Cell and then click OK You can move selected cells using the keyboard and mouse or using menu commands To Select the cells you want to move and then Move the cell contents and Choose Move from the Calculate menu Type the cell address retain the original cell of the new location for example E22 and then click OK For references a cell range type the new location for the upper left cell in the range Move cell contents quickly Hold down Ctrl Alt and click in the cell or at the top left cell for a range where you want the selection to go You can also use the mouse to drag the cells to another location on the spreadsheet Transpose a column of data Choose Cut from the Edit menu Then select the target cell or into a row or a row of data range and choose Paste Special from the Edit menu In the Paste into a column Special dialog box click Transpose Rows and Columns and then click OK Transposed data overwrites any existing data Important When you move cells that are part of an absolute reference in a formula be sure to move the entire range of cells in the calculation K Choose Index from the Help menu and type the first few letters of the entry Double click
222. on the Internet or World Wide Web you can select an area of the document or frame and create a link a connection or jump to a different area of the same document a different document or a document or other information on the Internet If you paste text with links assigned to it from a word processing document or text frame to a spreadsheet cell the links are not pasted If you paste text with links assigned to it from a spreadsheet cell to a word processing document or text frame the links are not pasted To create a link in a spreadsheet document or frame select the cell and then create the link For more information see Creating links on page 9 1 To create a link to information on the Internet see Linking Web pages on page 11 5 Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Chapter 8 Database This chapter describes how to design an AppleWorks database document to help you manage information AppleWorks makes it easy for you to create a database enter your data format it in different layouts and present custom reports Once a database contains records you can search through and sort them change the data they contain and design and print a report of some or all of the data All database features including procedures buttons and troubleshooting are described completely in onscreen Help When to use a database Use a d
223. oose Insert from the File menu Playing a movie Volume control click to open and drag the slider to the volume QuickTime and AVI movies behave differently When you click a badge on a QuickTime movie you see a control bar with standard VCR controls When you click a badge on an AVI movie the movie plays a Handle Click the control badge to play the movie A movie control bar appears on QuickTime movies Forward reverse slider alee Play bar Step forward and reverse buttons Play Stop button Movie control bar 9 28 AppleWorks 5 User s Manual Creating and editing custom buttons Custom buttons reduce tasks such as opening a file or checking the spelling In the Help index see of a document to a single step You can create a custom button to run a sequence of actions and then add that button to the button bar For more information see Using the button bar on page 3 5 gt button bars AppleWorks is preset to show the button bar at the top of the document window below the menu bar If you can t see the button bar choose Show Button Bar from the Window menu e 79a a8 see 5 0 59 clels a 7 uaa Se Ae 9 Saal el zl ale Sel a ele avi orde vla dEle To create a new button choose New Button from the 7 menu on the button bar If you don t see the button bar choose Show Button Bar from the Window menu You see the New Button dialog box
224. opics in the 1 Planning I Planning x A IL Funding II Funding expandalltopics outline hold down Alt and IIT Building A Grants in an outline choose Collapse All or Expand All B Loans Collapsed outline 1 Institutional 2 Government 3 Private Sector III Building from the Outline menu Expanded outline Modifying an outline style In the Help index see gt styles gt styles editing Level 2 Level 3 Level 4 You modify an outline style by changing its properties formatting options in the stylesheet palette For more information about working with styles and the stylesheet palette see About the stylesheet palette on page 9 6 To modify an outline style 1 Click on the Default button bar or choose Show Stylesheet from the Window menu 2 Click Edit on the stylesheet palette The pointer changes to Pg 3 From the scrolling list on the left select the name of the style to modify for example select Havard or Legal 4 Click the arrow next to the style s name to make it point downward 5 In the scrolling list on the left select the outline level you want to modify 6 Change the properties of the outline level You change a style s properties using the document controls you d normally use to format text and objects such as the tools palettes ruler controls and menu commands For example you may want to change the indentation line spacing and the font size 7 Repeat
225. or texture aos l2 Eraser Drag the eraser to remove part of an image pe Aam g Lae Before After As you use the painting tools keep the following tips in mind To Do this Change the size shape and other settings Choose Brush Shape or Spray Can from the Options for the brush and spray can menu Change the brush effects Double click the brush 5 Choose Efects from the pop up menu set the options and click OK Set the number of sides on a regular Double click the regular polygon tool Kesh type polygon the number of sides from 3 to 40 and then click OK Set the angle of curvature for an arc or Double click the arc tool frame the arc s edges to make a wedge then click OK S set options and Set the angle of curvature for the ends and Double click the rounded rectangle tool set corners of a rounded rectangle options and then click OK Erase the entire painting Double click the eraser 2 Reverse your most recent change Click on the Default button bar or choose Undo from the Edit menu Use a selected image as a paint brush Hold down Ctrl Alt as you drag the image K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 6 6 AppleWorks 5 User s Manual Setting lines colors pattems and textures In the Help index see gt fill palettes gt palettes gt pen gt styles Use th
226. orks opens a blank document of the same type To maintain security consider doing the following Make passwords easy to remember but not so easy that someone can guess them Ifyou write down passwords store them in a secure place away from your computer a Change passwords often Passwords provide a minimum level of security to your documents and should not be used to protect sensitive information Setting a password does not encrypt the file To protect sensitive documents consider taking additional security measures X Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Creating opening and printing documents 2 15 Importing and exporting documents In the Help index see gt exchanging data You can share AppleWorks documents with other applications by importing to or exporting from AppleWorks documents To import and export documents the AppleWorks application uses translators special files that translate information for many popular software applications These files which come with AppleWorks are in your AppleWorks 5 folder To Do this Export a document so it can Choose Save As from the File menu and then choose a file be read by an application format such as WMF from the Save as type pop up menu other than AppleWorks If the file format you want to use isn t listed try using one of the commonly accep
227. ou can address envelopes in AppleWorks If you can t print directly on envelopes you may want to print your addresses on address labels See Printing labels on page 8 39 amp Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Beyond the basics 9 23 Using the Envelope Assistant In the Help index see gt Assistants Use the Envelope Assistant if you want AppleWorks to step you through addressing an envelope that you can print You can have the Assistant help you type an address and place it on the page or you can have it format an envelope with an address you ve already typed To have the Assistant help you type an address and place it on the page start AppleWorks and then choose New from the File menu Select Use Assistant or Stationery and then select Envelope in the scrolling list and click OK The Assistant prompts you to complete the steps required to address the envelope To have the Assistant format an envelope with an address you ve already typed select every line of the recipient s address and choose AppleWorks Assistants from the Help menu Select Address Envelope from the scrolling list and click OK Setting up and creating envelope stationery In the Help index see gt envelopes gt stationery creating To set up the envelope stationery create a draw document Choose Print Setup from the File m
228. ou can make reports that find and reorder records and print the result For example you might want to set up a report to print the California addresses from your database on Avery 5164 mailing labels To create a report choose New Report from the Report i pop up menu Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Database 8 37 New Report x Report Name ca Mailing Labels Layout Ave 5161 5261 hd Search California v Sort Postal 7 Type a name for the report Choose report options Cancel Once you create a report you can reuse or change it In the Help index see gt reports To From the Report pop up menu choose Reuse a named report The report name mE New Report 7 Edit Reports Change a report Edit Report Select a report from the list and click Modify Make your changes and then click OK CA mail labels Monthly Report weekly Report Rename a report Edit Report Select a report from the list and click Modify Selecting a report Type a new name and then click OK Delete a report Edit Report Select a report from the list click Delete and then click OK Importing data from other documents When you want to work with information from another database you can In the Help index see gt importing gt Insert command import a database create
229. our style will contain many preset formatting properties To see these properties open the stylesheet palette select the Default style and then click the Edit button Click Done when you re finished amp Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Beyond the basics 9 11 Tuming off a style In the Help index see gt styles using Once you apply a style you can restore an item to its original state by choosing Unapply Stylefrom the Edit menu on the stylesheet palette The name of the command varies depending on the style you applied Example Applying and creating styles In this example you type some text and format it with three styles including two custom styles you add to the stylesheet palette You also remove a style from some text in your document Footnote Index Hot Text Checklist Default Footer Footnote Header Diamond Harvard Legal Part 1 Type some text and apply a preset style 1 Open a new word processing document as described in Starting AppleWorks on page 2 1 Type Camping Supplies and then press Enter three times For the next line type Be sure to bring these things on our camping trip and then press Enter twice Type the next three lines pressing Enter between each line Tent Compass Sleeping bags 5 Select the three lines you typed in
230. outlines creating 4 13 pasting 3 10 preferences for 3 21 selecting 4 5 typing in database fields 8 12 drawings 5 19 paintings 6 12 spreadsheets 7 5 text documents 4 4 word count 4 31 wrapping around pictures 4 32 at end of line 4 4 in spreadsheet cells 7 10 Text cursor See Insertion point Text fields 8 8 Text formatting characters 4 6 4 28 Index 1 11 Text frames See also Frames Text Word processing documents changing attributes in 4 6 5 10 5 19 creating in any document 4 2 database layouts 8 31 draw documents 5 19 paint documents 6 12 spreadsheet documents 7 33 word processing documents 4 2 described 4 2 linking 9 24 reshaping and resizing 4 3 sorting in 4 13 working with 4 3 Text ruler See Rulers Text tool word processing 3 4 3 9 Textures See also Palettes copying from objects 5 11 custom creating editing patterns and textures setting for database fields 8 33 images 6 6 objects 5 9 Thesaurus 4 30 4 31 See also Spelling Tiling windows 3 3 Times conventions for 3 14 current in databases 8 13 text 3 14 3 15 formatting in databases 8 8 8 33 spreadsheets 7 10 recording automatically 8 9 Tint command 6 11 Title page 3 14 Titles document 2 13 spreadsheet chart 7 29 7 32 locking 7 19 printing 7 20 Tool Help 1 7 Tools Choose Index from the Help menu and scroll to the entry Then choose a topic from the list and click Go To Topic 1 12 AppleWorks User s Guide
231. pe or a label see Addressing envelopes on page 9 22 TH et at aed Mr Ap riir ke Dae mB Hiap iai da ADO ieg Wa n wa POOD Kapu oR O aag ba imer m AM lhd Oai Cher p HY 709 ol Bing En Dlm Aae TH7 mn Ana rami A AN aite g Field data to merge Placeholder Darek IrAth SOL batyticak rPibudatts trub Bta Dp Durie Srith Turia forching amp Alpina Valg Bie yur Dir THs ath We ra Irving Oral on ininogeomennnic Ie rede your nictwiniar walon crannies ajot Thapa youjoin ue again amg Turia tok dvb EAHA Valy Bie yur Database D WR ra Irveatting eh0 red ll on ininngeommrrunie ke your mot winar walon avan rore jobi Tahap youoin ue apain Arry Kr a Result of mail merge Merge document To merge data follow these general steps 1 Set up a database You can have a database of names and addresses items and prices clients and facts about them or any other categories of information you want to merge with text Be sure to save the database Mail merge only works with database documents that are saved to disk 2 Prepare a merge document or frame Enter the text that is common to all the printed documents in a document or frame and then enter field variables where you want to insert information from the database 3 Print the merge document with the database information inserted Each of these steps is described in the following sections Setting up the
232. phics preferences only the width or the height Setting the angle of constraint limitation for the pointer s motion Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Reshaping and smoothing objects Use AppleWorks commands and controls to reshape objects and change their curves or angles See onscreen Help for more ways to reshape objects and curves as well as how to add and delete control handles and anchor points rem ae ee In the Help index see gt reshaping Connecting objects To Modify the corners and ends on rectangles and squares Select the object s and choose Corner Info from the Edit menu or double click the object Choose an option type a value for the angle of curvature and then click OK Drawing 5 13 Example before and after Ca ce Modify an arc Arc Info from the Edit menu or double click the object Choose an option for omitting or including frame edges to make a wedge type values for the position and angle of curvature and then click OK 3 D Reshape arcs polygons regular polygons bezigons and freehand shapes Peshape from the Arrange menu Use the reshape pointer to drag the anchor points to new positions Then choose Reshape again Q alia Cal s e gt 4 S Change the bend of a curve in a bezigon or freehand object Reshape from t
233. ppear in page view For instructions on hiding the margins and page guides in a word processing document see Previewing pages for printing on page 3 11 the screen For more information about printing these document types see Printing a spreadsheet document on page 7 20 and Printing a database document on page 8 38 Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Chapter 3 Basics This chapter provides basic information about working with windows and documents using libraries to store drawings images frames and text that you can reuse later and using the button bar to speed up your work The information in this chapter applies in general to all document types For information unique to a particular document type see the appropriate chapter in this User s Manual All features including procedures and shortcuts are described completely in onscreen Help See Using AppleWorks Help on page 1 3 if you are not familiar with onscreen Help or how this manual and Help work together Working with windows Each document appears in a window which contains standard elements for working with applications You also see elements unique to AppleWorks File Edit Format TET Size Style Qutline Window Help la x 2 a 8 2 8 8 Sl Sl 22 el a ely Bl JU aaa aaa Al amp
234. pter and in onscreen Help For example you could try adding different field types changing the layout of the fields and searching for specific records 8 6 AppleWorks 5 User s Manual To save your database before closing it click S on the Default button bar or choose Save from the File menu type a name for the document choose a different folder if necessary and then click Save To close the database document choose Close from the File menu Designing a database In the Help index see gt planning databases List the fields each record will hold Before you create a database it s a good idea to plan your database design on paper to reduce the time and effort of redesigning When planning your database decide what you want the database to accomplish which fields the database will contain and the type of data they II hold what each record in the database will represent for example an employee or an invoice how the database can help you work more efficiently by using options such as formulas and automatic data entry Invoices Date ante entry today s date Book title Anthor SP Identify fields that are l automatic entries or the C Crt Pria results of calculations Vamber ordered Total price aute calentate Tip When you design a database that holds names and addresses you can start quickly by using the Address List Assistant and then changing
235. quation Editor in AppleWorks Equation Editor in AppleWorks 5 is a special version of MathType by Design Science If you frequently create documents with equations you may find MathType is better suited to your needs MathType is as easy to use as Equation Editor and has many extra features to help you save time and create more complex mathematical formulas in documents For further information about upgrading Equation Editor to MathType contact your software dealer or Design Science directly Design Science Inc 4028 Broadway Long Beach CA 09803 Toll Free 800 827 0685 International 562 433 0685 FAX 562 433 6969 e mail info mathtype com Web site http www mathtype com Contents Chapter 1 Introduction Registration and customer support How to start Using Help and the User s Manual together Using AppleWorks Help Opening and closing AppleWorks Help Using the Help contents Navigating AppleWorks Help Using the onscreen Help index Learning more about onscreen Help Getting additional help Working with AppleWorks What s a document Document types Text word processing documents Draw documents Paint documents Spreadsheet documents Database documents Communications documents Where to go from here Chapter 2 Creating opening and printing documents Starting AppleWorks Creating a document Creating a blank document Using an Assistant Using stationery Saving a document Opening a document Finding documents
236. r You might want to create a new button bar with the buttons you use most often To create your own button bar choose New Button Bar from the menu on the button bar In the New Button Bar dialog box type a name for the button bar add buttons and then click OK For information on adding and removing buttons see the previous section Using palettes A palette is a window with options you can apply to documents frames and In the Help index see objects You can open and close palettes such as the fill pen library and gt palettes types stylesheet palettes gt palettes using Note You can resize some palettes such as the library and stylesheet palettes To resize a palette hold the mouse button down over the lower right corner of the palette and then drag the corner diagonally until the palette is the size you want K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 3 8 AppleWorks 5 User s Manual File Edit Format Arrange Options Window Help 8 x 70a A a 8 a S S e E 8 S ee H B 7 ul l 25 el Sol El e BI l I l SS a r Ag Click to close the palette Ctrl click closes all open palettes gt Drag the palette Click to view the palette onto the working and select an option area to keep it open while you work Use the To For more information see Fill palettes Fil
237. r Insert Time from the Date inserted in header Edit menu amp Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Basics 3 15 To insert Do this Example A fixed date or time one Hold down Alt as you choose that does not update when Insert Date or Insert Time from the you close and reopen the Edit menu document in a text frame word processing document header or footer Numbering pages In the Help index see gt Insert Page command You can display the current page number or page count on any page of a document The page number is updated when you add or remove pages or change the starting page number To repeat the page number on every page of a document put it inside a header or footer See Creating headers and footers on page 3 12 To insert Do this Example The current page Place the insertion point in the Fax Cover Sheet number or page count document or frame and choose Page 1 of 5 ina text frame or word Insert Page from the Edit menu From Elfriede Lechner processing document Then select PageNumbertoinsertthe To Michelle Cannon page number or Document PageCount to insert the total number of pages Page number and document atoe dectneki page count shows a range The current page Place the insertion point in the number or page count header or footer and choose Insert Page 3 in a header or footer Page
238. r for use with the Internet create Web pages and send and receive electronic mail email Before you begin you need to understand how to create and edit documents In particular you should understand the information in chapter 2 Creating opening and printing documents chapter 4 Text word processing and chapter 5 Drawing You should also understand Using the button bar on page 3 5 and Editing links on page 9 3 All Internet features including procedures buttons and troubleshooting are described completely in onscreen Help About the Intemet and the Web In the Help index see gt Internet The Internet is a collection of computer networks that use a common set of rules for exchanging information called the transmission control protocol Internet protocol TCP IP Using the Internet with your computer you can work with information that s stored at other locations For example you can read weather reports from around the world send and receive electronic mail email and attend a creative writing class from a remote site The Internet network was once limited to simple text only documents With the development of the Web documents can now include graphics various text styles and links connections or jumps to areas of the same document or to other Web pages applications or servers on the Web A document on the Web is called a Web page home page or start page K Choose
239. r the page and then hold down the mouse button and drag the pointer until the frame is the size you want You can now work in the frame and you see the appropriate menu commands for that frame for example you see spreadsheet commands when you work in a spreadsheet frame Tip Look in the status bar at the bottom of the application window for the two letter code WP for word processing DR for drawing and so on that tells you which commands are currently available You can also click the right mouse button to see a menu of appropriate commands Loremipsum dolon Use the text tool to draw a text frame Use the spreadsheet tool to draw a spreadsheet frame Use the paint tool to draw a paint frame Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 3 10 AppleWorks 5 User s Manual Working in an AppleWorks document This section describes methods you can use to work with most AppleWorks documents Cutting copying and pasting In AppleWorks you can cut copy and paste text objects or images within a document or frame between AppleWorks documents and between an AppleWorks document and another application s document To Do this For this result Copy Select the text object or Puts a copy of the selected text object or image to copy and click f on image on the Clipboard The original item the Default button bar or stays
240. r which you last searched by choosing Find Change from the Edit menu and then Find Again Finding special characters _ _ _ _ __ Es In the Help index see gt hidden characters Using writing tools You can search for special formatting characters such as return characters tab characters and symbols for column breaks the same way you search for regular text You can also search for special text such as dates times and page numbers To find these characters you enter special codes in the Find box in the Find Change dialog box All of these codes are listed in onscreen Help and on the Quick Reference Guide You can also copy and then paste special characters from your document into the Find box in the Find Change dialog box Tip To show or hide formatting characters click f on the Default button bar or type Ctrl semicolon See Showing formatting characters on page 4 6 for more information To delete a selected formatting character or replace it with another formatting character use the Find Change dialog box the same way as you do with text AppleWorks provides spell checking thesaurus and hyphenation services to help you polish your writing These are available in all AppleWorks documents except communications Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Text word processing 4 29
241. rators cell references and functions For an example of a simple function see Example Using the AVERAGE function on page 7 27 In the Help index see gt functions AppleWorks provides over 100 functions in nine general categories A complete list of these functions is in onscreen Help Category Purpose Example Business and Calculates mortgage and payment values PMT Payment Financial Date and Time Manipulates dates and times DATE Information Looks up and evaluates information in LOOKUP spreadsheet cells cell ranges and database fields Logical Evaluates Boolean expressions which resultin ISBLANK either TRUE or FALSE Numeric Performs general mathematical calculations ROUND Statistical Calculates general statistics such as standard AVERAGE deviation and variance Text Finds compares and manipulates text CODE ASCII code expressions Trigonometric Creates and evaluates mathematical and SIN scientific values Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Spreadsheet 7 27 Entering functions _ i L_L_l________ _ z In the Help index see gt functions To enter a function 1 Click the cell where you want the result to appear If you re including the function as part of a larger formula click in the formula where you want the function to appear Choose Paste
242. rd in context Status Questionable Spelling 15 VYords Checked 1 Questionable Word there to sign your neaw books We ll have entertain Shows the questionable word in context K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 4 30 AppleWorks 5 User s Manual Tip If you need to check the spelling in a communications document you can copy and paste the text into a word processing document and then check spelling there Or save your communications document as text then reopen that text file as a word processing document Hyphenating words You can use automatic hyphenation to prevent entire words from moving to In the Help index see the next line You can also change where words hyphenate Auto Hyphenate command To turn automatic hyphenation on or off choose Writing Tools from the Edit menu and then choose Auto Hyphenate To specify how a single word should be hyphenated place the insertion point where you would like the word to break and press Ctrl hyphen Finding synonyms When you re searching for the best word you can look up synonyms In the Help index see words of similar meaning in the onscreen thesaurus that is provided with gt synonyms AppleWorks The AppleWorks thesaurus is a collection of more than 220 000 words organized by synonyms To find a synonym select a word choose Writing Tools
243. rder in List mode reorder the fields See Moving columns and formatting data on page 8 19 Note Fields you don t move to the Tab Order list will not be accessible by pressing Tab To select such a field in Browse List or Find mode click within the field Duplicating deleting and moving records a a ae In the Help index see gt records adding gt records deleting When records are similar you can save time and prevent data entry errors by duplicating records Once you duplicate a record you can change only the values that are different in the new record and avoid retyping identical information You can also copy and paste a record to duplicate it or delete one or more records at a time To Select the record to duplicate delete or move and then Duplicate a record Choose Duplicate Record from the Edit menu AppleWorks adds a copy of the record to the end of the database and places the insertion point in the first field ready for you to enter data Copy and paste arecordinto Click on the Default button bar or choose Copy from the another document Edit menu Then click 3 or choose Paste If you re pasting the application or database record into an AppleWorks database the copy is added to the end of the database Delete a record Choose Delete Record from the Edit menu If you change your mind before you do anything else click on the Default button bar or choose Undo from the Edit menu to r
244. rdering slides Showing the slides Merging data into documents mail merge Setting up the database Preparing the merge document Printing the merge documents Addressing envelopes Using the Envelope Assistant Setting up and creating envelope stationery Addressing an envelope Linking frames Working with movies Adding a movie to a document Contents XI 9 1 9 2 9 3 9 4 9 4 9 5 9 5 9 6 9 7 9 9 9 11 9 11 9 13 9 15 9 16 9 16 9 16 9 17 9 19 9 19 9 19 9 20 9 21 9 22 9 22 9 23 9 23 9 24 9 24 9 26 9 27 XII AppleWorks 5 User s Manual Playing a movie Creating and editing custom buttons Using macros Including other applications in your documents OLE Understanding Object Linking and Embedding Inserting OLE objects Working with OLE objects Chapter 10 Communications When to use a communications document Communications basics What you need Communications terms and concepts Creating a communications document About the communications window Connecting to another computer Changing the communications program Chapter 11 AppleWorks and the Internet About the Internet and the Web About browsers Selecting a browser Connecting to the Web Creating a Web page Designing your Web page Creating an HTML file Adding pictures Linking Web pages Saving a document in HTML format Opening and editing HTML files Working with electronic mail Index 9 27 9 28 9 29 9 30 9 30 9 31 9 32 10 1 10 1 10
245. reate a paint frame Use the OLE tool palette to insert an OLE object into the AppleWorks layout Deleting duplicating and renaming a layout Duplicating renaming or deleting a layout has no effect on the data in your From the Layout menu or the Layout pop up menu choose Edit Layouts Select a layout from the Current Layouts list click Delete and then confirm the deletion records To a aaan a A In the Help index see Delete a layout gt duplicating gt layouts editing Duplicate a layout New Layout Type a new name select Duplicate and then click OK gt layouts deleting Rename a layout Edit Layouts Select a layout from the Current Layouts list and then click Modify Type a new name and then click OK Changing the appearance of data While you work in Layout mode you can change the way text numbers In the Help index see gt editing text dates times and multimedia values appear in Browse mode and List mode and when you print You can work with layouts as they are or change them gt fields formatting to suit specific purposes Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic om Fill palettes 18 Pen palettes Database 8 33 Start by choosing Layout from the Layout menu To Change the appearance of text in text pop up menu radio button or checkbox fields
246. resizing 6 14 resolution and depth 6 13 slides in 9 17 text and spreadsheets in 6 12 tools using in 6 4 when to use 6 1 zooming images in 6 9 Paint frames See also Frames Paint documents book marks in 6 14 creating in any document 6 2 draw documents 5 20 spreadsheet documents 7 33 word processing documents 4 31 described 6 3 linking 9 24 links to different or same document 6 14 opening and closing 6 4 painting in 6 4 point of origin 6 4 resizing 6 4 Painting tools 6 5 Paintings and drawings differences between 6 2 Palettes See also Colors Gradients Patterns Textures described 3 7 fill and pen 5 9 6 6 library 3 17 links 9 2 mail merge 9 21 preferences for 3 21 shortcuts See button bar stylesheet 9 5 Pane controls 3 1 Paragraph Sorter Assistant 2 5 4 13 Paragraph styles 9 7 9 12 Paragraphs adding bullets numbers or checkboxes to 4 11 aligning text in 4 12 copying ruler settings for 4 13 counting 4 31 indenting 4 10 line spacing changing 4 8 reordering 4 11 sorting 2 5 space between 4 12 Choose Index from the Help menu and scroll to the entry Then choose a topic from the list and click Go To Topic styles for 9 7 9 12 Paragraphs sorting 4 13 Parts database copying summary fields in 8 36 deleting and resizing 8 36 described 8 34 inserting 8 34 Passwords opening protected documents 2 8 setting 2 14 Paste Function button 7 27 Pasting See also Copying Cu
247. rge your view of the title and then use the paint bucket to add a gradient or texture to each letter Finish by selecting the title and changing its perspective choose Perspective from the Transform menu Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Adding clip art SSS a In the Help index see gt artwork inserting gt copying gt libraries overview Painting 6 13 You can incorporate AppleWorks clip art and other types of art in a painting Anything you add to a painting becomes an image made of pixels To Do this Add AppleWorks clip art to Choose Library from the File menu choose Open and a painting then choose a category In the library palette select an image and click Use For more information see Using libraries on page 3 17 Copy one or more items from an Open the document containing the picture you want AppleWorks document or a clip art select the picture and then click G on the Default document to a paint document button bar or choose Copy from the Edit menu Open the AppleWorks document into which to paste the art click where you want the picture to go and then click on the Default button bar or choose Paste from the Edit menu Import scanned pictures or the Choose Insert from the File menu In the Insert dialog box entire contents of a document select the file type from the Files of Type pop
248. rks to understand what AppleWorks is all about To begin the tour click the Start menu and choose Programs Then choose Introduction to AppleWorks from the AppleWorks menu Start AppleWorks click the Start menu choose Programs and then choose AppleWorks from the AppleWorks menu and practice using AppleWorks while reading this User s Manual and referring to onscreen Help 1 2 AppleWorks 5 User s Manual If Do this You ve used AppleWorks Read the rest of this chapter to learn how to use this User s before Manual and AppleWorks Help together Start AppleWorks see Starting AppleWorks on page 2 1 if you need help Then review the list of new features in AppleWorks see the AppleWorks 5 Installation Manual or choose AppleWorks Help Contents from the Help menu and then click New features in AppleWorks As necessary review AppleWorks Help topics and the chapters in this book to learn more about specific procedures Using Help and the Users Manual together In the Help index see gt index entries relating to the current section are listed here This User s Manual and AppleWorks Help a comprehensive onscreen Help system are designed to work together Text marked with a bar in the margin or within the text lists index entries to AppleWorks Help topics These Help topics provide more information about a feature For information on In the Help index see an AppleWorks feature g
249. rks to design your Layout mode layouts You don t enter or edit data in Layout mode so creating or changing a layout has no effect on the data in the database In the Help index see K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 8 28 AppleWorks 5 User s Manual To edit the current database layout choose Layout from the Layout menu Add graphics and text 7 by Category Drawing tools Qty Sold Price ae s o ia aaa star A eE Pee To Le ee Grand total Grendel Field labels and fields become objects in a layout You can create five types of layouts in the New Layout dialog box Layout type Description Example Standard Contains all the fields created Name Name for the database stacked Address 1 Address 1 vertically in the order you Address2 Address 2 created them City ST ZIP ly ST AIP Field names to the left of each field Duplicate Creates a copy of the layout you re currently using In List mode duplicates the first layout in the database Blank Contains no fields You add the fields you want using the Insert Field and Insert Part commands in the Layout menu Bodi Insert the fields and arrange them manually Database 8 29 Layout type Description Example Columnar Shows and prints fields Name Address 1 report in columns Ea Name A
250. roll to Cell Alignment General p see more Default paragraph properties You create a custom style by collecting formatting information from any of the following an element in a text draw or spreadsheet document such as text or objects a style that s already on the stylesheet palette the document controls you d normally use to format text and objects such as the tools palettes ruler paragraph controls and menu commands To add a custom style to the stylesheet palette click on the Default button bar or choose Show Stylesheet from the Window menu to show the stylesheet palette Then click the New button on the stylesheet palette In the New Style dialog box set the options you want and then click OK Type aname for your style New Style Style type Style name Basic Paragraph Based on C Dutline Ne zl A C Table None x Choose None if you don t want the new style to assume any preset formatting options or choose a style to acquire that style s properties T Inherit document selection format Cancel You see the pointer for editing styles s when you exit the New Style dialog box unless you selected Inherit document selection format If you want to edit the style now see Editing styles on page 9 13 If you don t want to edit the style click Doneon the stylesheet palette Tip If you choose Default from the Based on pop up menu in the New Style dialog box y
251. rs of the entry Double click the entry and then double click a topic 5 8 AppleWorks 5 User s Manual eae In the Help index see gt object size palette gt positioning objects Note To move objects freely without being constrained to the autogrid choose Turn Autogrid Off from the Options menu To move Select the object s and Hold down the mouse button while dragging the object to the new position Don t drag a handle If you do you ll resize the object Any object including a frame An object in small increments Press the arrow keys An object by specifying its location Choose Object Size from the Options menu type values in the top four boxes in the size palette and then press Enter Duplicating copying and deleting objects Once you create objects you can duplicate copy or delete them In the Help index see gt duplicating gt removing Example bY ix Ie W 4 4 fo wi 1 63 in 41 13 in 3 26 in 41 75 in bn here 1 63 in 0 63 in Remember that you can usually reverse your most recent action by choosing Undo from the Edit menu To revert to the most recently saved version of your document choose Revert from the File menu Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic To Duplicate an object Drawing 5 9 Select the object s and Choose Dup
252. rt BelmontAvenue l oE Create a map in a g5 L Elm Street R draw document JE be F a Chestnut Street Vehicles per hour 3ami0am Sp m6p m Mtin Street 123 243 im Steet 75 isi Spreadsheet frame Chestnut Street 79 186 Total 277 50 Add text and data to create a presentation Draw documents are useful for creating presentations newsletters maps organizational charts and illustrations Draw documents are especially useful for complex page layouts you can link text frames in a draw document so the text flows from one frame to the next See chapter 5 Drawing for more information about what you can do with draw documents and using drawing tools in all types of documents For information on linking frames see chapter 9 Beyond the basics Introduction 1 11 Paint documents Use a paint document primarily for creating illustrations You can use the same tools you use to create drawings plus a set of tools for special effects like paintbrush strokes and spray paint If you want to add a spreadsheet text or clip art you can do so without leaving the paint document File Edit Format Transform Options Window Help 18 x 2 a BY BY Sy 2 S SI 2 23 8 2 3 CY G BY 7 Ul 3 3 Sy Sal Paint menus 2 a a Sal S stl e e and button bar are de dede oo RJA Z td
253. rt Part dialog box select a summary part and then choose an option for a page break Copying summary data In the Help index see gt summaries database You can copy data in summary fields when you re in page view and when a sub summary leading grand summary or trailing grand summary exists For example copy values from summary fields into a spreadsheet and then display a bar chart using those values To copy summary data choose Browse from the Layout menu then choose Page View from the Window menu Choose Copy Summaries from the Edit menu Open the application or document to hold the copied data and then paste the data for example select an area in the document and choose Paste from the Edit menu Resizing and deleting parts U SSS In the Help index see gt resizing layout parts Creating reports Start by choosing Layout from the Layout menu To In Layout mode do this Resize a part Move the pointer over the line dividing the parts until it looks like this and then drag the line to resize the part area Delete a part Delete all fields text and graphics in the part Move the pointer over the bottom edge of the part until the pointer looks like this Hold down the mouse button and drag the line up until the part disappears under the part above it or disappears at the top of the page Then release the mouse button Using named searches named sorts and layouts you have already created y
254. ry and then double click a topic 3 6 AppleWorks 5 User s Manual AppleWorks provides specialized button bars For example the Assistant button bar includes all the Assistants for the document type To switch to a specialized button bar choose the name of the button bar you want to display from the M menu on the button bar Showing hiding and positioning the button bar AppleWorks is preset to show the button bar above the document window To hide or show the button bar choose Hide Button Bar or Show Button Bar from the Window menu You can position the button bar above below or to the left or right of the document window or as a floating palette To change the button bar drag it so it becomes a free floating palette To change its size hold the mouse button down over the lower right corner of the palette and then drag the corner diagonally until the button bar is the size you want To change its position drag it to where you want it to go You can also choose Button Bar Sdup from the menu on the button bar and then choose an option from the Position pop up menu Customizing the button bar To customize the button bar choose Button Bar Setup from the ha menu on the button bar and then choose one of these actions To Do this Increase or decrease the number Type a number for rows or columns up to 20 of rows or columns of buttons Show or hide the palettes or In the Show Popups and Indicators areas select or d
255. s In the Help index see gt slide shows running To show your slide presentation choose Slide Show from the Window menu In the Slide Show dialog box click Start Tip Press Ctrl as you choose Slide Show to bypass the Slide Show dialog box and go directly into the slide show The slide show runs with the options set in the Slide Show dialog box See Setting up slides on page 9 17 To advance to the next slide press Space bar To return to the previous slide press Shift Space bar To stop the slide show at any time press q When you re finished with the slide show click Doneto save any settings you changed or click Cancel to restore the original settings Merging data into documents mail merge In the Help index see gt found set gt mail merge You can insert information from a database document into another document or frame by performing a mail merge You can merge a database document with a word processing document to create a form letter that includes personalized information for each recipient for example Dear Chris instead of Dear Customer a spreadsheet document or frame to create a report that s easy to update or to include a price list in a brochure K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 9 20 AppleWorks 5 User s Manual a text frame to print an envelo
256. s To add a record choose Browse or List from the Layout menu and then click In the Help index see on the Default button bar or choose New Record from the Edit menu gt New Record command AppleWorks displays the record in the current layout and increases the record number in the status area by one You can quickly add a new record by typing Ctrl R AppleWorks adds new records after all the records in your database To view records in a particular order regardless of the order in which you entered them in the database you can sort them See Sorting records on page 8 21 Changing the tab order The tab order is the order in which you move from one field to the next when In the Help index see you press Tab in Browse mode The tab order is preset to the order in which you place the fields on the layout Changing the tab order does not rearrange gt tabbing the fields it simply changes the order of field selection when you press Tab To change the tab order choose Browse from the Layout menu and then choose Tab Order In the Tab Order dialog box click Clear and then move the field names into the Tab Order list in the order you want data entered into them To move a name click the field name in the Field List and then click Move Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Database 8 15 Tip To change the tab o
257. s and paint menus As you work with frames keep the following points in mind You can also place text spreadsheet or paint frames in a drawing by choosing them from a library See Using libraries on page 3 17 To switch between working in a frame and the rest of the document click the area in which you want to work You can add an equation to a text frame in a draw document See Typing equations on page 4 5 To display handles on a newly created frame to treat it as an object click outside the frame You can link frames so that their contents are connected For example have text flow from one frame to another by linking the frames See Linking frames on page 9 24 Drawing 5 21 Creating links in draw documents When you plan to use an AppleWorks draw document onscreen on the In the Help index see Internet or World Wide Web you can select an area of the document and gt book marks create a link a connection or jump to a different area of the same document gt links a different document or a document or other information on the Internet To create a link in a draw document select text in a text frame a spreadsheet cell in a spreadsheet frame paint image paint frame or graphic object and then create the link You can place all types of links document links URL links and book marks anywhere in a draw document For more information see Creating links on page 9 1 To creat
258. s creatin ie i Important Before you begin be sure you understand the information in the previous sections of this chapter 1 Click on the Default button bar to create a new document or click S to open an existing document If you don t see the button bar choose Show Button Bar from the Window menu 2 In the document window press Ctrl semicolon to show formatting characters such as carriage returns and spaces 3 Create the document with the text and art you want posted to the Web To Do this Apply a style to text Select the text to format and then click any style from the stylesheet palette Select the text and then click to make the text bold or click to make the text italic Don t use underline which is a convention used to indicate a link Apply a type style to text Organize information into a numbered or bulleted list Choose styles from the pop up menu Use Harvard Legal or Number for numbered lists use Diamond Bullet or Checklist for bulleted lists Insert a horizontal line to separate sections of text Place the insertion point where you want the line to begin Choose Insert Page Break or Insert Section Break from the Format menu AppleWorks ignores automatic page breaks when you save the document as HTML Add a table Use an inline or floating spreadsheet frame Insert a picture See Adding pictures on page 11 5 Create a link from your document t
259. s Manual Your changes affect selected objects If you choose from the fill and pen palettes when no objects are selected AppleWorks applies the settings to the next objects you create To choose from a fill or pen palette hold down the pointer on the palette control and then drag the pointer to your selection Example To Select the object s and choose before and after Change the width color From the pen width pen color and pen or pattern of a line or pattern palettes O E border nn object or frame gradient or texture of an gradient from the fill gradient palette or a object texture from the fill texture palette You can t add patterns gradients or textures to spreadsheet frames Hide a line or border None from the pen width palette O Show a hidden line A line width from the pen width palette 123 or border Make a line object or The transparent icon amp from the pen frame transparent pattern palette for a line or the fill pattern S palette for an object or frame Add change or remove An arrowhead or Plain Line from the an arrowhead arrowhead palette a Change the fill color of an A color from the fill color palette B B Change the fill pattern A pattern from the fill pattern palette a For information on customizing the palettes or using custom palettes from other applications see Creating custom colors patterns gradients and textures on page 5 18
260. s in areas of a document you want to return to create links to a different document include other applications in your documents and easily share data with other documents and applications This chapter gives instructions for using links styles frames master pages the slide show QuickTime and AVI movies mail merge Object Linking and Embedding OLE and macros All features including procedures buttons and troubleshooting are described completely in onscreen Help AppleWorks documents except database and communications documents can be linked When you plan to use an AppleWorks document onscreen or on the Internet or World Wide Web you can select an area of the document and create a link In AppleWorks there are three types of links book marks document links and Uniform Resource Locator URL links Use To Book marks Jump to a different area of the same document Document links Jump to a link within the same document or to a different document URL links Link to other information on the Internet or World Wide Web To create a link you select text a spreadsheet cell paint image frame or object such as a graphic object in a drawing and then create the link If a selection has more than one link assigned to it the last link assigned will be the active link For more information about links see the following sections or onscreen Help K Choose Index from the Help menu and type the first few letters o
261. s of the entry Double click the entry and then double click a topic 7 14 AppleWorks 5 User s Manual Using named cells in formulas Once you ve named cells and ranges you can use the names in place of cell In the Help index see addresses in formulas You can also use a name in a formula before it has been gt formulas spreadsheet defined to refer to a particular cell or range For information on entering gt named cells and ranges formulas see Working with formulas on page 7 20 and onscreen Help To Do this Use named cells or ranges in Select a cell and begin typing the formula Then add a formula named cells or ranges where you would normally add cell and range addresses To add a named cell or range to a formula choose the name from the menu in the entry bar You can also type the name directly into the formula Enter named cells or rangesina Select a cell and begin typing the formula Then type the formula before you define the name you want to define and finish entering the names formula You see NAME in the cell because you haven t assigned the name to any cells yet Assign a name to a cell or range Select the cell or range to name and choose Define Name from the menu in the entry bar In the Define Named Range dialog box choose a name from the pop up menu and then click Define Replacing cell references with named cells You can replace named cells or ranges such
262. s templates stationery on page 2 10 Ifyou select an object on a normal page not a master page and choose Move To Back from the Arrange menu the object may move out of sight behind an object on the master page For more information about slides see Creating a slide presentation on page 9 16 Adding pages to a draw document By setting up your draw document to use multiple pages down and across you can produce a large drawing or newsletter or draw an object larger than one page You can drag objects from page to page until you have the arrangement you want In the Help index see gt Document command To change the number of pages in a draw document choose Document from the Format menu In the Document dialog box type values in the Pages Across and Pages Down boxes and then click OK Creating custom colors pattems gradients and textures To customize colors patterns gradients and textures in AppleWorks you can In the Help index see add colors patterns gradients and textures to the fill palettes gt editing colors and gradients gt editing patterns and textures gt palettes preferences use 256 color palettes from the Palettes folder which is in the AppleWorks 5 folder or other applications add colors and patterns to the pen palettes Each palette has its own editor that you open by double clicking a color pattern gradient or texture in a palette Complete instructions
263. san et Text overflow indicator Link indicator Continue indicator Linked text frames Continue indicator Linked spreadsheet frames Continue indicator Linked paint frames 9 26 AppleWorks 5 User s Manual In the Help index see gt frames formatting gt frames linking When you create linked frames keep in mind the following a You can create linked frames in a word processing spreadsheet draw or database in Layout mode document but you can t link frames in a paint document You can link frames of the same type but you can t link frames of different types For example you can t link a text frame to a spreadsheet frame a You can link an existing frame to a new frame you create but you can t link two existing frames to each other To link frames select the arrow pointer from the tool panel If you don t see the tool panel choose Show Tools from the Window menu Then choose Frane Links from the Options menu Select the text A spreadsheet or paint tool from the tool panel and drag the pointer to draw a frame Click once outside the frame To draw a text frame in a word processing document or a spreadsheet frame in a spreadsheet document press Alt as you draw the frame Click the continue indicator and then draw the next frame After you draw the frames you can resize them enter and edit information in them and arrange the linked frames in your document V
264. save or close a library you choose commands from the File menu on the library palette To From the library palette s File menu choose Save a copy of a library or rename Save As a library Save a library you ve previously Save saved Close a library Close Tip You can open libraries more quickly if you store them in the Library folder If a library is in the AppleWorks Libraries folder in the same folder as the AppleWorks application you can open that library by choosing Library from the File menu and then choosing the name of the library Working with the library palette In the Help index see gt libraries items in To Do this Add an item to a library Select the item in the document and click Add on the library palette Use a library item in a document Select the item from the library palette and click Use You can also drag the item from the library to the document Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic To Find a library item Basics 3 19 Do this If necessary click the triangle in the lower left corner of the library palette to expand the palette Type the item s name or a partial name in the Name box and then click Find Rename a library item If necessary click the triangle in the lower left corner of the library palette to expand the palette Select the item in the library p
265. se the stylesheet palette to create edit and apply styles Some style types are more complex than others For example outline and table styles contain a series of substyles with their own set of properties formatting options To show the stylesheet palette click 4s on the Default button bar or choose Show Stylesheet from the Window menu To view the properties of a style click Edit on the stylesheet palette and select the style you want to view Click Done when you re finished Stylesheet x Edit Style File Edit File Edit You see a v Bullet q checkmark Checklist q Base Style None next to the Default q Para 1st Line Indent O in Checklist currently Footer q Para Left Indent 0 5 in Default used style Footnote q Para Topic Label Bullet Formatting options peeee iene for the selected style Bullet you can edit Fonts Number 1 these options Header v Outline Stiles gt Diamond D Harvard E The quick brown fox b agal ae a To show or hide a sample Stylesheet ready for use b Table Sites E of the selected style choose Show Sample or Hide Sample from the stylesheet palette s Edit menu Stylesheet being edited The four style types are represented by symbols on the stylesheet palette Style type and symbol Description Example s Basic no symbol Formats text numbers objects and spreadsheet cells Lorem Sets paint fill and pen attributes Lorem i J Basic styles contain all style Lorem infor
266. see gt hiding gt resizing spreadsheet cells To resize all the rows or columns in a range by the same amount start by selecting multiple rows or columns Then specify a size or use the mouse To resize rows or columns by specifying a size select the rows or columns to change Then choose Row Height or Column Width from the Format menu type anew measurement type 0 to hide the row or column or select Use default to revert to the default row or column size and then click OK Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Resize pointer To Resize a row or column Spreadsheet 7 17 To resize or hide rows or columns by using the mouse move the pointer to 1 the bottom of the row heading or to the right edge of the column heading to change The pointer becomes a double arrow P Do this Drag the pointer until the row or column is the desired size Hide a row or column Drag the pointer up or to the left until the row or column disappears Restore a hidden row or column Drag the pointer down or to the right until the row or column reappears Resize rows and columns to the smallest size that holds the data Double click the divider at the bottom of the row heading or at the right edge of the column heading You see the double arrow when you re in the right place Inserting and deleting cel
267. set the layout margins yourself For more information see Setting margins on page 3 16 Closing up space when you print In the Help index see gt printing labels When you print labels unused spaces created by blank fields are closed up and don t print When you print from any other layout field data is preset to print as it appears on the screen To change the layout of the data when it prints choose Edit Layouts from the Layout menu Select a layout from the Current Layouts list and then click Modify In the Layout Info dialog box select the settings you want and then click OK You can control the number of columns and close up unused spaces to the left of or above fields Your settings apply to the entire layout and not to just the selected fields So that space closes as you intended make sure that fields don t touch each other you align fields first select the objects to align and choose Align Objects from the Arrange menu fields to close up are the exact same size X Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Chapter 9 Beyond the basics Creating links In the Help index see gt links Use the features covered in this chapter to help you make the most of AppleWorks With these features you can combine different document types make presentations automate the way you work create book mark
268. sh 6 5 Bucket See Filling Paint bucket Bulletin boards 10 2 Bullets 4 11 Business Cards Assistant 2 5 Button bar See also Buttons changing number of rows 3 6 creating new 3 7 Default 3 5 displaying pop up menus 3 6 moving 3 6 positioning 3 6 showing and hiding 3 6 switching 3 6 Button fields described 8 8 finding 8 25 8 27 Buttons Cc See also Button bar adding and removing 3 6 creating new 9 28 described 3 5 editing 9 29 macros for macros Calculating formulas 7 24 Calculation fields 8 9 8 10 8 11 Calendar Assistant 2 5 Cascading windows 3 3 Cell range described 7 5 entering in formulas 7 23 7 28 naming 7 12 printing 7 20 setting in charts 7 30 Cells active 7 3 7 25 Choose Index from the Help menu and scroll to the entry Then choose a topic from the list and click Go To Topic l 2 AppleWorks User s Guide address for 7 6 borders adding 7 18 data in deleting 7 8 7 17 entering 7 5 sorting 7 11 working with 7 6 7 7 7 8 deleting 7 17 filling automatically 7 8 grid 7 3 7 19 7 20 inserting 7 17 linking 7 34 locking protecting 7 6 names for 7 13 objects in 3 10 references to described 7 22 entering 7 23 examples 7 25 selecting 7 5 Certificate Assistant 2 5 Chapters adding to a document See Sections Characters counting 4 31 Charts See also Spreadsheet documents Spreadsheet frames borders on 7 32 copying or cutting 7 30 creating 7 29 deleti
269. sing documents 4 34 Linking Web pages links to Uniform Resource Locator URL 11 5 Links See also Uniform Resource Locator URL creating document links 9 2 to same or other document 9 2 to Uniform Resource Locator URL 11 5 creating to same or other document 2 9 deleting 9 4 described 9 1 editing 9 3 going to names in document 9 4 in draw documents 5 21 opening linked documents 9 3 linked Uniform Resource Locator URL 11 7 11 8 printing documents with 9 3 sorting names 9 5 using in word processing documents 4 34 using in draw documents 5 21 using in paint documents and frames 6 14 using in spreadsheet documents 7 34 Links palette 9 2 List mode database 8 2 8 17 8 19 Lists creating in text documents 4 11 of names and addresses 2 5 of values database 8 8 Locking and unlocking objects and frames 5 16 spreadsheet cells 7 6 7 12 M Macros described 9 29 shortcut buttons for macros state for 3 2 Magic wand 6 7 Magnified view See Zooming Mail merge See Merging data Mail electronic See Electronic mail Mailing labels See Labels Make Table Assistant 2 5 4 18 Making tables 2 5 Margins See also Indenting setting 3 16 viewing 3 11 3 16 Master pages 5 17 Matching records 8 26 Memory 6 14 Merging data 7 5 9 19 9 22 Microsoft Exchange for sending and receiving electronic mail 11 10 Minimized documents 3 3 Modified in status bar 3 2 Mouse control preferences 3 21 Movies 8 9 AVI 8
270. staurants then type the value in double quotation marks A selected or Click the field name and click Reviewed true deselected the operator Then type true checkbox field to find selected fields or false to find deselected fields Selects the reviewed restaurants A value that s Click the AND logical logical2 AND Avg Price gt 5 Avg Price lt 15 more than one function and then replace value and less than _ logical logical2 with the values Finds the restaurants with meal prices more another value you want separating each witha than 5 but less than 15 comma A date that is later Click the field name click the gt than the specified operator and then use the date TEXTTODATE function to specify the date Date visited gt TEXT TODATE 12 31 96 Finds the restaurants visited in 1997 Working with layouts When you work with a database in Browse mode you see the fields arranged in a layout an arrangement of fields field labels and other objects that determine the way data looks when it s displayed and printed AppleWorks automatically creates the standard layout you see in Browse mode when you create a database You can change the layout and create additional layouts for the same data each one for a different purpose Understanding layouts You create and work with layouts in Layout mode You can use all the drawing tools and commands available in AppleWo
271. style to the stylesheet palette 1 Click the New button on the stylesheet palette 2 In the New Style dialog box type Centered Heading in the Style name box 3 Set the following options in the New Style dialog box Select Paragraoh for Style type Choose None from the Based on pop up menu Deselect Inherit document selection format if it is selected Click OK Click the center alignment control above the ruler Click BJ on the Default button bar or choose Bold from the Style menu Choose 18 point from the pop up menu or from the Size menu at the top of the screen N Oo oO A foe Click Done on the stylesheet palette The new paragraph style is added to the stylesheet palette Part 4 Apply the new styles to your document 1 Select the words Camping Supplies 2 Click Centered Heading from the pop up menu or on the stylesheet palette Editing styles In the Help index see gt styles editing Beyond the basics 9 13 3 Select the words at the campsite 4 Choose Bold Italic from the pop up menu or on the stylesheet palette Your letter should now look like this Camping Supplies Be sure to bring these things on our camping trip 1 Tent 2 Compass 3 Sleeping bags We llsee you af e campsitenext weekend Part 5 Remove a style 1 Select the words at the campsite 2 Click s8 on the Default button bar to show the stylesheet palette 3 Choose Unapply Bold Italic from
272. t Open the Web page document from which to create the link and then select the item to create the link from On the Internet or Default button bar click to create a link to another part of the same document In the New Book Mark dialog box create a link and then click OK New Book Mark x Name Type aname for the link Folder None x Cancel To test the link choose Show Links Palette from the Window menu and make sure Live Links is selected In an HTML file the area linked to a book mark appears underlined and the pointer changes appearance over the underlined area To view the book mark double click the underlined area Page 2 The pointer looks like this over a link Click the underlined area to go to the linked information Keep the following points in mind To reduce the amount of scrolling of your Web page create links to other areas of the same document You can also create URL links to other Web pages For more information see Creating document links on page 9 2 For information about changing a link see Editing links on page 9 3 and Deleting links on page 9 4 When you print a Web page with links the linked information isn t printed AppleWorks and the Internet 11 9 Saving a document in HTML format In the Help index see gt Web pages saving Once you have an AppleWorks word processing document that you want to post to the We
273. t on page 2 3 Linking to other documents In the Help index see gt links gt URL buttons When you plan to use an AppleWorks document onscreen or on the Internet or World Wide Web you can create a link a connection or jump from an area in a document to a different document different area of the same document Uniform Resource Locator URL the address of a document application or other information on the Internet K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 2 10 AppleWorks 5 User s Manual You select the text object such as a graphic object in a drawing spreadsheet cell paint image or frame from which to create the link and then specify the location to link to For more information see Creating links on page 9 1 To create a link to information on the Internet see Linking Web pages on page 11 5 Saving document formatting as templates stationery In the Help index see gt stationery Stationery is a template that you create once and then reuse many times Save a document as stationery whenever you spend time customizing a document and think you may want to use the same settings again For example you can create stationery to design your own custom letterhead a monthly newsletter or a customer tracking database that you and the rest of your company can use regularly Station
274. t index entries for relevant topics are listed here To look up an index entry in AppleWorks Help start AppleWorks choose AppleWorks Help Index from the Help menu and then scroll to the entry For complete instructions for using the index to onscreen Help see Using the onscreen Help index on page 1 5 Special information in this User s Manual looks like this Note Tip or titled messages give extra or helpful information about a subject Important messages alert you to situations that require attention such as an action that you can t undo Glossary terms are defined in this manual and AppleWorks Help They appear in italic in the this manual and underlined with a dotted line in Help Glossary terms are also listed in the this manual s index For example to find the definition of cell range look up Cell range described Introduction 1 3 Using AppleWorks Help AppleWorks Help completely documents all AppleWorks features As you become comfortable working with AppleWorks yov Il be able to find all the information you need in AppleWorks Help Opening and closing AppleWorks Help To open Help when AppleWorks is running click in the AppleWorks window Then press F1 to display the Contents screen or choose a command from the Help menu To see Choose Topic titles in a table of contents AppleWorks Help Contents An alphabetical list of index entries AppleWorks Help index Information on navigating a
275. t Thobi elm ed cera oa Hum dolore Fuatilia soare ey atin atwt odo Lom Ipam dor Atwnat dberbtre aw abp datai dia tion ze aw dpi tober dA util p m urdan em mode Sect Dds athe OM am Kure dolor intanrdracttin bulpartvs dl te mtaas od Mum dobre au Mun at Peal A storo arratona hut ode Loum Ipaa dolor situn at abv arbitrar wood ples sad dm rom mrad iird adst Hicrewtdetere mappa gua arodu Thoti aim rd mrin baria gd rotad ard hilon idia ae dt lebertad A utdlgdp m avdn cm m odo aout Ds rha OM am Kure dalorinharrirartt in badparhi ol tee mtaas od Hum does a Mun athe A storo awatin t oda Place the insertion point where you want to insert a section Lom Ipam dhe dtimat Lom Ipam doke Atina rinnat artros rvs nahat caupit redam a Aat EAA ara ah Insert asecond _ natai and AAA amore ai aN Seno incor column in the section Awdplticberd lA ut dyip audpltiober nid ut ilad Aaav de nan edooneyuet saw den oam odo anyut Du rha ol am hiure Dus athe ond am ure Page before section break Page after section break ra a ee In the Help index see gt columns text You add columns using the column controls or the Section dialog box Use the column controls to add or subtract equal width columns Use the Section dialog box to create variable width columns or to enter precise column widths For more information on adding columns see onscreen Help Creating and changing columns on page 4 20 and the previous section Numbering sect
276. t Used by ASCII text Most applications DBF dBASE files DIF Some spreadsheet and database applications SYLK Spreadsheet applications such as Microsoft Excel Note You can import a FileMaker Pro database document into Apple Works To do so export save the FileMaker Pro document as a DIF document Then import open the DIF document with AppleWorks You can also import an AppleWorks document into FileMaker Pro To do so export save the AppleWorks document as a DIF document and then import open the DIF document with FileMaker Pro When you import a FileMaker Pro or AppleWorks database document from the DIF format the field names are preserved Printing a database document You print a database document in Browse List or Layout mode In Browse or List mode the Print dialog box gives you the option of printing the current record or all visible records Database 8 39 Printing labels In the Help index see gt mailing labels You can print labels on continuous sheets or on individual sheets of label stock Before printing labels on label stock make one or more trial printouts on plain paper to make sure that the spacing is correct and all the text prints within the label boundaries You may have to make the fields in the layout slightly smaller to fit within the label AppleWorks sets the layout margins automatically when you use a preset Avery label layout If you print custom labels on a laser printer you must
277. ta as it s entered Erom Io J 5 Cancel_ Other field types such as pop up menus radio buttons serial numbers and value lists have different options Options for Popup Menu Field Department 2 x m Items for control Default Item Select the item that AppleWork Automatically Choose atomaticaly hooses Scrolling list of items Sese accountin a gt for a new record Label for control gt Department a Type a new field ltem Label name optional Type the items you want Marketing to appear as choices Modify Delete Ti ea For complete information on every field type available in AppleWorks see onscreen Help Defining calculation and summary fields You define a field type as a calculation or summary field when you want the value in the field to be the result of a formula A formula can include values from one or more other fields in the database operators functions and constant values In the Help index see gt formulas database Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Name of field that holds the formula Database 8 11 For example suppose you have a database that contains two number fields Qty Sold and Price and one calculation field Total You can set up a formula in the calculation field to multiply the values in the two number fields The
278. te To change the appearance of text in selected rows and columns in List mode see Moving columns and formatting data on page 8 19 For more information about text attributes see Changing text appearance on page 4 7 Resizing rows and columns When you first choose List mode you see data in rows and columns of In the Help index see uniform size To see more data resize the rows or columns gt List mode To resize rows and columns move the pointer to the bottom of the row heading or to the right edge of the column heading you want to resize The pointer changes to a double arrow p or If your pointer looks different move the cursor until it s directly over the row or column border Then drag the pointer to the right or down until the row or column is the size you want Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Customer Bottom of row heading Adventure Right edge of column heading Customer B Street Before 00 Aspen Adventure Resized row Database 8 19 Street Customer k Resized columns Moving columns and formatting data As you work in List mode you can change the position of a column or the appearance of data in a column or row In the Help index see gt List mode To Move a column Do this Move the pointer to the co
279. ted formats Text DBF DIF Microsoft Excel or SYLK to save the document You may be able to open the document in any application that supports that format Import convert a Choose Open from the File menu In the Open dialog box select document created with a the appropriate document type from the Document Type and different application Files of type pop up menus Select the file and then click Open The original document is unchanged Insert an entire document In the AppleWorks document click where you want to insert such as clip art the file and then click on the Default button bar or choose commercially produced Insert from the File menu In the Insert dialog box select the file graphics into an type from the Files of type pop up menu choose the file and AppleWorks document then click Open To insert information into fields of an AppleWorks database see Importing data from other documents on page 8 37 Open a document created by Click on the Default button bar or choose Open from the AppleWorks for Macintosh File menu choose Show All Files from the Files of type pop up menu choose a document and then click Open You can import documents created in other applications using Object Linking and Embedding OLE For more information see Including other applications in your documents OLE on page 9 30 K Choose Index from the Help menu and type the first few letters of the entry Do
280. the Edit menu on the stylesheet palette You can instantly change the format of an entire document by editing styles When you edit a style all the text objects or cells that use that style are updated You can change a style s properties change the style on which the current style is based or rename the style Note You can edit any style on the stylesheet palette regardless of the type of document you re in However you can t apply the style until it s appropriate to do so For example if you create a table style you don t see the table style until you re working in a spreadsheet document or frame To show the stylesheet palette click 4s on the Default button bar or choose Show Stylesheet from the Window menu To edit a style click the Edit button on the stylesheet palette and select a style or substyle from the scrolling list on the left The pointer changes to g Then use the document controls you d normally use to format text and objects such as the tools palettes ruler paragraph controls and menu commands K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 9 14 AppleWorks 5 User s Manual Edit Style x Fie Edit Properties v Bok Italic Base Style None Select a style to edit EE ati ei TERRE Text Style Bold As you edit the Sagas style you see your Paragraph i changes here Body Bullet Checklist
281. the entry Double click the entry and then double click a topic Drawing 5 17 Creating a master page In the Help index see gt master pages gt stationery A master page is text or graphic information that repeats on every page of a draw document Unlike a header or footer information on a master page can occupy the entire working area of the page and stays behind everything else on the pages of a document Agenda so nena Bu n Future plans Master page Document pages Consider using a master page to show a company logo or text such as Draft or Confidential in text frames behind the main body of text create a border around the contents of each page add a common background to slides in a presentation To create a master page choose Edit Master Page from the Options menu You see Master Page in the page indicator at the bottom of the window Add the page elements you want to appear on every page of the document Then choose Edit Master Page again from the Options menu x Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 5 18 AppleWorks 5 User s Manual Keep these points in mind To see master page elements as you work on your document choose Page View from the Window menu You can save a document with a master page as stationery a reusable template See Saving document formatting a
282. the first time you can resave it periodically to keep your work up to date a save it with a different name to create two identical documents make a backup copy regularly to protect your data Opening a document When you open a document it looks like it did when you last saved it For In the Help index see information about opening and using stationery see Saving document gt opening formatting as templates stationery on page 2 10 To Do this Open an AppleWorks document Click lt on the Default button bar or choose Open from the from within AppleWorks File menu choose the document and then click Open The names of the last four documents you opened or saved appear at the bottom of the File menu To open one of these documents select its name If you re asked for a password type the password and then click OK For more information about passwords see Protecting documents with passwords on page 2 14 Open an AppleWorks document Double click the document icon in Windows Explorer or from Windows My Computer or click the Start menu choose Documents and then choose the document name AppleWorks starts up if it s not already running and opens the document If you re asked for a password type the password and then click OK For more information about passwords see Protecting documents with passwords on page 2 14 There are many ways to open documents from Windows For more
283. then double click a topic 5 6 AppleWorks 5 User s Manual Selecting and deselecting objects An object or frame must be selected before you can move or change it As soon as you release the mouse button after drawing an object AppleWorks selects the new object and adds handles Handles indicate an object is selected R To select a transparent object 4 Click the object s line or border An object remains selected until you deselect it or select another object To Do this Deselect an object Click anywhere outside the object For information on transparent objects see Changing lines borders colors patterns and textures on page 5 9 Select a deselected object Click the selection tool and then click anywhere on the object Select more than one object at a time Hold down the Shift key and click each object Select a transparent object Click any of the object s outlines For more information on selecting objects see onscreen Help For information on In the Help index see Other ways to select multiple objects selecting objects Deselecting one object while several are selected Selecting all objects of a certain type Selecting objects within a frame Changing the number of handles displayed on a graphics preferences selected object Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then doubl
284. ting 11 9 opening 11 9 saving exporting as 11 9 HyperTerminal 10 1 Hypertext links See Links Hypertext Markup Language HTML See also Electronic mail HTML files Internet Web pages World Wide Web described 11 1 Hyphenation 4 30 I Icons button bar See Buttons finding names of 1 7 Images combining 6 11 described 6 4 pasting 3 10 selecting 6 7 storing in libraries 3 17 transforming 6 9 6 11 working with 6 7 6 8 6 9 6 10 6 11 Importing See also Inserting databases 8 37 documents 2 15 HTML files 11 9 styles 9 16 Indenting See also Margins outline topics 4 16 paragraphs 4 10 Index Help 1 5 Indicators frame link 9 25 Inferior text 4 7 Inline pictures and frames 4 31 Insert Footnote Assistant 2 5 4 26 Inserting See also Importing cells columns and rows 7 17 clip art 2 15 5 19 6 13 column breaks 4 21 database data 8 15 8 37 parts 8 34 8 36 documents 2 15 footnotes 2 5 4 26 page breaks in documents spreadsheet 7 19 word processing 4 21 page numbers 3 15 pictures in database fields 8 14 database layouts 8 32 drawings 5 19 6 13 paintings 6 13 spreadsheets 7 32 word processing documents 4 31 sections in a word processing document 4 23 Insertion point 4 2 Installing dictionary or thesaurus 4 31 Internet See also Electronic mail HTML files Hypertext Markup Language HTML Web pages World Wide Web described 11 1 sending and receiving electronic mail 11 10 In
285. tion You can set up and run a slide presentation from AppleWorks You use the In the Help index see AppleWorks application as the slide projector the pages of an AppleWorks gt editing master pages document as the slides and your computer monitor as the screen gt settings documents gt slide shows creating In an AppleWorks presentation you can set an automatic time advance for the slides include QuickTime and AVI movies show the same series of slides repeatedly add a background using a master page Creating slides To create slides open or create a document You can make a presentation from any document type except communications Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Beyond the basics 9 17 In a word processing document the number of slides matches the number of pages For all other document types you need to set the number of slides you want to include in your presentation For this type of document Do this Draw Choose Document from the Format menu and then type the number of pages one page per slide across and down The slide show is preset to run across first and then down Paint Choose Document from the Format menu and then type the number of pixels 72 to an inch across and down Larger paintings may appear on multiple slides Spreadsheet Choose Document from the Format menu
286. tion about summarizing data see Presenting and summarizing data with parts on page 8 34 8 12 AppleWorks 5 User s Manual Adding changing and deleting fields You add change and delete database fields in the Define Fields dialog box To select a field name click the name in the Field Name list EE z In the Help index see gt Define Fields command To Add a field Choose Define Fields from the Layout menu and then Type the name of the new field choose a type from the Field Type pop up menu and then click Create Delete a field Click the field name in the Field Name list and then click Delete Change a field name Click the field name in the Field Name list type a name and then click Modify Change a field type Click the field name in the Field Name list choose a type from the Field Type pop up menu and then click Modify Change a calculation or summary formula Click the field name in the Field Name list click Modify make your changes to the formula and then click OK Change field entry options Click the field name in the Field Name list click Options make your changes in the dialog box and then click OK Entering data in fields In the Help index see gt fields changing gt fields entering data gt fields navigating gt records adding When you finish defining the database fields you see them displayed in Browse mode in a standard layout i
287. tion you ve already created double click the equation and then make your changes in the equation editor For more information choose Equation Editor Hdp from the Help menu Note When you finish adding an equation you can format move resize rotate and so on the equation as you can with a draw object See chapter 5 Drawing for more information about working with draw objects Selecting text In the Help index see gt selecting text Before you can change text you must select it To select text move the pointer to the beginning of the text you want to select and then drag to the end of the text Lorem ipsum dolor molestie consequat al Selected text delenit augue duis You can also select text by using the following methods To Do this Select a word Click twice on the word Select a line Place the pointer in the line and click three times Select a paragraph Place the pointer in the paragraph and click four times Extend a selected range of text Hold down the Shift key move the pointer and click K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 4 6 AppleWorks 5 User s Manual To Do this Select everything in a document or frame Choose Sdect All from the Edit menu Select a text frame as an object Select the arrow pointer and click the text frame When you select a text frame as an object
288. tions menu is checked With the item selected choose Text Wrap from the Options menu and then choose Regular or Irregular or click on the Default button bar For more information see Linking frames on page 9 24 Remove the text wrap effect With the object selected choose Text Wrap from the Options menu and then choose None Tip If the text doesn t flow smoothly around the object the object may be a PICT file If it is you see Ungroup Picture in the Arrange menu To modify the object select it and then choose Ungroup Picture from the Arrange menu If the ungrouped picture has a border you can delete the border by selecting the object and choosing None from the pen width pop up menu 4 34 AppleWorks 5 User s Manual Creating links in word processing documents When you plan to use an AppleWorks word processing document or a document that contains a text frame onscreen or on the Internet you can select an area of the document or frame and create a link a connection or jump to a different area of the same document a different document or a document or other information on the Internet In the Help index see gt book marks gt links To create a link in a word processing document select text and then create the link For more information see Creating links on page 9 1 To create a link to information on the Internet see Linking Web pages on page 11 5 Choose Ind
289. tly saved version of your document choose Revet from the File menu To Delete an area Do this Select the area and then press Backspace Delete part of an image Drag the eraser 2 Delete all images in a painting Double click the eraser Copy or cut an area and paste it elsewhere Select the area and from the Default button bar click or E or choose Copy or Cut from the Edit menu To place the image in the document choose Paste from the Edit menu Duplicate an area Hold down Alt as you drag the selected image Duplicate an area continuously Hold down Ctrl Alt as you drag the selected image Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Painting 6 9 Magnifying an image be SSS In the Help index see gt Zooming in and out You can change the zoom level magnification or reduction of a paint document as it s displayed in the window Zoom in to edit pixels Zoom out to see more of the painting To Do this Zoom out or in Click the zoom out id or zoom in J control at the bottom of the window Zoom out quickly to 800 Double click the pencil F Return to 100 view actual size Choose 100 from the zoom percentage pop up menu 100 or double click the pencil Transforming a selection You can change an image by transforming its shape changing its orientat
290. tore a selection to its default state choose Default on the pop up menu For spreadsheets choose Default SS To restore an item to its original state choose Unapply Style from the Edit menu on the stylesheet palette The name of the command varies depending on the style you applied Note You can set up AppleWorks to apply several styles at once For example applying a Bold Italic style to text already formatted with the Number style gives you bold italic numbered text To set this option up choose Compound Styles from the stylesheet palette Edit menu Creating a style In the Help index see gt styles using You can create your own custom styles in any AppleWorks document Note Although you can create a style at any time you can t apply the style until it s appropriate to do so For example if you create a paragraph style while you re in a blank draw document you don t see the paragraph style in the stylesheet palette until you create a text frame K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 9 10 AppleWorks 5 User s Manual Select the type of style you want to create Click to use the properties of the item selected in your document In the Help index see gt styles editing Text Font Helvetica Text Size 12 pt Text Style Plain Text Color Cell Format General Cell Decimal Places 2 Sc
291. troduction to AppleWorks 1 1 Inverting images 6 11 ISP internet Service Provider 11 2 Italic text 4 7 Items library See Libraries J Justified text 4 12 K Keys order 7 11 Keywords in document summary 2 13 L Labels mailing creating 2 5 8 30 described 8 29 printing 8 39 outline 4 13 4 16 paragraph 4 11 spreadsheet chart 7 29 7 30 Labels Assistant 2 5 8 30 Lasso 6 7 6 14 Layout mode database 8 2 8 27 Layouts See also Database documents Fields Records changing 8 31 8 32 columnar 8 16 8 17 8 29 8 30 creating 8 29 8 30 deleting 8 32 described 8 27 duplicating 8 32 naming 8 29 8 32 selecting 8 30 standard 8 34 types of 8 28 8 29 viewing 8 31 Leading grand summary See Parts database Leading in text 4 12 Legends spreadsheet chart 7 29 7 32 Letters in page numbers 3 15 Levels subtopics in outlines 4 13 Libraries 3 17 3 19 5 19 Library items alphabetizing 3 19 Line breaks 4 4 Line charts 7 28 Line spacing in text 4 12 Lines Choose Index from the Help menu and scroll to the entry Then choose a topic from the list and click Go To Topic See also Objects changing 5 10 custom width for pen width palette setting attributes for painting 6 6 text counting 4 31 tools for drawing 5 4 Lines in HTML files 11 4 Link indicators 9 25 Linked frames 9 24 9 26 spreadsheets and charts 7 29 Linking Web pages to Uniform Resource Locator URL 11 5 Linking objects in word proces
292. ts that can be selected moved or changed while retaining their individual identity For example when one object in a drawing overlaps another the back object remains intact Paintings are made of many separate pixels Shapes drawn in a painting lose their individual identity and become part of the collection of pixels For example when one image in a painting overlaps another the back image is permanently replaced with the front image In a painting changes affect only selected pixels A painting can be a document or a frame You use the same tools and commands any time you work with a painting whether it s a document or a frame Creating a painting In the Help index see gt documents creating gt paint documents gt paint tool To create a Do this Example Blank paint document Choose New from the File menu select Painting and then click OK Or click on the Default button bar If you don t see the button bar choose Show Button Bar from the Window menu Paint frame within another Select the paint tool choose type of document except Show Tools from the Window communications menu if necessary move the pointer into the working area of the document and then draw the acl te paint frame Apaint frame ina word processing document Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topi
293. tting cell data 7 8 formats 7 10 described 3 10 formats cell 7 10 paragraph 4 13 library items 3 19 objects 3 10 5 9 styles 9 15 Patterns See also Palettes changing in charts 7 32 copying from objects 5 11 setting for database fields 8 33 images 6 6 objects 5 10 Pencil 6 5 Perspective adding to images 6 9 Pick Up command 6 11 Pictures adding to database fields 8 9 8 14 database layouts 8 32 drawings 5 19 headers and footers 3 13 HTML files 11 5 libraries 3 17 paintings 6 13 spreadsheets 7 32 word processing documents 4 31 formatting in database fields 8 33 inline 4 31 wrapping text around 4 32 Pixels changing size of 6 13 described 6 1 6 13 editing individual 6 9 PLAY in status bar 3 2 Point of origin for paint frames 6 4 spreadsheet frames 7 4 Pointer See Arrow pointer Polygons See also Objects closing 3 21 connecting 5 13 reshaping 5 13 tools for drawing 5 4 Pop up menus in database fields described 8 8 finding 8 25 8 27 selecting 8 18 Postal codes in databases 8 7 Preferences 3 20 Presentation Assistant 2 5 Previewing documents to be printed 2 16 3 11 Printing choosing page size and orientation 3 16 documents database 8 38 described 2 16 merge 9 22 spreadsheet 7 20 with links 9 3 Help topics 1 5 2 16 labels 8 39 spreadsheet headings 7 20 Protecting spreadsheet cells 7 6 7 12 PT document type 2 3 3 9 Q QuickTime movies See Movies R Radio button fields described
294. tting information Paragraph Formats entire paragraphs with any attributes available to you for example indents paragraph labels and basic style attributes Outline Formats paragraphs as topics in an outline You can modify the preset outline styles or create your own For Text _ EEE EE SESS SE In the Help index see gt styles Objects Basic Saves combinations of colors patterns textures gradients pen widths and text wrap attributes K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 9 8 AppleWorks 5 User s Manual For This style type Does this Paint Basic Resets the fill and pen palettes for the next image you documents paint or resets text attributes for the next text you type You can t select part of a painting and apply a style Instead use styles to set the pen and fill palettes before you begin Spreadsheet Basic Formats individual cells with any format available to documents and you in a spreadsheet frames Paragraph Formats entire paragraphs in individual cells with any attributes available to you for example indents paragraph labels and basic style attributes Table SS Formats a selected table or range of cells with varying fonts font sizes styles alignment options background colors borders and date time and number formats Database Basic Formats text and objects in Layout
295. ttom Left and Right margin boxes and then click OK To show or hide the margins and page guides select or deselect Show margins and Show page guides in the Document dialog box These options are available only when page view is on To turn on page view choose Page View from the Window menu Changing the page orientation and size In the Help index see gt paper size You can change how the page is oriented in the document You can also change the page size To change the page size choose Print Setup from the File menu choose paper options from the pop up lists and then click OK Your paper size options depend on the type of printer you re using To change the page orientation choose Print Setup from the File menu select an orientation and then click OK Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Using libraries In the Help index see gt libraries overview Drag the selection from the library into the document Basics 3 17 Orientation Portrait Portrait orients the page so it s tall C Landscape Landscape orients the page so it s wide Note Page Setup options may vary with different systems or printers For more information about Print Setup options see the documentation that comes with your computer and printer A library is a palette that stores items you
296. tton bar Double click the chart to change chart options You can create more than one chart for each spreadsheet or spreadsheet frame Updating chart data The chart is linked to the spreadsheet so when you change data in the spreadsheet AppleWorks updates the chart Copying or cutting and pasting a chart severs its link to the spreadsheet data If you then change the spreadsheet data AppleWorks won t update the pasted chart Changing chart options In the Help index see gt charts creating Y axis Series symbols Axes labels You can change the way data is plotted as well as the appearance of a chart s elements the title axes series series labels or series symbols Each type of chart this one is an X Y scatter chart contains most of the same elements Use this data to make the chart Title California poppy Eschscholzia Wi Germination rate Legend Series box ero rtH HD E X axis 0 50 100 Germination rate To revise an existing chart double click the chart or select the chart and choose Chart Options from the Edit menu K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 7 30 AppleWorks 5 User s Manual Sa aS SaaS SSeS In the Help index see gt charts modifying gt charts options In the Chart Options dialog box select chart options and ma
297. tures including procedures buttons and troubleshooting are described completely in onscreen Help When to use a spreadsheet Expense categories in rows months in columns Use a formula to calculate totals Use a spreadsheet when you want to organize text and numbers in rows and columns For example you can develop a budget analyze financial performance track loans mortgages and stock and bond performance maintain a checkbook schedule projects manage business and personal assets chart your children s growth and medical information produce profit and loss statements Add your own title Utilities Insurance Rent Telephone Supplies t i t i 500 1000 1500 2000 2500 Spreadsheet Chart based on first two columns of the spreadsheet 7 2 AppleWorks 5 User s Manual In the Help index see gt spreadsheets documents gt tables Spreadsheet basics You can also use a spreadsheet to present text in a table For example use a spreadsheet document to type a schedule or list or use a spreadsheet frame to format a table in a word processing document For more information about using a spreadsheet frame as a text table see Creating tables on page 4 18 Dear Laurie and Bob We re planning the following dinners for next week s camping trip Monday Lentil stew green salad strawbemes Tuesday Coq au vin fruit salad rhubarb pie Spreadsheet frame
298. types of objects Click to work with frames and objects Click to select a tool A Se 7 4 Hold down the mouse button as you drag the tool Use this tool To draw L Line tool Diagonal or straight lines To make straight lines hold down Shift as you drag the tool Co Rectangle tool Rectangles To draw squares hold down Shift as you drag the tool 2 Rounded rectangle tool Rectangles with rounded corners To draw squares hold down Shift as you drag the tool Oval tool Ovals To draw circles hold down Shift as you drag the tool Arc tool Arcs L amp Polygon tool Shapes composed of angles and straight lines L amp Freehand tool Curved lines as you would draw with a pencil or pen 4 Bezigon tool Shapes with Bezier curves and angles To draw a Bezier curve click the tool and then release the mouse button and drag the pointer Click at each place you want to turn the curve To end the object click twice EA Regular polygon tool Closed polygons with sides of equal length The eyedropper L is a special tool used to pick up and apply an object s attributes such as color and pattern For more information see Copying an object s attributes on page 5 11 Drawing 5 5 As you use the drawing tools keep the following tips in mind To Do this Limit movement of the line arc Hold down Shift as you draw Holdi
299. u type the number of columns and then click OK You can specify up to nine columns their widths equal or variable and the amount of space between each one To add or subtract columns of equal width click the increase columns or decrease columns control in the text ruler Click to subtract columns O 1 Jmj Click to add columns Shows the number of columns Important If your document already contains columns of variable width clicking the increase columns or decrease columns control changes them to equal width Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Text word processing 4 21 You can change a column s width and the space between two columns by using the mouse to drag the column guide border To Do this Example Change a Press Alt and move the pointer Lorem ipsum dolor feugiat nulla facillisis at r z molestie consequat ver eros et accu Qui column s width precisely over a column guide el illum dolore ev blandit praesent ut let until the pointer looks like this fengist nula vos ef poptatam sx delenit facillisis at ver ero3 augue duis Ut wisi HH Then press the mouse button and drag right or left Before Lorem ipsum eros etaccu Qui dolor molestie blandit praesent consequat el luptatum sril delenit illum dolore eu augue duis Ut wisi feugiat nulla vos enum ad mimin After column is moved left Cha
300. u type them AppleWorks is preset to show the text ruler in a word processing document If you don t see the ruler choose Show Rulers from the Window menu In the Help index see gt rulers Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Text word processing 4 9 Line spacing controls Column controls Pagoan controls Tab ae Paragraph and outline labels Left margin marker drag top part only First line indent and left margin irst line indent marker Right margin marker marker drag bottom part only To display the Paragraph dialog box choose Paragraph from the Format menu St re te Tip You can use preset paragraph styles supplied by AppleWorks or In the Help index see a paragraph styles you create to change a paragraph s formatting in one step gt styles For example you can apply a style to format paragraphs with hanging indents and bullets in the margin To show the stylesheet click on the Default button bar or choose Show Styleshee from the Window menu Then select the paragraphs to format and click Bullet To format a single paragraph click anywhere in that paragraph and click Bulle For information on applying styles or creating your own see onscreen Help and Using styles on page 9 5 Lorem ipsum A Select the text you want Dolor sit amet to change Nonummy nibh After F
301. uble click the entry and then double click a topic 2 16 AppleWorks 5 User s Manual Closing a document and leaving AppleWorks Always close documents and windows before you leave AppleWorks or turn off your computer To Do this In the Help index see Close a document Choose Closefrom the File menu gt closing Close all documents Hold down the Alt key while you choose gt Exit command Close from the File menu Leave AppleWorks Choose Exit from the File menu If you haven t saved changes in open documents AppleWorks asks if you want to save the new version Printing a document or Help topic To print the current document click amp on the Default button bar or choose In the Help index see Print from the File menu To print a current Help topic choose Print Topic from gt documents printing the File menu gt Help printing AppleWorks uses the default printer and print settings in Windows Control Panel You can change these settings for printing in AppleWorks if necessary Before you print you can preview a document on the screen and make necessary adjustments To Do this in AppleWorks Choose a printer Choose Print Setup from the File menu Change the page orientation Choose Print Setup from the File menu page size and other print settings Preview a draw spreadsheet Choose Page View from the Window menu database or paint document on Word processing documents always a
302. up menu created in a different application locate the document to import and then click Insert Customizing resolution and depth In the Help index see gt depth gt resolution A new paint document or frame is preset for a resolution of 72 dpi dots per inch The number and range of colors in the preset palette depends on the monitor you re using You can customize the resolution number of pixels per inch and depth the number of colors in the color palette for a paint document or frame using the Resolution amp Depth command in the Format menu For a complete description of how to do this see onscreen Help Working with large files In the Help index see gt increasing memory Your computer sets aside a certain amount of memory for AppleWorks If you re working on a paint document or other large document using many graphics or working on multiple documents AppleWorks may require more memory than is available K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 6 14 AppleWorks 5 User s Manual When you need to provide more memory for AppleWorks you may see this message Not enough memory to complete this operation For complete information on providing more memory see onscreen Help and the documentation that comes with your computer Changing the size of a painting In the Help index see gt s
303. uter using a cable To connect to an online service or remote computer or to connect directly to another computer turn on your modem and choose Open from the Session menu See the documentation that came with your computer for more information about setting up HyperTerminal and connecting to online services and other computers 10 4 AppleWorks 5 User s Manual Changing the communications program You can specify that AppleWorks run a communications program other than In the Help index see HyperTerminal when you click Communications in the New Document dialog gt preferences box Choose Preferences from the Edit menu In the Preferences dialog box choose Communications from the Topic pop up menu Click Change To located under AppleWorks Terminal Program In the New Communications Program dialog box select the program you want to run and then click Open Click OK to save the changes Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Chapter 11 AppleWorks and the Internet With AppleWorks you can open view and create documents that contain Hypertext Markup Language HTML on the Internet and the World Wide Web WWW or Web You can also create your own HTML files and place them on the Internet and the Web as Web pages to present information to people using the Web This chapter describes how to use AppleWorks to set up your compute
304. utline you can create a list such as a bulleted list or checklist See Adding bullets numbers and checkboxes to paragraphs on page 4 11 Creating an outline To create an outline choose an outline label from the pop up menu and 3 then type the first topic To add another topic at the same level as the current In the Help index see inc i i topic press Enter To add another topic indented to the left or to the right of gt topics outlines the current topic choose New Topic Left or New Topic Right from the Outline menu None Diamond Bullet I Planning I Planning I Planning Check Box Il Funding II Funding Choose an outline label A Grants Letter Caps First topic New topic New right topic Letter Numeric Roman Caps Roman To create a new line without a label press Shift Enter This is especially useful for creating a blank line within a numbered list without affecting the sequence of numbers a ULUL amp Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Text word processing 4 15 L Planning Last time this process took three months Unlabeled line Il Funding A Grants B Loang Modifying and removing outline labels To change the outline label for specific topics select the topics and choose the format you want from the P pop up menu I Planning I Planning I Funding II Fundi
305. utton bar choose Show Button Bar from the Window menu When you open a new database document you begin by defining fields The field definition consists of the field name field type such as text or number and other options Once you have defined the fields you make new records and enter values data in the fields K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 8 4 AppleWorks 5 User s Manual Example Creating a simple database In this section you set up an example database with two fields and three records Part 1 Start a new database document 1 If AppleWorks isn t running start AppleWorks as described in Starting AppleWorks on page 2 1 2 Click 8 on the Default button bar Or choose New from the File menu In the New Document dialog box select Database and then click OK You see the Define Database Fields dialog box where you set up database fields Define Database Fields 2 x Field Name Field Type New field names appear here Type the field names here Select a field type here Field Name Field Type Create l Delete ptior Type a field name and select a field type Part 2 Define two fields 1 In the Field Name box type Continent and then click Create 2 In the Field Name box type Count ry replacing the field name Continent and then click Create Field Name Fiel
306. utton bar choose Show Button Bar from the Window menu Create a text frame Select the text tool A choose within another type Show Tools from the Window of document menu if it isn t visible Then drag the I beam pointer diagonally in the working area of the document to draw a text frame and begin typing In a word processing Atext frame in a draw document document hold down the Alt key as you draw the frame About the word processing window When you open a word processing document you see the word processing In the Help index see menu bar button bar text ruler page guides and the insertion point The 4 A tools insertion point is a short blinking vertical line that shows where text appears gt rulers when you type or insert text gt word processing you typ Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic Word processing menus Text word processing 4 3 Text ruler Text insertion point File Edit Format Font Size Style Outline Window Help 18 x pariah for ie AAAA A Sl Se el 8 2 e eA Bl 7 Ul als al processing docile Al A 7 BI e ea and text frames Eea __ a Eaa a Baas oo x Tz Ts T4 Ts Te T7 x Ig i Margin Page guides Text in a word processing document looks the same on the screen as it does when it s printe
307. ve the OLE object To insert the object Do this As an inline object in text Click in the text to create an insertion point As a floating object inthe Click the arrow pointer to make the insertion point document disappear 2 Choose OLE Options from the Edit menu and then choose Insert OLE Object 3 Choose options in the Insert Object dialog box To Do this Create a new Click Create New select the type of object in the Object Type list and embedded object then click OK When the server application opens create the object When you finish choose Exit and Return from the server application s File menu the name of the command varies depending on the server application Insert an existing Click Create From File and then click Browse In the Browse dialog box embedded object select the file to insert and then click Insert In the Insert Object dialog box click OK Insert an existing Click Create From File and then click Browse In the Browse dialog box linked object select the file to insert and then click Insert In the Insert Object dialog box click Link and then click OK To display an OLE object as an icon instead of a picture click Display As Icon in the Insert Object dialog box K Choose Index from the Help menu and type the first few letters of the entry Double click the entry and then double click a topic 9 32 AppleWorks 5 User s Manual Working with OLE objects Once you ins
308. ype 12 3 5 in the entry bar 3 Click b to confirm the entry AppleWorks sums the numbers and displays the result 10 in the cell Tip To total the value quickly select the cells and click 2 on the Default button bar Example 2 Using cell references To sum three numbers using cell references 1 Type 75 150 and 725 as shown here 2 Click cell B3 type an equal sign in the entry bar and then click cells A1 A2 and Cl AppleWorks inserts the addition operator between each cell reference Your spreadsheet should look like this Address of the rator selected cell Operators Formula The formula s result goes in the selected cell 7 26 AppleWorks 5 User s Manual To change the formula for example to use a different operator use the text editing techniques described in Editing data on page 7 6 3 Click J to confirm the entry AppleWorks adds the numbers and displays the result 950 in cell B3 If the result doesn t appear as you expect check to be sure that you started the formula with an equal sign Working with functions AppleWorks provides functions or built in routines that you can use alone or include in a formula Use functions to perform computations such as summing a group of numbers or deriving a square root without having to type the entire formula You can use a function by itself in a formula or you can combine it with other values ope

AppleWorks 5 User`s Manual: for Windows 95/NT 4.0

Contents

Download Pdf Manuals

Related Search

Related Contents