Tech Tips Home
The Best Tech Tips And Daily Deals
Newsletter On The Internet!

Shop online 24hrs a day or call us Mon-Fri
8:30AM-4:30PM EST - 1-800-915-2088
WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Archive for the ‘MS Office Help’ Category



Sorting Data in MS Word

Thursday, January 12th, 2006

Sorting Data In MS Word

Have you ever found yourself wishing that the list you just typed into MS Word was alphabetized? Or, for those of you who are good with Excel, you’re probably wishing that you typed the list in Excel in the first place (where it’s so easy to sort data).

Well, stop dwelling on the “should have, could have” stuff and smile. It’s very easy to sort… Continue reading

Space It Out

Thursday, January 12th, 2006

Space It Out

By default, MS Word documents are single-spaced, which is great for most of the work we do, but what about those documents where you need double space?

Now, as I’ve said before, I’m a teacher. I have a lot of opportunities to see how people (both students and staff) are using their technology. I’m always amazed when I find someone using the enter key to double-space their… Continue reading

Just Picture It

Thursday, January 12th, 2006

Just Picture It

Yesterday we discussed adding the Options button to our MS Office Toolbars and when we were done our button was a rather plain looking thing simply labeled with the word Options.

Now, how is it that the buttons Microsoft uses are pictures and all we get are words?

Well – fortunately this is a situation we can do something about.

There’s two ways to handle the situation… Continue reading

Just a Suggestion

Thursday, January 12th, 2006

Just A Suggestion

If you’re an avid reader of the MS Office Tips, then you’ve probably noticed by now that we tend to use the Options choice located in the Tools menu frequently. We may use it so frequently that by now you’re sick of the whole Tools menu, Options choice process.

If you’re a fan of keyboard shortcuts, then you probably already access this with Alt, T then O… Continue reading

Change It Up

Thursday, January 12th, 2006

Change It Up

Do you use MS PowerPoint’s design templates? You know – the cool backgrounds that PowerPoint offers ready-made that can really help brighten up a presentation.

If you’re like me, you tend to have a hard time deciding which one to use and often change your mind several times while working on the presentation. During all the mind changing, do you ever wish for a quick and easy… Continue reading

Now Who Told Excel To Paste That Data?

Thursday, January 12th, 2006

Now Who Told Excel To Paste That Data?

Have you ever found yourself asking that question? (Or, in my case, asking the computer the question in my “I’m not amused, just annoyed” voice).

You may have, especially if you work with hidden cells. (You know, hidden rows and columns with data in them that’s necessary but not to be displayed.)

When you select a range of cells to copy that… Continue reading

Convert It To A Value

Monday, January 9th, 2006

Convert It To A Value

Do you have an Excel formula in a single cell that needs to be converting to its value?

No problem. Simple select the cell and press F2 then press F9.

Voila! The cell contains the value of the formula not the formula itself.

Unfortunately, you’ll find that this little trick doesn’t work on multiple cells – so now what?

Tackling this one isn’t as difficult… Continue reading

More Than A Simple Paste Button

Monday, January 9th, 2006

More Than A Simple Paste Button

Working with a newer version of Excel? Let’s say Excel XP or newer?

Have you ever noticed that your Paste button has a little extra?

Take a good look… do you see the down arrow to the right of the Paste button?

Yep – that’s right, the down arrow means that Excel has a supercharged Paste button that can do more than you’d… Continue reading

It’s Cooler in the Shade

Monday, January 9th, 2006

In the vein of recent tips dealing with ways to dress up your documents, worksheets, presentation, etc., let’s check out another way to create unique and eye-catching elements. (Just one last “fun” thing before we get back to all that productive stuff.)

What I’m talking about today is the Shadow button from your Drawing Toolbar.

It’s another simple way to change a basic object into something that really adds… Continue reading

Help Is On The Way

Monday, January 9th, 2006

Are you new to MS Word? Did you recently switch from WordPerfect to Word?

Do you find yourself confused sometimes? Can’t quite find what you need?

Would you like Word to provide a little assistance with your transition?

Well, if you’re answering “Yes!” then here’s the way to get Word to give you a helping hand.

First you’ll need to go to the Tools menu, Options choice.

Then on the… Continue reading

Set It In Pixels?

Monday, January 9th, 2006

A reader wrote in with an interesting Excel question. They were wondering if there was a way to set the column widths and row heights using pixels rather than the default numeric values. Hmm. Good question!

I did some looking around and found a solution – probably not the one the reader was hoping for but it’s worth mentioning.

While I couldn’t find a place to type in an actual… Continue reading

Headings Using The Keyboard

Monday, January 9th, 2006

Do you use Word’s built-in styles for quick and easy text formatting? You know, using the drop down list to the left of the font name?

Works great—not too difficult.

But… for everyone who likes the headings but hates using the mouse here are a few keyboard shortcuts to help you apply the most common styles.

  • CTRL+SHIFT+N will apply the Normal style.
  • ALT+CTRL+1 will apply the Heading

Change It Up

Friday, January 6th, 2006

Change It Up

Do you use MS PowerPoint’s design templates? You know – the cool backgrounds that PowerPoint offers ready-made that can really help brighten up a presentation.

If you’re like me, you tend to have a hard time deciding which one to use and often change your mind several times while working on the presentation. During all the mind changing, do you ever wish for a quick and easy… Continue reading

Case Sensitive Sorts

Friday, January 6th, 2006

Case Sensitive Sorts

Do you sort a lot of data in MS Excel? Ever find that you have case sensitive data (part numbers, account numbers, etc.) that just don’t seem to sort properly? Does Excel ignore upper and lower case and sort purely on letter content? Is this a problem for you?

If it is, then it seems to me that you do a lot of manual manipulation of your… Continue reading

Replace It With Something Beautiful

Thursday, December 22nd, 2005

Many of you know that you can add to Word’s AutoCorrect “replace as you type” list. You know, the little gadget quietly using a preset list to automatically correct many common typos such as changing “teh” into “the”.

Well, a question came in from a reader who was looking to put specially formatted text into this list so that a simple

hh

might be replaced with

color and all… Continue reading

From Another Workbook

Tuesday, December 20th, 2005

From Another Workbook

Last week we discussed how to write Excel formulas that reference cells located on a different worksheet within your workbook. Well, the logical occurred – a reader wrote in inquiring about formulas that reference cells from a completely different workbook.

Good question – one that I immediately set out trying to answer and here’s what I found…

The easiest way to tackle this one is to let… Continue reading

Leave My Addresses Alone!

Tuesday, December 20th, 2005

Leave My Addresses Alone!

Tired of the way your program (Excel, Word or PowerPoint) keeps changing all your web or email addresses into hyperlinks automatically?

Looking for a way to get these programs to stop it and behave themselves?

If you’ve been answering with yes responses then here’s just the thing for you.

What you have happening is the AutoCorrect feature of the program(s) is taking over each time it… Continue reading

3D Extreme

Tuesday, December 20th, 2005

3D Extreme

On Monday we had a little fun with our files and went over the 3D button located on the Drawing Toolbar.

Well, that was the basics—ready for the rest?

Was that a “Yes” I heard?

Good.

Then lets get back to the fun of 3D objects.

When you selected your object and clicked on the 3D button did you notice the option of 3D Settings at the bottom?… Continue reading

From One Sheet To The Next

Thursday, December 15th, 2005

From One Sheet To The Next

Work with MS Excel a lot? Do you use multiple sheets inside the same workbook?

Have you ever found yourself trying to reference a value from a worksheet other than the one you’re currently working with?

I’d bet that you noticed a problem when you tried the same old formula… if you need the value from cell B2 from sheet 1 in a formula… Continue reading

Anchor Your Word Selection

Thursday, December 15th, 2005

Anchor Your Word Selection

Many of you may know that the F8 key will anchor the cursor for highlighting in MS Word. It’s a great trick that allows for text highlighting using only directional keys (arrows, page up/down) or a click of the mouse. It’s something that can really help people who aren’t so savvy when it comes to highlighting text in a document while holding down a multiple-key combination… Continue reading

The Power of T

Thursday, December 15th, 2005

The Power of T

When you’re working in MS PowerPoint do you make multiple changes to the text font… such as font type, size, color, style, shadow effect, etc?

Do you prefer to make these changes in a “one-stop” place where all the selections are together instead of spread out among several different buttons, color palettes and lists?

If this suits your preferences then you’ve probably discovered PowerPoint’s Font dialogue… Continue reading

3D Fun

Thursday, December 15th, 2005

Do you constantly find yourself looking for a way to “jazz up” a document, presentation or worksheet?

Most of you already know that you can use the Drawing Toolbar’s AutoShape feature to create simple shapes for emphasis.

Maybe something like this:

Look familiar?

Yes, that’s right, it’s pretty much the shape used in the title but with one huge difference—that title is in a 3D form. Way more… Continue reading

Excel’s Name box

Thursday, December 15th, 2005

Did you know…

… that Excel’s Name box isn’t always the Name box? (The box to the left of the Formula bar.)

Sounds crazy—I know—but it’s true.

Pay attention when you type in an equal sign (=) to start a formula.

Did you notice what happened?

A Function box replaces the Name box.

The Function box first displays the last used function.

If that’s not what you’re looking for… Continue reading

Help With Excel Formula Syntax

Thursday, December 15th, 2005

Help With Excel Formula Syntax

So, you’re trying to use a formula in MS Excel but it’s been a while and you can’t quite remember the formatting to use when entering the cell references of the data. Hmm… what to do, what to do?

Well, if you’ve got a newer version of Excel (let’s say XP or newer) then the gentle reminder you need is closer than you think.

To… Continue reading

Fast Save = Bigger File Size?

Thursday, December 15th, 2005

Fast Save = Bigger File Size?

Did you know that MS PowerPoint comes with a Fast Save option? In fact, PowerPoint has probably been using a Fast Save setting the whole time – so what exactly is it doing for you?

PowerPoint’s Fast Save “speeds up saving by recording only the changes in a presentation”. The good news is that your saves have been as fast as PowerPoint could offer… Continue reading

Quicker Custom Toolbars

Thursday, December 15th, 2005

Quicker Custom Toolbars

If you have MS Office 2000 or newer you’re in for a real toolbar treat!

Have you ever noticed the little down arrow at the end of displayed toolbars?

No?

Well then take a look… they’re sitting right there—plain as day—and they can bring some customizations down to a couple of clicks.

Click on one of the arrows.

What do you see?

Add or Remove… Continue reading

Another Quick Fix For The Eyes

Tuesday, December 6th, 2005

Another Quick Fix For The Eyes

Tired of squinting when you read your email? Maybe someone sent you something that’s just too difficult to read “as is”.

Looking for a quick way to make the font larger without making the change permanent?

Let’s tap into yesterdays mouse scroll wheel technique to get this job done.

In MS Outlook, as well as Outlook Express, you will be happy to find that… Continue reading

Free Newsletter Signup



Tech Tips Daily

Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

Tech Tips Weekly

The week's best in tech and computer help. Get your issue sent to your email every Friday!

WorldStart's Daily Deals

The very best deals on the Internet! Get a new set of incredible sales every day of the week!

Just For Grins

Clean jokes, funny quotes, and hilarious comics. Sent 5 times a week straight to your email.


Subscribe


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive


Categories:
Archives: