Home / Blogs
Follow this blog:
RSS
Email Alert

Microsoft Office

Mark Kaelin

Mark Kaelin

TechRepublic Staff

Mark Kaelin

Mark Kaelin
Mark Kaelin is a CBS Interactive Senior Editor for TechRepublic. He is the host for the Microsoft Windows blog, Microsoft Office blog, and Product Spotlight blog.
  • 2

    How to combine the Clipboard and Find/Replace feature for quick edits

    Copying text is a simple task in Office applications. We're so accustom to this process that we don't even think about it. Even text that's not in the same document or same application easily...

    Posted by Susan Harkins | October 19, 2007, 12:00 AM PDT | Latest comment by ssharkins@...

  • 14

    Access 2007 doesn't export to Excel

    You cannot export a report to an Excel format in Access 2007 This might be a bit of a gotcha if you upgrade a database that exports Access reports to Excel.

    Posted by Susan Harkins | October 16, 2007, 9:12 AM PDT | Latest comment by rgerald@...

  • 0

    Keep Word headers and footers from overlapping your document's text

    When you find your header is almost overlapping the first line of text in your Word document, you do not need to make your header smaller; you need to increase the distance of the header text from...

    Posted by Mary Ann Richardson | October 16, 2007, 12:00 AM PDT

  • 12

    Have Access automatically print your reports

    If you need to print out an Access report by 10:00 every Friday morning, you don't have to do it manually. Follow these steps to create a macro to print the report and schedule it to run at that...

    Posted by Mary Ann Richardson | October 16, 2007, 12:00 AM PDT | Latest comment by jteeple@...

  • 16

    Add autonumbering to your Excel spreadsheet

    Unlike Access, Excel does not have an autonumbering feature that increments a number each time you add a new row. With Excel 2003 and 2007, you can use the Row function to add your own...

    Posted by Mary Ann Richardson | October 16, 2007, 12:00 AM PDT | Latest comment by noemir

  • 19

    How to avoid an embarrassing mistake in Outlook

    Have you ever sent an e-mail to the wrong person? If you’re lucky, it didn't matter. However, it could be an embarrassing and even critical error. For instance, let's suppose you have two...

    Posted by Susan Harkins | October 15, 2007, 12:19 PM PDT | Latest comment by cquirke

  • 0

    Tip: Word patch for 2002, 2000

    http://www.microsoft.com/technet/security/Bulletin/MS07-060.mspx  "This security update resolves a privately reported vulnerability in Microsoft Word that could allow remote code execution if a...

    Posted by Susan Harkins | October 14, 2007, 4:19 PM PDT

  • 2

    How to work around an annoying editing setting

    One editing feature that seems to drive some people nuts is the way Word (and many Office applications) automatically selects an entire word when you highlight a partial word. For example, enter a...

    Posted by Susan Harkins | October 11, 2007, 11:34 AM PDT | Latest comment by ssharkins@...

  • 4

    Include an attachment field with your Access 2007 database

    With Access 2007's new attachment fields, you can attach most file types to your database records for better illustration of your data across reports. Mary Ann Richardson explains how you can...

    Posted by Mary Ann Richardson | October 9, 2007, 12:00 AM PDT | Latest comment by vevans@...

  • 5

    Use Word 2007's new Reading Highlight feature to highlight words in your document

    If you've ever wished you could use Word's Find feature to search for a particular word and highlight all occurrences of that word, then have the document stay highlighted even after you turn off...

    Posted by Mary Ann Richardson | October 9, 2007, 12:00 AM PDT | Latest comment by rachelps

  • 13

    Differentiate pie slices with Excel's Bar Of Pie chart option

    Too many tiny slices? One way to make your Excel chart more coherent is to use the Bar Of Pie chart option. The bar of pie chart displays the tiny pie slices into a horizontal bar chart so they...

    Posted by Mary Ann Richardson | October 9, 2007, 12:00 AM PDT | Latest comment by gerila_7@...

  • 0

    How to repair a missing library reference

    One of the most common questions I receive concerns an unexpected error. Everything's working fine and suddenly, the user gets a vague error message that says they're trying to use an undefined...

    Posted by Susan Harkins | October 8, 2007, 12:33 PM PDT

  • 0

    How to avoid Fast Save’s security breach

    If you store sensitive data, you might be at risk, but not the way you think. I'm not talking about a virus or a hacker, but an Office feature that does exactly what it was designed to do. As you...

    Posted by Susan Harkins | October 5, 2007, 6:12 AM PDT

  • 8

    How to move Outlook’s flag column

    You can rearrange, resize, and even remove all of the columns in Outlook's message list in Mail view -- all except the flag column. Moving that column requires more work: Right-click any field...

    Posted by Susan Harkins | October 4, 2007, 1:20 PM PDT | Latest comment by undrline

  • 1

    Formatting Yes/No fields in Access reports

    Check boxes are fine for data entry, but you may not want to use them on a formal report. Follow these steps to create a report that replaces check boxes with specific word properties.

    Posted by Mary Ann Richardson | October 2, 2007, 12:00 AM PDT | Latest comment by ssharkins@...

  • 7

    Transfer information to other documents using Word 2007's View Side By Side feature

    When you need to copy information from one Word 2007 document to another, you could copy and paste -- or, you could just right-click and drag the information from one document to another. Word...

    Posted by Mary Ann Richardson | October 2, 2007, 12:00 AM PDT | Latest comment by Ron_007

  • 3

    Set up minimum and maximum markers on Excel line charts

    When working with an Excel chart, you may wish to emphasize which month had the most sales and which month had the least sales. You could manually add a text box or other graphic to the...

    Posted by Mary Ann Richardson | October 2, 2007, 12:00 AM PDT | Latest comment by shwe

  • 6

    Tip: Excel 2007 has interesting bug

    Thanks to John Bartow for sending a link to Excel Can't Multiply.  I tried it, and it's true. Be sure to read the first response because he share some interesting insight. I can't add anything...

    Posted by Susan Harkins | September 28, 2007, 9:07 AM PDT | Latest comment by farrell_av3

  • 1

    Tip: Excel 2007 bugs

    Thanks to Gustav Brock for this link to Excel 2007 bugs and issues.

    Posted by Susan Harkins | September 26, 2007, 6:30 PM PDT

  • 0

    Tip: Quick word count in Word

    Word count is a critical issue for some of us -- it certainly is for me. Fortunately, it's easy to get a word count for the entire document or even a selection of text: With nothing selected,...

    Posted by Susan Harkins | September 26, 2007, 9:44 AM PDT

Keep Up with TechRepublic

Discover more newsletters

Follow us however you choose!

Media Gallery

View All

Hot Questions

Ask a Question
View All

Hot Discussions

Start a Discussion