Change Signatures in Outlook

I’ve got a few different Signatures set up in Outlook 2007. Most of the time I use my business signature, but occasionally I’d like to use one of the others.

Usually I use the Ribbon commands, but I’ve just discovered a mouse shortcut that makes it much easier. I’ll be using the shortcut from now on.

Use the Ribbon

To insert a different Signature with the Ribbon commands:

  1. Create a new Outlook message
  2. On the Ribbon, click the Insert tab.
  3. Click Signature, then click a Signature name, or click Signatures, to open the Signatures and Stationery dialog box.

OutlookSig02

Use the Mouse Shortcut

With a mouse shortcut, it’s even easier to change or create a Signature.

  1. In a Outlook message right-click on the Signature
  2. In the popup menu, click a Signature name, or click Signatures, to open the Signatures and Stationery dialog box.

OutlookSig
___________________________

10 Hours to an Organized Office

Last December, Priacta offered free enrollment in Total Relaxed Organization, their online time management course, so I signed up, and worked on the lessons over the Christmas holidays.

It changed the way I work, and almost three months later, I’m still using the techniques that I learned.

The course is based on Getting Things Done, and helps you clear up your workspace and organize your tasks. You can customize the course for the PDA or smart phone that you use, and your preferred task list. I chose Outlook (Excel wasn’t an option) and Blackberry.

The course is in three parts:

  • Principles and Preparation
  • Collecting and Organizing
  • Processing, Reviewing, Doing

The lessons were well organized, and clearly written, with a navigation pane at the left, and lesson content on the right.

Priacta01

The site records the time you spend on the online course, and it took me about 10 hours complete the lessons.

I spent a few more hours offline, cleaning up my office. Telephone coaching was offered at several points during the course, to speed up the process, but I didn’t opt for that.

I’m sure the coaches are fine people, but I didn’t hit any snags where I felt a personal coach would help.

What I Learned

The object is to collect your tasks in a few specific places, such as email, voice mail and inbox, instead of many scattered places, including your memory.

Then, you process what you’ve collected, and work from a prioritized task list, with supporting documents filed away until you’re ready to use them.

For me, this was the most useful lesson, because I used to keep stacks of folders near my desk, for projects I was working on. Now the papers are filed by client name, and I can’t feel their beady eyes burning into me as I work.

That reduces my stress level, because I’m dealing with one task at a time, not trying to juggle several things.

I didn’t like all of the suggestions for changes to Outlook, so ignored much of that. Also, although I chose Outlook during the setup, I substituted my Excel task list, so didn’t follow all the steps exactly.

I was able to categorize, sort and filter things in Excel, but in a slightly different way than you would in Outlook.

Have You Tried It?

I think the first 8 or 9 lessons are always free, and the complete course (23 lessons) is $99 (the site says it’s currently $69). The course might not suit your work style, but if you want to get organized, look at the free lessons and see if you like it.

Have you already tried the course, or something similar? Did you find it helpful, and stick with it?
_________________

Cannot Shift Objects Off Sheet Excel Error

Recently, while working on a small worksheet in Excel, I tried to insert a new row. Up popped an annoying error message, “Cannot shift objects off sheet.” Here’s how I investigated the problem, and fixed it with a simple keyboard shortcut – Ctrl + 6

Continue reading “Cannot Shift Objects Off Sheet Excel Error”

AutoFilter By Selection In Excel

In Excel 2003, you can add a couple of buttons to the toolbar to make it easy to filter a table.

For example, in the table below, the East region is selected. With one click of a button, and no programming, you can add an AutoFilter and filter the table to show only the East region orders. Thanks to Roger Govier for sharing this tip.

Continue reading “AutoFilter By Selection In Excel”

Create Bingo Cards in Excel

Bingo Cards in Excel
Bingo Cards in Excel

It’s Friday, and things are slow at the office. To liven things up, you could create bingo cards in Excel, and organize a game during the lunch hour.
In this example, there are three cards, each with a set of random numbers. You’ll need one of those numbered ball popper machines though, or create a number selector in Excel.
Continue reading “Create Bingo Cards in Excel”

Minimize Excel Ribbon – Save Space

If you’re working on a big worksheet, you might want to see as many rows as possible.

The Excel 2007 Ribbon uses about an inch of space at the top of the worksheet, and if you’re just entering or editing data, you probably don’t need to use the Ribbon commands.

The steps below show how to solve that problem.

Minimize or Restore the Ribbon

You can temporarily minimize the Ribbon, so it only uses a bit of space, and that will make room for a few more rows in the Excel window.

To minimize the Ribbon, double-click on the active tab.

RibbonMin01

Restore Excel Ribbon

To restore the Ribbon, so the commands are visible, double-click on the active tab.

Double-click to Restore Excel Ribbon
Double-click to Restore Excel Ribbon

Close Excel

Here’s one more time-saving mouse shortcut, while you’re using the Excel Ribbon:

To close Excel, double-click the Office Button, at the top left of the Ribbon.

  • NOTE: If unsaved files are open, you may be prompted to save the changes.

I use this trick to close Excel, when I’m working on the left side of the Excel workbook. That way, I don’t have to travel all the way over to the Close button, at the top right!
__________________

Tiny Workouts at Your Desk

If you spend long hours working at your computer, with only an occasional jaunt to the lunch room, you might benefit from Twittercize. Ron Doyle is a Denver-based freelance writer who posts short exercises in Twitter, and they’re designed for you to do in a minute or so at your desk.

During the workday, he posts about one tip per hour. For example,

Dilberts: Sit upright, cross arms at chest, contract stomach muscles. Bow forward like you’re banging your head on your desk! 30 times slow!

or

Hulk Hogans: Elbows up, hands at your heart, pull back like Hulk ripping a yellow tank top! Squeeze those shoulder blades 30 times!

Twittercize is free and much easier than getting out to the gym for a workout, although there’s a disclaimer that you should consult your physician before starting any exercise program.

You can follow Ron in Twitter at twitter.com/twittercize.

headbang

__________________

Create a List of What Is On Your Computer

An important step in setting up my new laptop is figuring out what’s on my old laptop. To get a complete list of installed programs, plus details on hardware, installed security updates, and other details, you can use the free program, Belarc Advisor.

Download and install the program, then run it to audit your computer. The results show up in your web browser, although all the details are stored on your computer, not uploaded to the web.

The web page shows your overall audit score, virus protection information, and the status of all Microsoft Security Updates.

Belarc
_______________________

Clear Dead Links From Your Bookmarks

I’m setting up my new laptop, and plan to copy my bookmarks from the old laptop. Before I copy them, I’ll clear out the dead links, to tidy things up a bit. There’s no point in copying useless data to the new machine.

If you’d like to do this on your machine, you can use the free utility AM-Deadlink. It finds dead links and duplicate links in your list of browser bookmarks.

AMDead01

It’s easy to install and use, and takes only a couple of minutes to check my bookmarks (about 1700). Then I sort the list by error number, and delete any 404 pages.

You can also use AM-Deadlink to create backup files for the bookmarks.

AMDead02
___________________________