- Follow this blog:
- RSS
- Email Alert
Microsoft Office
Mark Kaelin
TechRepublic Staff
Mark Kaelin
-
Bring Access forms to life with animation
Publishing your Access forms on the Web? Add some fun with animated images! Here's how to create a form that will appear to come to life when you run it.
Posted by Mary Ann Richardson | December 4, 2007, 12:00 AM PST | Latest comment by ron_r_a
-
How to help a disabled Access control disappear into the background
It's common to display data that you don't want users to change. I've seen developers deal with primary key values this way, although some developers argue that users shouldn't even see primary...
Posted by Susan Harkins | December 3, 2007, 11:32 AM PST
-
How to keep a continued message from getting lost in linked boxes
If you're using Word to create an electronic or print newsletter, you might be working harder than necessary. Word's desktop publishing features are basic and getting content to flow from one area...
Posted by Susan Harkins | November 30, 2007, 12:00 AM PST
-
Identify and print a Word document's key assignments
Don't waste time picking keys that already have assignments -- find out what key assignments are available to you with your Word documents, and get a printed list.
Posted by Mary Ann Richardson | November 27, 2007, 12:00 AM PST
-
Use Excel to obtain a random sample of customers for market analysis
No matter whether you are testing a new marketing campaign or evaluating your current level of customer service, you want to be sure that you base your analysis on a reliable sample of your...
Posted by Mary Ann Richardson | November 27, 2007, 12:00 AM PST | Latest comment by ssharkins@...
-
Use a calculated field in a query to sum up Access check box data
If you are collecting data on a certain population, here's how to convert your the check box fields in your table to the information you need by using Access to add up all the answers and compare...
Posted by Mary Ann Richardson | November 27, 2007, 12:00 AM PST
-
How to draw a straight line
Most of the Office applications let you insert shapes. One shapes is a line; however, laying a straight line can be tricky. Test it for yourself. In any application, display the Drawing toolbar by...
Posted by Susan Harkins | November 26, 2007, 12:00 AM PST
-
How to remove Word formats quickly
I could write a white paper on Word's formatting options--it's such a huge topic. You can apply individual formats, copy them, and even create custom styles to apply multiple formats at the same...
Posted by Susan Harkins | November 23, 2007, 12:00 AM PST | Latest comment by kdavis@...
-
Quickly find matching records in Excel with a few keystrokes
When you need to quickly find matching records in your data, you could sort the list, then add a filter -- but you can accomplish the same thing in three steps using Excel's shortcut keys.
Posted by Mary Ann Richardson | November 20, 2007, 12:00 AM PST
-
Prevent Access users from accidentally activating a form control
If a control on an Access form may cause an irreversible error when activated, you may want to prevent users from accidentally accessing that control. Here's how to prevent users from tabbing to a...
Posted by Mary Ann Richardson | November 20, 2007, 12:00 AM PST
-
Remove unwanted blank pages inserted after a Word table
When you create a table that ends at the bottom margin, Word automatically inserts a new blank page. If you turn on the Show/Hide button, it reveals a paragraph mark after the table. Follow these...
Posted by Mary Ann Richardson | November 20, 2007, 12:00 AM PST | Latest comment by hafsasaud
-
Tip: Quickly select Excel sheets in a busy workbook
Excel workbooks have supported multiple sheets for a long time. I'm probably showing my age when I admit that I remember when an Excel file came with only one sheet! I see many workbooks...
Posted by Susan Harkins | November 19, 2007, 8:30 AM PST
-
Office 2007 stops responding with online requests
A new knowledge base article warns that Excel 2007, PowerPoint 2007, and Word 2007 may stop responding if you use online features.
Posted by Susan Harkins | November 15, 2007, 11:24 AM PST
-
How to display a graphic on every slide, or not, in a PowerPoint presentation
It's easy to display a graphic file, such as a company logo, on every slide in a presentation. Simply add the graphic file to the Slide Master, and PowerPoint will display that graphic on every...
Posted by Susan Harkins | November 15, 2007, 12:00 AM PST | Latest comment by ssharkins@...
-
Convert Word graphics to AutoShapes to type text directly on your images
While you can use a text box to add a word or two to your Word document pictures, it is easier to position text typed directly onto the picture itself. While Word does not let you type directly...
Posted by Mary Ann Richardson | November 13, 2007, 12:00 AM PST | Latest comment by papgas@...
-
Let Excel e-mail your weekly reports
If you have to send the same worksheet to a number of people every week, it probably takes you quite awhile to prepare the e-mail. If you have to do this for a number of reports, it can take even...
Posted by Mary Ann Richardson | November 13, 2007, 12:00 AM PST | Latest comment by JNirvaha
-
Use control properties to turn on form messages in Access
With Access' SetValue control property, you can display a message when the value of a field reaches a certain level. Follow these steps to turn on form messages.
Posted by Mary Ann Richardson | November 13, 2007, 12:00 AM PST
-
How to copy styles between Excel workbooks
Creating a format style in Excel can save a lot of time, especially if you have a number of custom formatting requirements. You might think you have to re-create these styles for each workbook,...
Posted by Susan Harkins | November 11, 2007, 11:35 AM PST
-
Tip: Convenient Microsoft page to start most download searches
I found a new page at Microsoft this morning. It might not be new, but it is new to me. On the linked page, click the Download & Trials link to the right. It appears to be a good place to...
Posted by Susan Harkins | November 11, 2007, 8:18 AM PST | Latest comment by ssharkins@...
-
Tip: Office 2000 updates
Thanks to Dan Waters for passing on the following link to Tony Toews blog. Apparently, Access 2000 security patches are not automatically included with Office updates. I won't repeat the...
Posted by Susan Harkins | November 10, 2007, 6:53 AM PST
-
Two ways to add checkbox controls to a Word document
Use a customized bulleted list or a content control to insert checkboxes into a Word document, depending on how you are going to use it.
Posted by Susan Harkins | February 22, 2012, 8:16 AM PST | Latest comment by ian@...
-
How to add a drop-down list to an Excel cell
Drop-down lists can greatly facilitate data entry. Here's a look at how to use Excel's data validation feature to create handy lists within your worksheets.
Posted by Susan Harkins | June 12, 2008, 12:00 AM PDT | Latest comment by dhivya.vasu01@...
-
Transpose Excel data from rows to columns, or vice versa
When you need to flip-flop data in an Excel worksheet, don't waste time doing it manually. Excel offers a handy Transpose option that will quickly take care of the task.
Posted by Jeff Davis | June 23, 2009, 12:00 AM PDT | Latest comment by excelinexcel
-
Use SUMIFS() to sum by multiple conditions in Excel
Excel's SUMIF() lets you sum values, conditionally. It's new sibling, SUMIFS() lets you sum values by multiple conditions.
Posted by Susan Harkins | November 14, 2011, 11:25 AM PST | Latest comment by peter.r7
-
How to use Excel 2010's new conditional formatting with references
Excel 2010's new referencing option makes conditional formatting more powerful than ever before!
Posted by Susan Harkins | August 30, 2010, 8:40 AM PDT | Latest comment by manishdhir
-
Add horizontal lines to a Word document
Susan Harkins shows you two easy ways to insert a horizontal line into a Word document.
Posted by Susan Harkins | September 29, 2010, 12:00 AM PDT | Latest comment by Shrike49
-
How to Alphabetize Lists In Word
I learned something new the other day—Word can alphabetize a list. I’m sure many users already know this, but it’s brand new to me. Years ago, I could do this with WordPerfect, but I’ve...
Posted by Susan Harkins | May 29, 2007, 12:13 PM PDT
-
Four ways to insert an em dash in a Word document
When you need an em dash, you can let Word enter it for you the easy way. If that approach doesn't suit your needs, try one of three manual methods.
Posted by Susan Harkins | March 1, 2010, 12:00 AM PST | Latest comment by Marshwiggle
-
Use Word's Vertical Alignment settings to center a page
Centering text vertically isn't difficult; you just have to know where to look!
Posted by Susan Harkins | July 28, 2010, 6:30 PM PDT
-
Use COUNTIFS() to evaluate multiple count and criteria ranges
Excel's COUNTIFS() function is flexible enough to handle different ranges and data types.
Posted by Susan Harkins | May 21, 2012, 10:37 AM PDT | Latest comment by jbenton@...
-
The secret to unhiding column A in an Excel worksheet
After you hide column A, it might seem like it's gone forever. Fortunately, there are two simple tricks for unhiding it.
Posted by Susan Harkins | March 16, 2009, 12:00 AM PDT | Latest comment by fallon.stuart@...
-
Quickly fill blank cells in Excel
Blank cells can spell trouble. Here's an easy way to fill in those blanks and protect the validity of your data.
Posted by Susan Harkins | April 26, 2010, 10:50 AM PDT | Latest comment by Midhunmj
-
Convert your Word documents into PowerPoint 2007 presentations
If you need to make a PowerPoint presentation from a Word document, don't worry about endless cutting and pasting. Mary Ann Richardson shows how you can use Word's built-in formatting to make an...
Posted by Mary Ann Richardson | April 1, 2008, 12:00 AM PDT | Latest comment by nor12345
-
A quick and dirty way to compare columns of Excel data
Using this little-known feature in Excel, you can quickly compare one column of data to another.
Posted by Susan Harkins | April 6, 2012, 11:41 AM PDT | Latest comment by HAL 9000
-
Build a simple timesheet in Excel
Excel makes it easy to set up a system for tracking time. Follow these steps to create your own or download our sample timesheet template and customize it to fit your needs.
Posted by Susan Harkins | January 26, 2010, 9:43 AM PST | Latest comment by raj_as
-
Create an Excel data entry form that includes check boxes
You can keep a lot of information on an Excel data entry form, but you can make it easier for your users -- and yourself -- to create tables by adding check boxes. Here's how to set up check boxes...
Posted by Mary Ann Richardson | July 31, 2007, 12:00 AM PDT | Latest comment by Corbybhoy
-
Delete a stubborn page break in Word
Sometimes, Word won't let you delete a page break. The fix is usually simple -- although the cause might surprise you.
Posted by Susan Harkins | January 8, 2010, 7:13 AM PST | Latest comment by kramer22
-
10 things you can do to give your PowerPoint presentations a heartbeat
This information is also available as a PDF download. Imagine this: You've just returned to your seat for this afternoon's training seminar. The morning session was pretty interesting, providing...
Posted by Katherine Murray | July 10, 2007, 2:44 PM PDT
-
Use a formula to trigger Excel's Conditional Formatting feature
If you need a visual clue to hype a worksheet, use Excel's Conditional Formatting feature to help values stand out.
Posted by Susan Harkins | January 5, 2009, 1:07 PM PST | Latest comment by JNirvaha
-
Use a custom format in Excel to display easier to read millions
Use a custom format in Microsoft Excel to reduce the number of digits in a large number without losing its scale.
Posted by Susan Harkins | March 14, 2012, 11:16 AM PDT | Latest comment by jeng02@...
