Computer Tips

 
Visit us often.  Computer tips updated daily.  Click here to--> "Tell a friend" so they can get updated computer tips, too.  Please visit our clients, as they support the computer tips page.

If you would like to submit a tip send us an email with your tip to info@businesswebsitelinks.com.
  ______________________________________________________________

Tip: Use alignment guides to arrange slide elements (Presentations, 9/10/11/12)

• Placing objects in the same relative position across several slides doesn't have to involve a lot of guesswork. To more precisely align your slide elements, set up guidelines called alignment guides. These lines are moveable horizontal and vertical lines that appear on the screen, but not when you print or run the slide show. To display the alignment guides, first display the ruler by choosing View | Ruler from the menu bar. Then, drag a guideline from the appropriate ruler. For example, to set a vertical alignment guide, point to the vertical ruler and then drag to the right. Drag the red guideline to where you need it. You can use the horizontal ruler as a reference point. To remove a single guideline, drag it off the slide. To clear all the alignment guides, either right-click on a ruler and choose Clear Guides or choose View | Grid/Guides/Snap | Clear Guides from the menu bar.

Tip: Attach a live hyperlink to text in a Quattro Pro cell (9/10/11/12)

• When you enter a URL in a spreadsheet cell, such as http://www.businesswebsitelinks.com, Quattro Pro automatically changes the text to a hyperlink that you can then click on to open that website. Instead of seeing the cryptic URL in the cell, you might want to attach a hyperlink to more meaningful text, such as Latest Exchange Rate. To do so, select the cell that you want to contain the hyperlink and then choose Tools | Hyperlink from the menu bar. In the Text To Link text box, enter the text you want to appear in the spreadsheet cell. In the Link To File Or URL, enter the web address for the website you want to open. Click OK to complete the hyperlink. Now, the hyperlink text is underlined and in blue, just like any other hyperlink. Click on the text to open your default browser and display the website.

Tip: Split a WordPerfect table cell into multiple compartments (WordPerfect 9/10/11/12)

• Usually when you create a table, each cell holds one item. But on occasion, you might want more than one compartment within a table cell to hold separate but related information, such as a product name and price. When you split a cell, you can manipulate each sub-cell like a regular table cell. You can split cells horizontally (creating new sub-rows) or vertically (creating new sub-columns). To split a table cell, place the insertion point in the cell and choose Table | Split | Cell from menu bar. (In version 9, click on the Table button on the Table Property Bar and choose Split | Cell from the dropdown menu.) In the Split Cell dialog box, select either the Columns or Rows option button and then enter the number of sub-cells you want to create in the adjacent text box. Finally, click OK.

Tip: Rotate text in a WordPerfect text box (9/10/11/12)

• When you create documents that will be folded, such as a newsletter or brochure, you sometimes need to rotate text so it appears right-side up once you fold the page. You can do this if you place the text within a text box. First, create the text box by choosing Insert | Text Box from the menu bar. Next, right-click on an edge of the text box and choose Content from the QuickMenu to display the Box Content dialog box. In the Rotate Text Counterclockwise panel, choose the option button for the amount of rotation you want and click OK. For example, to flip the text upside down, select the 180 Degrees option. When you do, the Text Box Editor window opens. Now, enter the text you want to rotate. When you're finished, click the Close Editor button on the Property Bar or choose File | Close from the menu bar to return to the WordPerfect document. Now, the text in the text box is upside down on the page. To modify the rotated text, just click on the text box to open the Text Box Editor window, make your changes, and then close the Text Box Editor window.

Tip: Import Quattro Pro data into a Presentations data chart (9/10/11/12)

• If you have data in Quattro Pro you'd like to use on a slide, you don't have to retype all of the labels and values. You can easily import the data into a data chart on a slide. First, create a new chart slide by clicking on the arrow to the right of the Insert A New Slide button and selecting Insert Data Chart Slide. Now, double-click on the data chart placeholder on the slide. When you do, the Data Chart Gallery dialog box opens. From the Chart Type list box, select the type of chart you want to create. Deselect the Use Sample Data and 3-D check boxes if necessary. Click OK to open a blank datasheet for the chart. Next, with the Datasheet displayed, choose Data | Import from the menu bar. Verify that Spreadsheet is selected in the Data Type dropdown box. Next to the Filename text box, click the Browse button, locate and select the notebook file containing the data, and click Open. Select the named range or sheet name you want to import in the Named Ranges list box. You can also modify the range boundaries in the Range text box. Click OK to import the data. If the data needs to be transposed (the columns should be rows) then import the data again but before you click OK, select the Transpose Data and the Clear Current Data check boxes. When you import the data but receive the Unsupported String Format error, check the spreadsheet column or row labels for any symbols before the text, such as a caret (^). Remove these symbols, save the notebook, and import the data again.

Tip: Don't let text cells mess up your average calculations (Quattro Pro 9/10/11/12)

• Quattro Pro's @AVG function is smart enough to ignore blank cells in a range when calculating an average. However, any text cells in the averaged range are considered zeros. When the @AVG function uses that zero value in the calculation, the result is inaccurate. To ignore text cells when averaging values, use the @PUREAVG function instead. It works like the @AVG function but skips any labels (text in cells) when performing the calculation.

Tip: Use the entire screen to edit any Quattro Pro chart (9/10/11/12)

• To edit a chart placed on the current sheet, you need to click on it to place it in Edit mode. Depending on the size of the chart, it's sometimes hard to select just the chart element you want to modify. It would be easier if the chart filled the entire window. What you might not realize is that every chart you create in a notebook has an icon on the Objects sheet. You can use that icon to open it in a chart window. The Objects sheet is also handy as a central location to access any chart in the notebook. To display the Objects sheet, click the Quickly Move To/From Objects Sheet navigation button to the left of the sheet tabs. Double-clicking on a chart's icon to open the window and display the chart across the entire screen. To close the chart window, click on its Close button. To return to the sheet you were working on before moving to the Objects sheet, click on the Quickly Move To/From Objects Sheet navigation button again.

Tip: Collect favorite WordPerfect Office Suite project templates into one convenient category (9/10/11/12)

• The PerfectExpert dialog box in the WordPerfect Office Suite provides many categories of project templates that group similar templates. If you frequently use certain templates from different categories, it's rather time-consuming to switch back and forth between categories just to find the template you need. To make it more convenient to find the template you need, copy project templates into a custom template category. First, create a new category for the projects. In any WordPerfect application, choose File | New From Project from the menu bar. In the PerfectExpert dialog box, click the Options button and choose Create Category from the dropdown list. In the resulting dialog box, enter the name of the category in the Display Name text box and click OK. To add project templates to your new category, from the Category dropdown list at the top of the PerfectExpert dialog box, select the category that contains the template you want to copy to your new category. Select the project template name in the list box. Click the Options button, point to Copy Project, and then select the new category name from the submenu. Continue to do this for any other templates you wish to add to your category. Then, from the Category dropdown list, select your custom category name and the templates you copied are listed together in one category.

Tip: Keep row and column headings visible while scrolling in a Quattro Pro spreadsheet (9/10/11/12)

• When scrolling in a large Quattro Pro notebook, it can be difficult to remember what kind of data is in each row or column once the headings have scrolled off the screen. To make it easier, you can lock the column and row headings on the screen and then scroll. This option is only available in Draft view. If necessary, switch to Draft view by choosing View | Draft View from the menu bar. Then, select the top-left cell in the area that you want to remain moveable. Every column to the left and any rows above the selected cell will be frozen or locked on the screen. Now, choose View | Locked Titles. Blue lines indicate the edges of the locked area and the scrollable area. The cells in the locked title area can still be edited. If the Locked Titles feature is on when the notebook is saved, the title settings are saved with the notebook. To unlock the titles, choose View | Locked Titles.

Tip: Perform common calculations without formulas in Quattro Pro (9/10/11/12)

• As you enter values in a Quattro Pro notebook, you might want a fast way to find the sum, average, or even count the number of cells in the selection. You don't need to create formulas to find these values. The Calc-As-You-Go feature can do that for you. For example, select a group of cells that contain values. Then, look at the right side of the Application Bar at the bottom of the notebook. The Calc-As-You-Go area displays the result of five calculations (sum, average, count, maximum, and minimum) based on the selected values.

Tip: Navigate quickly to certain types of items in a WordPerfect document (9/10/11/12)

• You probably already use the Find And Replace feature to navigate to instances of certain words in a document. But what if you want to jump from one table to the next? You don't have to scroll until you see a table. Instead, use the Browse button to navigate to similar objects, such as pages, headings, tables, footnotes, comments, graphics, or even strikeout text. The Browse button is found at the bottom of the vertical scroll bar between the Previous and Next buttons. To use this tool in version 10, 11, and 12, click the Browse button to display a pop-up menu of items and select the item you want to use to navigate. In version 9, point to the Browse button to display the QuickTip that indicates the item used to browse. Then, click the Browse button until the QuickTip displays the item you want. Now, in all versions, use the Previous and Next buttons on the vertical scroll bar to move to the next instance of that object.

Tip: Save formatting time by copying cell attributes along with data in Quattro Pro (8/9/10)

• In a run of the mill copy procedure, only the cell contents are copied.  Resetting the column and row settings for the copied data can be tedious.  Fortunately, Quattro Pro's Model Copy feature can save you a lot of time and trouble.  During the copy process, you can select which attributes you wish to include with the data.
• To use this feature, first select the block that you want to copy.  Then, choose Edit | Copy Cells from the menu bar.  In the copy Cells dialog box, the From text box contains the address of the selection.  Use the Pointer button to the right of the To text box and select the destination.  You can select just the upper-left corner of the destination range or the entire block .  Select the Model Copy check box in the Copy Cells dialog box and the options you need to copy below it.  Click OK and Quattro Pro pastes the cell attributes along with the data.

Tip: Use a keyboard shortcut in WordPerfect to insert a drop cap (8/9/10)

• Using a drop cap is an effective way to let your readers know where to begin reading when there are many articles or chapters in a document.  A drop cap visually sets apart the first paragraph of each section in a document.  To quickly create a drop cap, place your insertion point anywhere in the desired paragraph and press [Ctrl] [Shift] C.  This creates a three-line drop cap for the first letter of the paragraph.

Tip: Add text to drawn graphics in WordPerfect (8/9/10)

• You can easily add a graphic, such as a line, star, or an arrow to your document.  But the graphic alone isn't too exciting, so you might want to have text surrounded by the graphic.  Using the Draw Combined Shapes button on the WordPerfect toolbar, you can add a graphic with an attached text box at the same time.  When you move the graphic, the text box travels with it.  To create this combined graphic, just click on the arrow to the right of the Draw Combined Shapes tool, select the graphic from the dropdown menu, and drag to create the shape in the document.  To add the text to the center of the graphic, right-click on it and choose Add Text from the QuickMenu.  Enter your text and then press [Enter].  You can select the text and format it as you would any other WordPerfect text.  When you resize the graphic, the text size doesn't change.  If you make the graphic too small, you won't see all of the text.  If this happens, make the graphic larger to see all of the text.

Tip: Add a slide transition to several Presentations slides at the same time (8/9/10/11)

• You can add a slide transition to an individual slide by choosing Format | Slide Properties | Transition form the menu bar and selecting the options in the Slide Properties dialog box.  But, if you use the same type of transition for several slides in a presentation, there's  an easier way to apply the transition.  First, switch to the Slide Sorter view by clicking on the Slide Sorter tab on the right side of the window or by choosing View | Slide Sorter from the menu bar.  Select the slides that you want to apply the transition to.  If the slides are consecutive, click on the first slide, hold down the [Shift] key, and click on the last slide to be included.  When you do, all of the slides between the first and last slide are selected.  To select non-consecutive slides, hold down the [Ctrl] key and click on the slides to be included.  Then, select a transition.  You can either choose one from the Slide Transition dropdown list on the Property Bar or open the Slide Properties dialog box and set the transition, speed, and direction options and click OK.  Now, the selected slides have the same transition applied.

Tip: Quickly move or insert a sheet in a Quattro Pro notebook (8/9/10/11)

• As you work with a notebook you might find that you want to rearrange the order of the sheets.  You can do this easily by dragging the sheet tabs.  To move a sheet, drag the sheet tab to the sheet that you want to follow the sheet you're moving.  When you release the mouse button, the sheet moves to that location.  If the sheets still have letter names, the sheet letter updates to the new location.  For instance, if you move sheet H to before sheet D, the moved sheet now becomes sheet C.  To add a new blank sheet before the active sheet, right-click on the sheet and choose Insert Cells from the QuickMenu.  Select the Sheets option button and click OK.  You can also choose Insert | Sheet from the menu bar and then click OK.  The new sheet is added before the active sheet.

Tip: Quickly create multiple pie charts in Quattro Pro (8/9/10/11)

• For comparison sake, you might want to create several pie charts based on similar data.  For instance, if you have a list of plants and their output by month, you might want a pie chart for each month.  Instead of manually creating each chart, you can let Quattro Pro create several pie charts in one chart object.  For example, let's say you have the heading Location in cell B2 and the names of five plants in cells B3 through B7.  In row 2, you have column headings of four months, such as January, February, March, and April starting in cell C2.  The data for each plant's monthly output is entered in the cells C3 through F7.  To create a pie chart for each month, select the heading text and the data (B2 through F7).  Then, click the QuickChart button and drag to create the chart on the spreadsheet.  Click on the Change The Chart Type button and select a pie chart type with four pie charts.  When you do, the four charts are created in the one chart object.  To modify the charts, such as change the fill color or explode a slice, select that slice in the pie chart in the upper left corner and edit the pie chart as you would a single pie chart.  Any changes you make to this pie slice are reflected in the other pie charts.

Tip: Search for specific Reveal Codes in WordPerfect (8/9/10/11)

• The Find And Replace feature is usually used to find specific instances of text.  but you can also use it to find certain Reveal Codes, such as where the font size has changed or where a margin has been adjusted.  First, place the insertion point at the top of the document by pressing [Ctrl] [Home].  then, from the menu bar choose Edit | Find And Replace.  From the find And replace menu bar, choose Match | Codes.  In the Find Codes list box, select the code you're looking for.  For instance, to find where the font size has changed, select Font Size.  Click Insert And Close to enter that code in the Find text box.  Then, click Find next to locate that code.  The insertion point is placed just after the first instance of that code.

Tip: Include more than the first letter in a drop cap in WordPerfect (8/9/10/11)

• Adding a drop cap to the first letter of a paragraph is easy.  Simply place the insertion point in the paragraph where you want the initial cap and then choose Format | Paragraph | Drop Cap or press [Ctrl] [Shift]C.  The first letter enlarges to line up with the first three lines of text.  But you can also include more than the first letter in the drop cap.  To do this, first apply a drop cap to the paragraph and then place the insertion point to the left of the drop cap to display the Drop Cap Property Bar.  On the Property bar, click the Drop Cap Options button.  In the resulting dialog box, you can include only the first word in the drop cap or select the number of characters to include.  To apply a drop cap to the first word, select the Make First Whole Word A Drop Cap check box.  If you want to choose the number of characters that are dropped, change the value in the Number of Characters In Drop Cap text box.  (Don't include spaces when counting the number of characters.)  The Make First Whole Word A Drop Cap check box must be deselected before you can enter a number of characters.  Click OK when you've finished.

Tip: Continuously play a Presentations slide show automatically (8/9/10)

• Have you ever seen a slide show on a kiosk, such as a job fair or trade show, that loops over and over?  You can create the same effect with your slide show.  This means the slide show runs continuously without any involvement from you.  This is a handy feature for slide shows, for example, that are displayed before the main presentation begins to engage the audience.  Once you just start the show, it will continue to move from slide to slide automatically until you stop it.  First, you need to set the timing for the slides and then run the slide show continuously.
• To set the slide timing, choose Format | Slide Properties | Display Sequence from the menu bar.  In the Display Next Slide panel, select the After A Delay Of option button.  In the Seconds box, enter a value for the number of seconds that you want the slides to be displayed.  The number of seconds you apply to a slide also apply to any animated items, such as bullets or graphics, that have a display sequence associated with them,  Then, select the Apply To All Slides In Slide Show check box and click OK.  To set a different timing for one particular slide, select the slide and choose Format | Slide Properties | Display Sequence from the menu bar.  Enter a different value in the Seconds text box and make sure the Apply To All Slides In Slide Show check box isn't selected.  Then, click OK.
• To run the show continuously, choose View | Play Slide Show from the menu bar.  Select the first slide you want displayed in the Beginning Slide list box.  Then, select the Repeat Slide Show Until you Press ESC check box and click Play.  To stop the slide show, press [Esc].

Tip: Quickly convert units with a Quattro Pro function (8/9/10)

• Do you receive data in one unit and need to change it to another?  For instance, you're given the number of pounds and need to find the equivalent number of grams.  Let the @Convert function do those standard unit conversions for you.  The function can convert units for mass, pressure, distance, time, force, energy, power, magnetic, temperature, and liquid measurements.  The structure of the function is @Convert(value to be converted, original unit, unit to convert to).  For example, to convert 5 kilometers into miles you'd use the function @Convert(5,"km","mi").  (The answer is a little over three miles).  The value you want to convert can either be a static value or a cell address.  You can also add a metric prefix to any of the units used in the function, such as k for kilo or p for pico.  See the Quattro Pro help topic on this function for more information.

Tip: Remove only the formatting from Quattro Pro cells (8/9/10)

• Have you ever formatted a spreadsheet and then think better of your choices?  If you've already entered data, you'll want to keep the data but remove just the formatting.  The quickest way to do this is to select the block and choose Edit | Clear | Formats from the menu bar.  The cell formatting, such as fill color and numeric formatting, is removed but your data is still in the notebook.

Tip: Automatically keep certain words on the same line in WordPerfect (8/9/10)

• The automatic word wrap feature is great in most cases.  It usually doesn't matter where the line breaks.  But sometimes you'll want to make sure that two words or a set of characters are always printed on the same line, such as a company name or a phone number.  To ensure that the words on either side of a space travel together no matter what, insert a Hard Space code instead of a regular space character.  To do so, place the insertion point between the two words and remove the existing space.  Then, choose Format | Line | Other Codes from the menu bar.  Select the Hard Space option button and click Insert.  On the screen, you'll see a space between the two words.  As you edit the document and the line wrapping changes, those two words will always appear on the same line.

Tip: Download templates and more from Corel's WordPerfect Office Community Web site (Corel 8/9/10)

• Although the WordPerfect Office Community Web site isn't updated anymore, the contents are still available.  This Web site provides articles on WordPerfect Office applications, tutorials, as well as downloadable templates and graphics.  On the Links & Resources page, there are hyperlinks for helpful Web sites for service packs, the Corel Knowledge Base, and Corel newsgroups.  To visit this site, point your browser to www.officecommunity.com/AppLogic+FTContentServer.html.  Remember to bookmark the site because there's no link to it from the main Corel site.

Tip: Quickly simplify the display of large values on the y-axis of a Quattro Pro chart (8/9)

• When charting values over 1000 on the y-axis in versions 8 and 9, the labels can get unruly.  You can have Quattro Pro automatically reduce the value to a smaller value and add the appropriate unit title to the axis.  For instance instead of having values such as 50000, 60000, and 70000 next to the y-axis, Quattro Pro replaces the values with 50, 60, 70 and adds the title Thousands to the axis.  To have Quattro Pro automatically make this adjustment, double-click on the chart to put it into Edit mode.  Then, select the Y-axis by clicking on it.  Choose Chart | Axes | Primary Y-Axis from the menu bar.  (You can also right-click on the Y-axis and choose Y-Axis properties from the QuickMenu.)  In the Y-Axis dialog box, click on the Scale tab.  Select the Show Units check box and then click OK to return to the chart.  Now the Y-axis values are smaller values and the appropriate unit title appears next to the axis.

Tip: Center text across several Quattro Pro Columns (8/9/10)

• You know how to center text within a cell.  But sometimes you might need to center text across several columns, such as for a heading.  The text might not appear centered if you just enter it in one of the cells above the data.  And, if the column widths change, you'll have to move the text again.  Instead, have Quattro Pro center the text across columns for you automatically.  To do so, enter the text in the left most cell of the block.  For example, if you want to center the text across columns B through F, enter the text in the appropriate row in column B.  Next, select the cell containing the text as well as the adjacent cells in that same row for each column you want to center across.  For example, if the text is in cell B7, select cells B7 through F7.  Then, click on the arrow to the right of the Alignment button on the Property Bar and choose Center Across Block from the Contents Left to Right Across Selected Cells.).  (You can also choose Format | Selection (Format | Selection Properties in version 10) from the menu bar, click on the Alignment tab, select the Center Across Block option button and click OK.)  Now the text appears centered across the columns you selected.  To change the text, select the left-most cell of the centered block and then edit the text.  To remove this alignment choice, select the block, open the Alignment Menu dropdown menu and choose General.

Tip: Add a new field to all organization chart boxes in Presentations (8/9/10)

• By default, the boxes in an organization chart on a Presentations slide contain two fields: Name and title.  If you'd like to add another field to one or several boxes, you can do so easily.  First, select the box(es) that you want to add the field to.  Then, choose Format | Box Fields from the menu bar.  In the Add New Field text box, enter the name of the new field and then click Add.  If necessary, rearrange the order of fields in the Current Fields list box by selecting a field name and using the Move Up or Move Down buttons accordingly.  When you have all the fields you want in the right order, click OK.  The new field now appears in all of the selected boxes.

Tip: Convert an existing WordPerfect table into a merge data source (8/9/10)

• Do you have data in a table that would make a great merge data source?  Don't retype all that data and add the data source field codes.  Let WordPerfect quickly convert it for you.  To do so, click anywhere in the table and choose Edit | Select | Select Table (Edit | Select | Table in version 8).  Then, press [Delete] to open the Delete Table dialog box.  If you're using version 8 or 9, and the table has column headings in the first row, select the Convert Contents To Merge Data File (Use Text In First Row As Field Names) option button.  If the first row contains data, select the Convert Contents To Merge Data File option button.  Now, click OK.  If you're using version 10, select the Convert Table Contents option button in the Delete Table dialog box and click OK.  Then, select the Convert Text To Merge Data File (.dat) option button.  If the first row of your table contains column headings, select the Use Text In First Row As Field Names check box and click OK.  When you do, the data from the table is now in the merge data source format with the ENDFIELD and ENDRECORD codes already in place.  Save this file with a new name and the extension .dat and you can start to use this data with your mail merges.

Tip: Print specific pages in WordPerfect (8/9/10)

• Printing a range of consecutive pages is easy.  Just choose File | Print from the menu bar, select the Print Pages option button, enter the starting and ending page numbers, and click Print.  But suppose you want to print pages 3, 7, and 9.  In this case, use the Multiple Pages option in the Print dialog box.  In versions 8 and 9, click on the Multiple Pages tab in the Print dialog box.  In version 10, click on the Advanced tab.  The page(s)/Label(s) dropdown list is where you enter the pages you wish to print.  If you open this dropdown list, you might be curious as to the available default choices.  These are just reminders of how to enter sequences of page numbers.  You can enter the page numbers you need in the dropdown list and then replace the default page numbers with your own.  There are two other page ranges you can specify that don't appear in the dropdown list.  To print all the pages from the beginning up to and including page 4, enter - 4.  You can also combine individual pages with a page range as in 2,4,7-9.  Just remember to always enter the page numbers of the page range in numeric order, no matter which type of sequence you're using.

Tip: Create a progression of charts by hiding series markers in Presentations (8/9/10)

• When you have a busy chart on a slide, your audience will have a difficult time taking it all in.  To make it easier to understand, you can create several slides that add one series at a time as you talk about the chart.  Instead of entering the data in the Datasheet several times for each slide, create one chart with all the series and then copy the slide several times.  On each slide, hide any series you aren't addressing at that point.  To do this, first create the data chart slide and enter the data for all the series in the Datasheet.  Then, switch to Slide Sorter view by clicking on the Slide Sorter tab at the right side of the window or by choosing View | Slide Sorter.  Select the data chart slide [Ctrl]V as many times as you need to show each series.  Next, double-click on the first data chart slide and double-click on the chart.  Display the Datasheet by choosing View | Datasheet from the menu bar.  Click on the row number of the first series that you want to hide.  From the menu bar, choose Data | Exclude Row.  When you do, the row is hidden.  Using these steps, hide any other series for that slide.  On the next slide, hide the appropriate series.  Do the same for all of the data chart slides until you get to the final chart with all of the series displayed.  When you run the show, each slide displays the chart as a progression of series.

TO VISIT BUSINESS WEBSITE LINKS' INTERNET DIRECTORY
CLICK HERE---->INTERNET DIRECTORY ONLINE.COM