Topics
Content Types
About 624 results
-
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 ...
-
Use the Access Office Links tool to convert a report to an Excel worksheet
Here's a quick and easy trick for getting your Access report data into Excel - organized just the way you want.
-
Add sounds to your Access form events
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 ...
-
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.
-
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...
-
Move text to the next column permanently
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...
-
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.
-
Add data to an Excel worksheet from a Word table
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...
-
Spot invalid imported data with the help of a custom Excel function
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 ...
-
Include parameter values in your Access report titles
You can create more informative titles for reports that are based on parameter queries. This simple technique will enable you to include the parameters in your report titles and he...
-
Create a watermark using a Clip Art Gallery image
You can create a custom watermark by copying your favorite clip art into a document header. Here's a look at this creative technique.
-
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.
-
Compute your entire Excel worksheet with a click of the mouse
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.
-
Generate random AutoNumbers in Access tables
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 w...
-
Use SUM in an array function to count values that match multiple criteria
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.
-
PowerPoint won't save your presentation to CD: Now what?
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 ...
-
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.
-
Change the default text field size in Access 2007
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 defau...
-
Mark duplicate entries automatically with Excel's COUNTIF function
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 accompl...
-
Highlight your message with PowerPoint's animated charts
Keep your audience focused on the information you're discussing by animating charts to display one data series at a time.
-
Display a specific form when your Access 2007 database is opened
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.
-
Perform multiple analyses easily with a Clear Criteria button
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 cl...
-
Move a pivot table to another workbook in Excel 2007
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 comm...
-
Add a button to an Access form that tells you which version is running
Users don't always know what version of Access they're using -- which can slow things down when you're helping troubleshoot a problem. Make it easy for them (and for you) by creati...
-
OneNote 2007: If you can print it, you can mark it
You can easily annotate or draw on printable content with the help of OneNote -- which is a great help when you're collaborating on a project. Mary Ann Richardson explains how to t...
-
Organize your Inbox by converting Outlook 2007 e-mail into tasks
When you receive e-mails you need to act on -- but not right away -- consider turning them into tasks, complete with follow-up reminders.
-
Instead of queries, use the Access 2007 PivotTable view
Access 2007 lets you create pivot tables without building a query. See how this feature can simplify your data analysis.
-
Open multiple Word 2003 documents in one window
Consolidate and streamline your Word document display to avoid the clutter of individual application windows.
-
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.
-
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.