Mortgage Calculator A list of useful Office Shortcut Keys County Statistics Ag Statistical Information Communication & Letter Writing Tools Lien presentation Motel Hotel Valuations

South Dakota Land Patents Equalization Records Retention/Destruction Ag Market Trends 1991-2006 Search for Corporations in South Dakota FCC Antenna Registrations Data Place

Zip Code Look-up Phone Number Look-up Area Calculators School District Maps An everyday guide to appraisals of real property Search information in your zip code Owner Occupied Form online forms

I thought I would like to share some computer tips with everyone....they are pretty handy tidbits of information that I come across from time to time that may be of interest to some of you.

What Was That Function Again?

Ever find yourself working in MS Excel and realize the function you want is right on the tip of your tongue, or in this case, your fingers? And there you go again. You have to open the Paste Function window and in doing so, you're probably taking your hands off the keyboard and back to the dreaded mouse to get to the Insert menu, Function choice. Or, maybe you're using the Function button. Either way, it's time consuming and annoying!

Want a keyboard shortcut you can use for the Paste Function window? Yes? I thought you might. I mean, we can all use a time saver here and there!

So, the next time you need to look up an Excel function, try Shift + F3.

The Paste Function/Insert Function dialogue window will immediately open up.

You can search for a function with a description at the top or just below that, you can select a category and scroll through the list it produces.

When you've found what you're looking for, select it and click OK.

For all you Excel 2007 users, you have yet another easy way to search for your functions. You need to take a look at your Formulas ribbon.

Here you'll find that the formula categories are easily accessible. By clicking one of the categories, a list of those formulas will open for you to pick from.

Fix Your Page Border Dilemma

Ever try to print a page border on an MS Word document, only to find out the bottom is missing?

What did you do?

Probably everything you could think of, right? You know, choosing a narrow border, changing margins and so on.

Did it work?

Probably not. So, what did you do then? Remove the border completely?

Let's hope not!

I'd like to suggest that we take another look at the page border tab and see what we can do. After you've made your choices, don't click OK. Instead, take a closer look at what's available.

Have you ever noticed the Options button on the right side?

Click it.

When the Options dialogue window opens, you're looking for the "Measure from:" field in the top section.

Use the down arrow to select Text.

The margin numbers in the fields above will then change. They represent the amount of space from the text area of the page to the page border.

You'll need to experiment with those settings to see what you like best.

Click OK to exit the options.

Click OK again to exit the page borders.

Once you're back in your document, you can see the borders you've set and you should find that with the page border pulled in closer to the text, your printing dilemma is gone!

 

I'll Reply to That Later

Do you have an e-mail in MS Outlook you know you need to reply to, but you just don't have the time right now?

I know you hate to just leave the e-mail sitting there though, because let's face it, there's a very good chance you'll completely forget about it.

So, what can you do to ensure you address the situation on time?

Well, I can think of a couple of things. First, you could set up an appointment for the message.

Yep, that's right, I said appointment. You can turn that e-mail into an appointment so that Outlook reminds you to take care of the situation before it's too late.

To create an appointment for your message, simply drag and drop it into the Calendar section on the Outlook Bar (or drag it to the Calendar folder).

A new appointment will open up with the body of the message already there. Next, simply complete your normal steps for setting up appointments (don't forget to set enough reminder time for yourself to get the job done) and hit the Close and Save button.

With the appointment set, you'll be reminded to handle the message just like you're reminded about any other appointment you create.

A second way to get Outlook to give you a helping hand when it comes to that message you just can't forget is to use message flags.

To flag a message, select it and right click.

In older versions of MS Outlook, you'll see this:

From the menu that opens, choose Follow Up.

The Flag for Follow Up dialogue window will then open, allowing you to set up some basic information.

When you've set everything to your liking, click OK.

Now, for those of you working with Outlook 2007, here's what you'll find.

When you right click on the message, you'll find that the Follow Up choice opens as a submenu.

You can quickly pick one of the Quick Flag times offered or choose Add Reminder, which will open the following dialogue window:

Set your preferences and click OK.

Outlook will remind you about this item if the flag has not been cleared by the due date/time you set. (That's right, this option isn't a reminder before the time you set, rather it actually lets you know right after the time it was due).

When a message has a Follow Up Flag, there's a red flag displayed with the message (in Outlook 2007, instead of a red flag, you'll see the text "Follow Up") as a visual reminder that the e-mail requires your attention.

Once you've completed the job, right click on the message again and choose Flag Complete or Mark Complete (depending on your version of Outlook).

To remove a Follow Up Flag, completely right click on the message and choose Clear Flag from the menu.

There you have it! Two ways you can deal with an e-mail message later on, without it slipping your mind. Yep, Outlook's got you covered!

Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats

Are you tired of receiving documents from Microsoft 2007 users, and not being able to open them?  This link will take you to a web-site that will help you open, edit, and save documents, workbooks, and presentations in the file formats new to Microsoft Office Word, Excel, and PowerPoint 2007.

 

 

I would like to say Thanks to

for their computer wisdom