select

Thu
02
Nov
Dennis Faas's picture

Grouping Worksheet: MS Excel

Grouping in MS Excel refers to selecting several sheets within a workbook and then working with them as a set. When workbook sheets are grouped together, the use can enter data or make changes to several sheets at once. For example, three worksheets ... could be created that will each have identical column labels. By grouping the sheets together, the labels would only have to be typed on one of the sheets to have them appear in the same locations on the other grouped sheets. Grouping sheets can save time when performing common tasks such as: Entering the same data on all grouped workbook sheets. ... (view more)

Thu
19
Oct
Dennis Faas's picture

Apply a Fill Effects Background: MS PowerPoint

To use one of the fill effects options, choose Format | Background, click the drop-down list, and then click Fill Effects. When the dialog box appears, you can choose between four possible background types. To apply a gradient background, follow the ... steps below: Click the Gradient tab. The Fill Effects dialog box now includes the options that are available for applying a gradient background. You can now select one of the options that are described after step 2. After you have chosen a fill option for your presentation, click OK to return to the Background dialog box. From there, you can: ... (view more)

Tue
17
Oct
Dennis Faas's picture

Change the Slide Color Scheme: MS PowerPoint

One way to alter the look of your visual aids in an MS PowerPoint 2000 presentation is to change the color scheme. The color scheme determines what colors are assigned to eight specific slide characteristics (such as fonts, backgrounds and bullets). ... Each template, even the blank presentation, comes with a set of color schemes -- the default that materializes as soon as you apply it plus several others. These predefined schemes have been specially selected to include colors that not only look good together, but that also supply a sense of balance. Still, you can choose to modify the existing ... (view more)

Wed
04
Oct
Dennis Faas's picture

Delete Rows and Columns: MS Word

You may think you can delete a row or column by selecting it and pressing Delete. But what that does is remove the text, leaving empty cells behind. To remove a row or column completely, you must select it and then choose a menu selection. Choose ... Table | Delete, and then specify Table, Columns, Rows, or certain cells. Right-click and choose Delete from the shortcut menu. If you have a row selected, the shortcut menu will say Delete Row; if you have a column selected, it will say Delete Column. When a column is deleted, the column widths may adjust themselves. The easiest way to delete an ... (view more)

Fri
22
Sep
Dennis Faas's picture

View All Data in Worksheet: MS Excel

An Excel worksheet is packed with hundreds, and sometimes thousands, of cells containing data. You can either view the complete data region (the area where you have input data) in the worksheet, or magnify / reduce the selected data region to the ... size of the window using the following method: Select the current region. Press Ctrl + *. Choose View | Zoom. Select Fit selection. Click OK. Increase the amount of data that appears in the window by hiding window elements such as the sheet tabs, toolbars, formula bar and status bar. Choose Tools | Options. Select the View tab. Clear the check boxes ... (view more)

Thu
31
Aug
Dennis Faas's picture

Add A Chart to a Comment: MS Excel

There may be times when you want to display a chart with your data using MS Excel, but you don't want it to take up the space on the worksheet. One solution is to place the chart in a document. First, create your chart and cut and paste it to a ... drawing program such as Paint. Save the chart as a picture file and then go back and insert a comment in the worksheet. To add the chart to the comment, follow these steps: Double-click the comment. Select the Colors and Lines tab. In the Fill section, select Fill Effects from the Color drop-down list. Select the Picture tab and then click the Select ... (view more)

Tue
22
Aug
Dennis Faas's picture

Printing Comments: MS Word

You can print the markup balloons as they appear in a document by selecting the 'Document Showing Markup' option from the 'Print What' list via the Print dialog box. You can also print the Reviewing Pane without the document text by selecting the ... 'List Of Markup' option from the Print What list. Markup balloons printed with the document appear in the margin designated on the 'Track Changes' page in the Options dialog box. Whether you print comments with the document or just the Reviewing Pane, the number of the pages on which the comment mark appears is included with the comment text, as well ... (view more)

Thu
17
Aug
Dennis Faas's picture

Clearing Formats and Styles: MS Word

You can use the Clear Formatting command to remove formatting and styles from text in MS Word. When you remove all formatting and styles from text, it adopts the attributes of the Normal style. You can remove formatting and styles from a single ... instance or from all instances of that formatting or style. Clear Formatting command appears at the top of the Pick formatting to apply list in the Styles and Formatting task pane whenever the Show option is set to Available formatting, Formatting in use or Available styles. Since the Normal style is a paragraph style, all font, paragraph, tab, border ... (view more)

Sun
13
Aug
Dennis Faas's picture

View All Data in a Worksheet: MS Excel

An Excel worksheet is packed with hundreds or thousands of cells containing data. You can either view the complete data region in the worksheet or magnify or reduce the selected data region to the size of the window. Follow the steps below: Select ... the current region an press CTRL + *. Choose View | Zoom. Select Fit selection. Click OK. You can increase the amount of data that appears in the window by hiding window elements such as the sheet tabs, toolbars, formula bar and status bar. Choose Tools | Options. Select the View tab. Clear the check boxes for Row ... (view more)

Sat
05
Aug
Dennis Faas's picture

Creating Distribution Lists: MS Outlook

Setting up a distribution list in your Personal Address Book or Outlook Address Book is relatively easy. You can create a distribution list using addresses from multiple address books, which means, that you could include addresses from your Contacts ... folder and Personal Address Book. You can also include addresses of different types such as Internet addresses and Exchange Server addresses. Usually it's easiest to set up a distribution list if all the addresses that will be included already exist, but you can enter addresses on the fly if necessary. Follow these steps to create a distribution ... (view more)

Pages

Subscribe to RSS - select