- Follow this blog:
- RSS
- Email Alert
Microsoft Office
Mark Kaelin
TechRepublic Staff
Mark Kaelin
-
How to toggle Excel row and column headers
Excel displays heading cells for each column and row in every sheet. Those are the gray cells at the top of each column and to the left of each row. They help you navigate the sheet. However, you...
Posted by Susan Harkins | August 31, 2007, 12:00 AM PDT
-
How to disable automatic hyperlinking
Hyperlinks are great tools -- a quick click and you're on your way some place else, without a map! To create a hyperlink, simply type a Web address (URL) or an e-mail address. Office will...
Posted by Susan Harkins | August 29, 2007, 12:00 AM PDT | Latest comment by ssharkins@...
-
Illustrate data tables using Excel charts
Charts are an easy way for people to easily assess your data, but you may run into trouble including data tables in your Excel form. Here's how to illustrate data tables using Excel charts.
Posted by Mary Ann Richardson | August 28, 2007, 12:00 AM PDT | Latest comment by jimit.7830@...
-
Use the Access 2007 Ribbon to design professional-looking forms
If you're making a form in Access 2007, you can take advantage of the Forms Design Tools Ribbon to create the layout you want with ease.
Posted by Mary Ann Richardson | August 28, 2007, 12:00 AM PDT
-
Save time with these Word 2007 edit options
Word 2007 has some neat new features, including the ability to format your document the way you want. Unfortunately, sometimes when you edit, your document's formatting can get mixed up. Here's...
Posted by Mary Ann Richardson | August 28, 2007, 12:00 AM PDT
-
How to integrate existing tables with a PowerPoint presentation
You can create a table in PowerPoint, but if the table already exists in Word, why bother? It's more efficient to use an existing table. To insert an existing table into a PowerPoint presentation,...
Posted by Susan Harkins | August 24, 2007, 12:00 AM PDT
-
How to slim down Outlook’s Message List
Outlook is very busy…sometimes too busy. Some of the default settings are overkill. If you’re like me, you want more message and less extraneous information about the message. By default,...
Posted by Susan Harkins | August 22, 2007, 9:35 AM PDT | Latest comment by cbermudez@...
-
Compare two sets of Excel chart data using transparent columns
You may only have room on your desktop for one Excel chart, so how do you assess two charts without printing them both out? Learn how to make your charts transparent for easy data comparison.
Posted by Mary Ann Richardson | August 21, 2007, 12:00 AM PDT | Latest comment by RobinHackshall
-
Create a field for a changing Access data table using the Lookup Wizard
When information changes, it may be a challenge to ensure that the facts are consistent everywhere. With Access, you can make sure this is the case by using the Lookup Wizard to create a field for...
Posted by Mary Ann Richardson | August 21, 2007, 12:00 AM PDT
-
Set [Tab] to correctly indent your paragraph in Word
Sometimes the [Tab] key in Word works a little too efficiently, indenting sections and paragraphs you don't want moved. Mary Ann Richardson guides you through the pitfalls -- and benefits -- of [Tab].
Posted by Mary Ann Richardson | August 21, 2007, 12:00 AM PDT | Latest comment by gmdp
-
How to select blocks of columnar text in Word
Moving text from one column to another can be frustrating unless you know a trick or two. With tables, the move is easy. For instance, switching the second and third columns in the table below is...
Posted by Susan Harkins | August 17, 2007, 3:40 PM PDT | Latest comment by ssharkins@...
-
Create a shortcut to paste unformatted text into a Word document
This information is based on a TechRepublic PDF download and photo gallery. All kinds of situations call for pasting text into a document without bringing the formatting with it -- like when you...
Posted by Jody Gilbert | August 15, 2007, 12:36 PM PDT | Latest comment by EnigmaV8
-
How to use Access' conditional formatting feature with muliple controls
Recently, I learned that Access' conditional formatting feature handles multiple controls. For instance, you can use conditional formatting to highlight an entire row in a continuous form. To do...
Posted by Susan Harkins | August 15, 2007, 10:48 AM PDT
-
Two tricks for instant access to Word documents
Tech support often seems to be mostly a matter of solving problems and saving users from themselves and their inexplicable actions. But sometimes, you get to play the hero and share some tips that...
Posted by Jody Gilbert | August 14, 2007, 2:03 PM PDT | Latest comment by intouchmw
-
Linking multiple list boxes in Access
Access' list boxes are handy for referencing particular records, but they can quickly get out of control. Here's how to link certain list boxes together, eliminating the need for time-consuming...
Posted by Mary Ann Richardson | August 14, 2007, 12:00 AM PDT | Latest comment by tanyaacatherine@...
-
Customize the Word 2007 Ribbon with these quick tips
Is the Word 2007 Ribbon getting unwieldy? Mary Ann Richardson explains how you can put your most used commands on the Ribbon -- or move it altogether.
Posted by Mary Ann Richardson | August 14, 2007, 12:00 AM PDT | Latest comment by webweasel2@...
-
Monitor performance with Excel 2007's conditional formatting
Red means stop, green means go, yellow means watch out. By employing this principle, you can monitor data and inventory performance -- green for good, red for not-so-good -- across your Excel 2007...
Posted by Mary Ann Richardson | August 14, 2007, 12:00 AM PDT
-
How to change the display of Outlook contacts
To address a new e-mail message, you may click the To button to display all your contacts. By default, Outlook displays the names in alphabetical order, by first name. If you have many contacts,...
Posted by Susan Harkins | August 12, 2007, 1:30 PM PDT | Latest comment by kcjohns
-
How to use constants to handle Jet and Transact SQL conflicts
Many Access databases are upsized to SQL Server, and usually that means a lot of work because the two databases use different versions of SQL. A perfect example is wildcards, which often appear in...
Posted by Susan Harkins | August 12, 2007, 1:27 PM PDT
-
Change Excel 2007 spreadsheets to tables for easier data analysis
Excel spreadsheets may be good for calculations, but reading them can be challenging. Here's how to convert your Excel 2007 spreadsheets to easy-to-read tables.
Posted by Mary Ann Richardson | August 7, 2007, 12:00 AM PDT
-
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
-
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
-
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
-
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
-
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
-
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 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@...
