- Subscribe to this page:
- RSS
- Email Alert
mary ann richardson
(205 results)-
Blog Post
Copy hundreds of rows of Excel formulas in three steps
July 28, 2009 1:58pm PDT
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...
25 Latest comment by jbenton@...
-
Blog Post
Add sounds to your Access form events
June 2, 2009 12:00am PDT
Your forms don't have to be silent and boring -- Access lets you play a sound for any form event. Here's a quick look at how you can set up Access to play a sound each time a user opens or closes...
3 Latest comment by Tink!
-
Blog Post
Prevent Excel from turning fractions into dates
May 26, 2009 12:00am PDT
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.
22 Latest comment by touchdown_twc
-
Blog Post
Automatically fill in Access text boxes based on a combo box selection
May 19, 2009 11:21am PDT
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...
3 Latest comment by Marshwiggle
-
Blog Post
Move text to the next column permanently
May 19, 2009 9:00am PDT
Word may not be a full-featured layout program, but it does offer some tools that let you control the position of text on the page. See how to use a column setting to get that text where you want...
2 Latest comment by ginmemphis
-
-
Blog Post
Clear an Access combo box for entering the next record
May 12, 2009 12:04pm PDT
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.
7 Latest comment by bronx72
-
Blog Post
Add data to an Excel worksheet from a Word table
May 12, 2009 11:45am PDT
If you have a workbook containing data that originates in Word, you can keep the data current with the help of Excel's Import External Data wizard. Here's a look at how to put this handy feature...
17 Latest comment by helpmeforms
-
Blog Post
Spot invalid imported data with the help of a custom Excel function
May 5, 2009 2:46pm PDT
Any time you have to manually review worksheet data looking for errors, something is going to slip through. Here's one handy safety net: a user-defined function that will flag one type of invalid...
1
-
Blog Post
Create a watermark using a Clip Art Gallery image
April 28, 2009 12:00am PDT
You can create a custom watermark by copying your favorite clip art into a document header. Here's a look at this creative technique.
22 Latest comment by Beehindblueyes
-
Blog Post
Compute your entire Excel worksheet with a click of the mouse
April 18, 2009 12:00am PDT
You already know how to use Excel's AutoSum feature -- now use it to enter all the formulas with just one click and sum it up. Here's how.
7 Latest comment by mjbnet@...
-
Blog Post
Generate random AutoNumbers in Access tables
April 14, 2009 12:00am PDT
Sequential numbers are fine for some purposes, but sometimes random numbers are better. Mary Ann Richardson explains how you can populate the AutoNumber field with random numbers when necessary.
-
Blog Post
Use SUM in an array function to count values that match multiple criteria
April 14, 2009 12:00am PDT
When you need to count values based on more than one criterion, the CountIF function won't do the job. The solution is to build an array formula with SUM.
6 Latest comment by bobumlas@...
-
Blog Post
PowerPoint won't save your presentation to CD: Now what?
April 7, 2009 3:40pm PDT
You might not be able to copy a presentation directly onto a CD if your CD burning program is incompatible with PowerPoint's Publish Package For CD feature. Luckily, you can use a trick to dodge...
7 Latest comment by bradleypagliaro@...
-
Blog Post
Create an Excel function to highlight formula cells in a worksheet
April 7, 2009 3:21pm PDT
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.
7 Latest comment by danny@...
-
Blog Post
Change the default text field size in Access 2007
March 31, 2009 12:00am PDT
If the default size of Access 2007 text fields doesn't fit your needs, you could waste a lot of time manually adjusting each one you create. Take a moment now to set your own default and save...
-
Blog Post
Mark duplicate entries automatically with Excel's COUNTIF function
March 31, 2009 12:00am PDT
Sometimes, it's handy to get a quick view of data that matches up between two columns. By combining an Excel function and the conditional formatting feature, you can easily accomplish this.
3 Latest comment by RRB
-
Blog Post
Highlight your message with PowerPoint's animated charts
March 17, 2009 12:00am PDT
Keep your audience focused on the information you're discussing by animating charts to display one data series at a time.
-
Blog Post
Display a specific form when your Access 2007 database is opened
March 17, 2009 12:00am PDT
If you want to prevent your users from navigating around your database, you can configure Access 2007 to take them straight to a designated form.
1
-
Blog Post
Perform multiple analyses easily with a Clear Criteria button
March 17, 2009 12:00am PDT
If you need to analyze data in an Excel worksheet using a series of criteria, you don't have to manually delete entries from the criteria row. See how you can create a button to clear those...
-
Blog Post
Move a pivot table to another workbook in Excel 2007
March 10, 2009 9:22am PDT
Excel's Move PivotTable command takes the work out of transferring a pivot table from one workbook to another. Here's a simple example that shows how to take advantage of this command.
