Using Paste Special in Excel 2007
Microsoft Office Excel 2007 normally copies all the information in the range of cells you select when you paste the data. Use Excel's Paste Special command to specify other options, such as pasting only [more…]
How to Draw Straight Lines on PowerPoint 2007 Slides
PowerPoint provides a Line button so you can draw straight lines on your slides. With your PowerPoint slide open, choose a location for your line, then follow these steps: [more…]
Working with Effect Presets in Adobe Premiere Elements
To make using and modifying video effects easier, Premiere Elements comes with a collection of effect presets. Each preset is a collection of settings that perform common tasks like panning across a still [more…]
How to Edit a Header or Footer in Word 2007
In Word 2007, you can edit a header or a footer by using the same technique — just follow a few simple steps. (Substitute footer for header if editing a footer.) [more…]
How to Automate Tasks with Macros in Excel 2007
You can use macros in Excel 2007 to save time by automating tasks that you perform frequently. A macro is a series of commands grouped together that you can run whenever you need to perform the task. [more…]
Querying an Access Database Table in Excel 2007
Excel 2007 can import data from an Access 2007 database table into a worksheet, a process known as making an external data query. After importing the data into Excel, you can then use the Filter buttons [more…]
How to Make Odd and Even Headers or Footers in Word 2007
In Word 2007 documents, you can make odd and even headers or footers by following the same simple steps (just substitute footer for header if editing a footer). [more…]
Java Programming: Telling the Computer to Do Something
In Listing 1, below, you get a blast of Java code. Like all novice programmers, you're expected to gawk humbly at the code. But don't be intimidated. When you get the hang of it, programming is pretty [more…]
Crystal Reports 10: Adding a Hyperlink to a Report
One of the most valuable features of Web-based content is the capability to quickly move between pages by using hyperlinks. By clicking a hyperlink associated with a word, a phrase, or an image, you can [more…]
Install a Wired Network
Installing a wired network comprises assembling the proper components. To install a wired network, assemble the cables, network adapter, and router, among other components. Follow these steps to install [more…]
Contrasting Single and Double Quotes in Perl
To summarize the main difference between single and double quotation marks: Single quotation marks do not interpret, and double quotation marks do. That is, if you put something in single quotation marks [more…]
How to Run an Excel 2007 Macro
After you record a macro in Excel 2007, either by using the macro recorder or by creating it in Visual Basic for Applications (VBA), you run the macro to have it carry out the commands and keystrokes that [more…]
Using Word 2007's Thesaurus (and Other Proofing Tools)
One of the nifty Word 2007 features is a built-in thesaurus that can quickly show you synonyms for a word that you type. Using it is easy:
1. Right-click a word that you typed and choose Synonyms from the [more…]
How to Apply Slide Masters in PowerPoint 2007
If you have created multiple Slide Masters for a PowerPoint presentation, you can select which Master to use for each slide in your presentation. To apply a Master to one or more slides, follow these steps [more…]
How to Edit a Picture in Paint Using Windows Vista
Although the Windows Vista version of Paint is usually used to create simple drawings, you can also use it to edit picture files. In Paint, you can crop your pictures, edit their colors, draw objects on [more…]
How to Start a PowerPoint 2007 Slide Show
You’ve put hours into creating a great PowerPoint presentation. PowerPoint is designed to display slides present on a screen. PowerPoint can show your presentation on your computer’s own monitor, a projector [more…]
Working with the Paths Palette in Photoshop CS2
Working hand-in-hand with the Pen tool in Photoshop CS2 is the Paths palette. You can think of it as a kind of Command and Control Center for your paths. Although it isn't mandatory, opening up your Paths [more…]
Using DOS to Write-Protect and Reformat Disks
You can protect floppy disks in such a way as to prevent yourself or anyone else from modifying or deleting anything on the disk.
When a disk is write-protected, you cannot alter, modify, change, or delete [more…]
How to Import Online Data into Excel 2007 with a Web Query
In Excel 2007, you can use Web queries to import data directly from various Web pages that contain financial and other types of statistical data that you need to work with in a worksheet. To create a new [more…]
How to Use the Scanner and Camera Wizard in Windows XP
The Scanner and Camera Wizard in Windows XP allows you to scan in old photos or other documents to make them digital. Scanning is simple, and once you make files digital, you can e-mail them or share them [more…]
Filtering a Datasheet in Access 2003
Filtering an Access 2003 datasheet is a way to focus on specific records, rather than all the records in a table. You can filter out records that aren't relevant to what you're trying to do at the moment [more…]
Relegating Your Relics to Archiving in Outlook 2003
It doesn't take long to accumulate more e-mail messages than you can deal with. Some people just delete messages as they read them. Others hold on to old messages for reference purposes. [more…]
Defining VBA and Its Uses
VBA, which stands for Visual Basic for Applications, is a programming language developed by Microsoft — you know, the company run by the richest man in the world. Excel, along with the other members of [more…]
How to Add a Header or Footer in Word 2007
In Word 2007, you can add a header or a footer by using the same technique. To add a header or footer, simply follow these steps (substitute footer for [more…]
Placing Charts in Excel
In Excel, making charts is most of the work, but that's not all of it. You still have to decide where to put the charts. First, you need to figure out whether to put a chart on a separate chart sheet. [more…]
