A common task when editing documents is to break up run-on sentences. You can make this task a little easier by using the editing macro described in this tip.

Read this WordTip: Dealing with Run-On Sentences
Microsoft Word Tips - Learn Word Faster!

The advanced filtering feature in Excel allows you to quickly copy unique information from one data list to another. If you want to copy the comments associated with that information, you are out of luck; advanced filtering won't do it. There are workarounds you can use to get the same result, however.

Read this ExcelTip: Copying Comments when Filtering
Microsoft Excel Tips - Learn Excel Faster!

At the end of the day, use this workbook to list and close all the open workbooks, except the macro file. The next day, open this file, then click a button to open all the files listed on the worksheet

If you decide to create a master document, it is easy to do by just adding one or more subdocuments to an existing document. This tip shows how you can use the outlining capabilities of Word to accomplish the task.

Read this WordTip: Creating a Master Document Using Existing Subdocuments
Microsoft Word Tips - Learn Word Faster!

The MODE function is used to determine the most frequently recurring value in a range. This tip explains how to use the function in your worksheet.

Read this ExcelTip: Returning the MODE of a Range
Microsoft Excel Tips - Learn Excel Faster!

Hello folks. 50% of 2020 is behind us. Let me share a few updates with you all. First check out this awesome double rainbow outside our house on 30th June. MVP I am thrilled and humbled to tell you...

continue reading...

Your laser printer probably does a great job in putting black type on the paper. If you want to print gray tones, the results might not be so great. Here is a tip on a way you might be able to get even better looking gray tones from that printer.

Read this WordTip: Great Gray Tones from a Black and White Printer
Microsoft Word Tips - Learn Word Faster!

Even if you do nothing but record macros, sooner or later you will have a need to edit what you record. Here's how to get to the place where you can make the macro changes directly.

Read this ExcelTip: Editing Macros
Microsoft Excel Tips - Learn Excel Faster!

Learn these key skills that most Excel users should do with little or no help. Build better Excel workbooks, to save time and help avoid errors

Word may be used to create protected forms that limit where the user may input data. Normally spell checking is disabled in protected documents. This tip shows how to enable spell checking in protected forms.

Read this WordTip: Spell Checking Forms
Microsoft Word Tips - Learn Word Faster!

Excel allows you to edit the contents of a cell in two places—the cell itself or in the Formula bar. If you want to switch from one place to the other while you are editing, you'll need to rely on the mouse.

Read this ExcelTip: Switching Editing Location
Microsoft Excel Tips - Learn Excel Faster!

Date Challenge; Show Your Name; Product Update; Dashboards; Music; Phase Two

A few places to check if the printout differs from the original document.

Read this WordTip: Small Printing with Different Word Versions
Microsoft Word Tips - Learn Word Faster!

Borders not printing properly? It could be any one of a number of reasons causing the problem. This tip provides some guidance on what you can do to correct the situation.

Read this ExcelTip: Out of Kilter Borders
Microsoft Excel Tips - Learn Excel Faster!

AutoText is a timesaving feature that allows you to assign a word, phrase, paragraph, or graphic to a mnemonic name. Type the name, press a shortcut key, and the mnemonic is replaced with the word, phrase, paragraph, or graphic. Discover how you can take advantage of this powerful tool.

Read this WordTip: Using AutoText
Microsoft Word Tips - Learn Word Faster!

With a long list of items in a worksheet, you may want to determine the last time a particular item appeared in the list. There are a couple of ways you can tackle this problem, as described in this tip.

Read this ExcelTip: Calculating the Interval between Occurrences
Microsoft Excel Tips - Learn Excel Faster!

It appears that Word doesn't allow you to define custom dictionary entries that include ampersands. There are ways you can work around this apparent problem, including a way that relies on AutoCorrect to mark your text so it is ignored by the proofing tools.

Read this WordTip: Adding Ampersands to Custom Dictionaries
Microsoft Word Tips - Learn Word Faster!

Combining workbooks that have cross-links to each other can offer some special challenges. This tip examines how you can get around those challenges.

Read this ExcelTip: Finding Wayward Links
Microsoft Excel Tips - Learn Excel Faster!

Earlier this week, in a private forum, one of my colleagues took a friendly joke thread and dropped a horrible MeToo joke in it. I was astounded, incredulous and disgusted. But I said nothing....

continue reading...

Setting default formats for envelopes is easy; setting them for labels is not so easy. Here are some ideas on things you can try to get your labels closer to how you want them.

Read this WordTip: Setting Default Label Formats
Microsoft Word Tips - Learn Word Faster!