maryannrichardson, Author at TechRepublic

maryannrichardson

Image: iStockphoto\/Rawpixel

Software
How to transfer data from Word forms to an Excel worksheet

Avoid the hassle of manually importing Word form data into Excel. With the help of an Excel wizard, you can quickly step through the process.

maryannrichardson
Published: July 27, 2018, 11:01 AM PDT Modified: November 1, 2022, 11:59 AM PDT Read More See more Software articles
Software
Copy hundreds of rows of Excel formulas in three steps

Copying formulas in Excel is a relatively simple operation - unless you need to copy down through dozens or even hundreds of cells. Here's a foolproof little trick that will knock out the task for you.

maryannrichardson
Published: July 28, 2009, 6:58 AM PDT Modified: July 28, 2009, 6:58 AM PDT Read More See more Software articles
$Prevent Excel from turning fractions into dates$

Software
Prevent Excel from turning fractions into dates

Left to its own devices, Excel will convert your fractions into dates as soon as you enter them in your spreadsheet. See how you can work around this problem.

maryannrichardson
Published: May 25, 2009, 5:00 PM PDT Modified: May 25, 2009, 5:00 PM PDT Read More See more Software articles
Software
Automatically fill in Access text boxes based on a combo box selection

You can greatly enhance a form by having Access supply information based on the user's selection. Here's an example that will fill in an employee's first name and phone number when the user chooses that person's last name from a list.

maryannrichardson
Published: May 19, 2009, 4:21 AM PDT Modified: May 19, 2009, 4:21 AM PDT Read More See more Software articles
Software
Clear an Access combo box for entering the next record

You can have Access clear the selection from a combo box in a data entry form so that the user starts fresh with each new record. See how to make this user-friendly tweak.

maryannrichardson
Published: May 12, 2009, 5:04 AM PDT Modified: May 12, 2009, 5:04 AM PDT Read More See more Software articles
Software
Quickly add page numbers to your Word documents

Sometimes, it's more efficient to take a task into your own hands. See how you can save a little time entering a PAGE field instead of making a trip to the Page Numbers dialog box.

maryannrichardson
Published: April 18, 2009, 3:07 AM PDT Modified: April 18, 2009, 3:07 AM PDT Read More See more Software articles
Software
Create an Excel function to highlight formula cells in a worksheet

With the help of a simple function, Excel's Conditional Formatting feature can save you time and effort. Here's an easy way to flag formulas in your worksheets.

maryannrichardson
Published: April 7, 2009, 8:21 AM PDT Modified: April 7, 2009, 8:21 AM PDT Read More See more Software articles
Software
Open multiple Word 2003 documents in one window

Consolidate and streamline your Word document display to avoid the clutter of individual application windows.

maryannrichardson
Published: March 3, 2009, 12:20 AM PST Modified: March 3, 2009, 12:20 AM PST Read More See more Software articles
Software
Use Word to type on a printed form without a typewriter

There's no need to manually scrawl your way through a paper form. Convert the form to an online image you can fill out using Word.

maryannrichardson
Published: February 24, 2009, 12:25 AM PST Modified: February 24, 2009, 12:25 AM PST Read More See more Software articles
Software
Add information from related tables to your Access totals queries

Totals queries can be a little limited in the information they include. Here's a trick that will make them a little more useful.

maryannrichardson
Published: February 24, 2009, 12:01 AM PST Modified: February 24, 2009, 12:01 AM PST Read More See more Software articles