choose

The Paste Special command can be used to create a link between cells. The source cell values must be copied to the Windows Clipboard. The link is created when the values are pasted to the target destination cells using the Paste Special Command. To ... create a link by USING the Paste Special command, follow the steps below: Open the desired workbooks, if necessary. Select the source cell(s) to be copied. Click on the Copy button on the Standard toolbar. Or right-click on the cells and then choose copy from the shortcut menu. Choose Edit | Copy. Press CTRL + C as an alternative. Select the ... (view more)

I've got some *very* exciting news to share today! The folks over at Ashampoo sent me a friendly email today to announce that the beta version of Ashampoo Burning Studio 7 -- their flagship, simple-to-use, feature rich CD / DVD recording program -- ... has now been released! Well, that may not sound too exciting, but read on -- because you won't want to miss this one! Ashampoo: Deal of the Century In order to celebrate the release of their flagship product, the company is offering an extremely generous discount of over 25% off Ashampoo Burning Studio 7 -- but only if you order Burning Studio 7 by ... (view more)

To ensure that the formatting of your slides remains static when a presentation is opened by someone else, you should stay with the default fonts that ship with Windows. It is not guaranteed, but usually it is safe to use Arial or Times New Roman ... fonts. Having said that, your presentation stands out from the mundane when you use different fonts. Using one or two different fonts within your presentation makes it more interesting. The only drawback to that is that if your audience doesn't have the fonts that you used installed their system, then PowerPoint will select a font substitution and it ... (view more)

I've got some *very* exciting news to share today! The folks over at Ashampoo sent me a friendly email today to announce that the beta version of Ashampoo Burning Studio 7 -- their flagship, simple-to-use, feature rich CD / DVD recording program -- ... is near completion. The final version will be available May 7th, 2007. Well, that may not sound too exciting, but read on -- because you won't want to miss this one! Ashampoo: Deal of the Century In order to celebrate the release of their flagship product, the company is offering a massive and extremely generous discount of over 50% off Ashampoo ... (view more)

There can sometimes be situations when it is necessary to add more than one summary function to a list. For example, you may want to present both subtotals and averages for the groups within a data list. To display summary functions follow these ... steps: Sort the data list on the field or fields by which the data should be grouped. Position the active cell within the data list. Choose Data | Subtotals. The Subtotal dialog box will appear. Specify options for the first subtotal. Choose OK. Choose Data | Subtotals. The Subtotal dialog box will appear again. Specify options for the second subtotal ... (view more)

When automatic subtotals are inserted, Excel outlines the list by grouping detail rows with each associate subtotal row, and grouping subtotal rows with the grand total row. To insert subtotals and grand totals in a data list, follow the ... instructions below: Sort the data list on the field or fields by which the data should be grouped. Position the active cell within the data list. Select Data | Subtotals. The Subtotal dialog box appears. Select a field by which to group from the At each change in drop-down list. Select a calculation function from the Use function drop-down list. Select the ... (view more)

There may be times when you will find it necessary to sort a data list on something other than the alphabet. You can define a custom list of elements on which to base the criteria for a sort. Excel provides a built-in custom sort routine that lists ... months in their chronological order from January to December. Other lists can be created from an existing range of cells or simply entered on the Custom Lists tab of the Options dialog box. Follow the steps below to see how it works: Choose Tools | Options. The Options dialog box opens. Click on the Custom Lists tab. Choose New List in the Custom ... (view more)

There may be times when you will find it necessary to sort a data list on something other than the alphabet. You can define a custom list of elements on which to base the criteria for a sort. Excel provides a built-in custom sort routine that lists ... months in their chronological order from January to December. Other lists can be created from an existing range of cells or simply entered on the Custom Lists tab of the Options dialog box. Follow the steps below to see how it works: Choose Tools | Options. The Options dialog box opens. Click on the Custom Lists tab. Choose New List in the Custom ... (view more)

I bet you didn't know that you could have a button for any command or macro did you? Well the good news is that you can! Follow the steps below to create one! Choose View | Toolbars | Customize and select the Toolbars tab. Click to place a check ... next to the name of the toolbar to make certain the toolbar is currently on the screen. Click the Commands tab. Under Categories, choose the one containing the command you want, or Macro for a macro you created yourself. Choose the command or macro name and drag to the toolbar location. Choose Modify Selection, actions and continue as before. Your ... (view more)

You can customize Word by creating a button on a toolbar for a macro or command that you find yourself using more and more often. It is more efficient and much easier to use a toolbar button than to choose a macro from the dialog box or to choose a ... command from a menu, don't you agree? You can quickly create a button for a macro before you even begin recording. Follow the steps below to learn how: Choose Tools | Macro | Record New Macro or double-click REC on the status bar to begin recording a macro. Enter the name you want to call the macro. Click the Toolbars button to see the Customize ... (view more)