Word: Deleting whole words at a time

This tip comes from WordRibbonTips:

While editing documents, it is not uncommon to delete words, phrases, and the like. Different people take different approaches to the task. For instance, some people just select the text and press Delete, while others may simply hold down the Delete or Backspace keys until the unwanted characters disappear.

If you are in the latter group, and you spend a lot of time pressing Delete or Backspace, you may be interested in a handy shortcut provided by Word. All you need to do is hold down the Ctrl key to speed up your deletions. Using Ctrl+Delete deletes text from the insertion point to the end of the next word. For instance, if you wanted to delete four words to the right, simply press Ctrl+Delete four times. Likewise, Ctrl+Backspace deletes words to the left of the insertion point.

An interesting use of these shortcut keys is to speed up editing tasks, not just mass deletions. For instance, let’s say you wanted to change the word “sidestep” to “sideways.” Normally you would find some way to simply delete “step” and type “ways.”

This could involve pressing Delete or Backspace four times to get rid of the unwanted portion of the word. You can make your edit faster if you just position the insertion point at the beginning of “step,” press Ctrl+Delete once, and then type “ways.”


Excel: How to identify duplicate values but not delete them

One of my favorite features within Excel is to be able to delete duplicates from a list. I will write a post on that feature in the near future. Sometimes, however, you just want to know if there are duplicates. Not necessarily delete them.

The conditional formatting feature within Excel is the solution for this one.
Living under the HOME tab, the conditional formatting is pretty powerful and can provide all sorts of color coding for your needs. In this case, we choose Conditional Formatting, then Highlight Cells Rules, then Duplicate Values. You choose the color, and voila, you have instant recognition of duplicate values.

Excel - duplicate values

Using Templates in OneNote

For some reason, templates in OneNote are not tied to a document; rather they are computer-specific and can only be applied using the desktop version of OneNote. Therefore you will need to add templates to your own computer before you will be able to apply them to the document.

Creating Templates

  • Go to INSERT | Page Templates | Page Templates
  • Design or choose page from which you want to create a template you want to add, and at the bottom right of the Page Template panel, it has a link for “add template” – click on that, and name your template.
  • Then choose the next page, and follow the same instructions.

Whichever template you want to be the default for the section that you’re working with, set as the default.

To use the templates in your document

  • Go to INSERT | Page Templates | Page Templates
  • On the drop down menu, either choose the template you want (if it’s shown), or
  • Click on Page Templates

You will have a list of templates on the right hand side of your screen.

Click on the template you want; it will create a new page with that template.

Handy newsletters for learning Word and Excel

Have you ever been frustrated, knowing that Word or Excel can probably do something, and that you’re missing out?

In this post I want to share a resource that I have been using for many years. A gentleman by the name of Alan Wyatt began creating a tips site for all kinds of things, but especially for Excel and for Word.

He publishes weekly newsletters for Word with Ribbon (Word 2007-present) and Excel with Ribbon (Excel 2007-present) which contain 4 tips for each. He also continues to support the older versions of Word and Excel, which he calls “Word Menu” and “Excel Menu”, because they handled everything via a menu standpoint instead of the ribbon, which is a more graphical way for us to find our tools.

He also publishes “Daily Nuggets” for both Excel and Word, which contain 1 tip per work day. The daily nuggets are different tips than those which appear in the weekly email.

I subscribed to his emails back during the Office 97 days, and I take for granted now all of the things I have learned from him and his readers over the years. I also was pleased to contribute to some of his tips over the years as well.

Using the Group By feature in your list views

One of my favorite features in the list view is the ability to group the list by certain items. I just wish it let me group by more than 2 columns.

Group By helps declutter a list and let you choose what you want to see.

I used the group by feature at my previous employment religiously when I was reviewing the task list for our department. I could group by the person responsible for doing the job. SharePoint Online handles this a little differently, and Group By doesn’t work on the Assigned To field, but we have workarounds for that, which I will cover in future posts.

Our department also has an Outcome Tracking subsite where we are tracking our Missions, Goals, and Objectives. Using the Group By feature lets us group our list of tactics by Goal, then Outcome. On the task level, we sort by Outcome, then Tactics.

Once we have a good list of completed tasks, I can export that to an Excel sheet where we can use Pivot Tables and other such tools to help track how many tasks were completed toward each goal.