- Follow this blog:
- RSS
- Email Alert
Microsoft Office
Mark Kaelin
TechRepublic Staff
Mark Kaelin
-
Save keystrokes with this simple shortcut for copying in Word
Save a few keystrokes by using this keyboard shortcut for duplicating text and objects in Word.
Posted by Susan Harkins | January 10, 2012, 8:01 AM PST | Latest comment by luismatoso
-
Double-click shortcuts provide quick access to Word formatting options
Don't wander around a tab or a menu looking for a command when a double-click can get you where you want to go.
Posted by Susan Harkins | January 9, 2012, 1:26 PM PST | Latest comment by RFairbrother
-
Office solution: How to quickly count the number of selected cells
Learn the solution to the Office challenge: How quickly can you count the number of cells in a selection?
Posted by Susan Harkins | January 6, 2012, 8:02 AM PST | Latest comment by zimmerwoman
-
Change Word's default line spacing to what you want it to be
Word 2007 and 2010's line spacing default isn't the same as it was in 2003. Here's how to change it to what you want it to be.
Posted by Susan Harkins | January 6, 2012, 7:59 AM PST | Latest comment by spiessa46
-
Office challenge: How would you eliminate Excel grid lines from a PowerPoint slide?
This week's Office challenge tests your Excel and PowerPoint skills! Is it an Excel problem or a PowerPoint problem?
Posted by Susan Harkins | January 5, 2012, 11:52 AM PST | Latest comment by MargieC
-
A quick way to delete blank rows in Excel
Deleting blank rows in an Excel data range is easy with this technique, but watch out for unintended consequences.
Posted by Susan Harkins | January 5, 2012, 11:48 AM PST | Latest comment by jbenton@...
-
Office solution: How to make Word stop replacing the string adn with and
Learn the solution to the December challenge: Why does Word replace ADN with and and how can you make it stop?
Posted by Susan Harkins | January 4, 2012, 7:05 AM PST
-
Save mouse clicks with Word's highlight shortcut
There's a quick keyboard shortcut in the ribbon version of Word for highlighting text. If you're still using 2003, you can add your own.
Posted by Susan Harkins | January 4, 2012, 6:57 AM PST
-
Office solution: Keyboard shortcuts for hiding and unhiding columns and rows
This week, learn one solution to last week's Office challenge: What's the shortcut for unhiding columns and rows in Excel 2007?
Posted by Susan Harkins | January 3, 2012, 7:55 AM PST | Latest comment by ahmed19imran@...
-
Office challenge: How quickly can you count the number of cells in a selection?
This week test your Excel and math skills by sharing a quick method for determining the number of cells in a selection.
Posted by Susan Harkins | December 28, 2011, 1:52 AM PST | Latest comment by zimmerwoman
-
The most popular tips in the Microsoft Office Blog for 2011
The most popular tips in the Microsoft Office Blog run from the simple to the most complex, but include something for everyone.
Posted by Mark Kaelin | December 20, 2011, 12:09 AM PST
-
Add calculating rows and columns to a Word table
Excel isn't your only option if you need to evaluate values and your primary need is word processing. Use Word's formula feature to perform simple calculations.
Posted by Susan Harkins | December 19, 2011, 7:46 AM PST | Latest comment by gtcowan
-
My 12 favorite Office tips for 2011
The MS Office blog published a lot of tips in 2011. See which tips Susan Harkins likes the most from the past year.
Posted by Susan Harkins | December 19, 2011, 1:13 AM PST
-
Work more efficiently by changing Excel's chart defaults
If you make the same changes to every chart, STOP! Make them once and save your altered chart as the default.
Posted by Susan Harkins | December 16, 2011, 7:35 AM PST
-
How to selectively use clip art components using PowerPoint
See part of a clip art file that you like? Insert it into PowerPoint and use its tools to separate the objects and use them individually.
Posted by Susan Harkins | December 16, 2011, 12:46 AM PST | Latest comment by jlcopp@...
-
Office challenge: Why does Word replace ADN with and and how can you make it stop?
This week, share your Word skills by exposing why Word replaces the three-letter acronym ADN with the word "and."
Posted by Susan Harkins | December 15, 2011, 9:17 AM PST | Latest comment by N / A
-
Use a rule in Outlook to delay email messages
By creating a delay rule, you can control when Outlook sends specific messages. Susan Harkins explains.
Posted by Susan Harkins | December 14, 2011, 7:54 AM PST | Latest comment by ldtech
-
How to insert multiple rows in a Word table
Adding an new row to a Word table is an easy task. Adding multiple rows is just as easy, if you know this simple trick.
Posted by Susan Harkins | December 13, 2011, 7:59 AM PST | Latest comment by bunnylaw
-
Use Spike to copy multiple blocks of Word text or graphics
In Word, the Clipboard has an extended feature named Spike. Use Spike to copy multiple blocks of text to the Clipboard and then paste them all at once.
Posted by Susan Harkins | December 12, 2011, 7:46 AM PST | Latest comment by kozmo_kramer
-
Office solution: Printing different views of the same Excel sheet efficiently
This week, learn the solution to last week's Office challenge: What's the most efficient way to print different areas of the same Excel sheet?
Posted by Susan Harkins | December 9, 2011, 11:52 AM PST | Latest comment by Answers
-
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 jeboy.06
-
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
-
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
-
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
-
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@...
-
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
-
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
-
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
-
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
-
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@...
-
A quick way to delete blank rows in Excel
Deleting blank rows in an Excel data range is easy with this technique, but watch out for unintended consequences.
Posted by Susan Harkins | January 5, 2012, 11:48 AM PST | Latest comment by jbenton@...
-
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
-
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
