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



The AutoSum With More

Tuesday, December 6th, 2005

The AutoSum With More

I’m sure we’re all aware of Excel’s handy little AutoSum button and the way it will quickly insert the formula to sum any range of data we happen to have lying around. But… wouldn’t it be nice if we could get it to do a little more than sums without a lot of extra work?

Good idea! Fortunately for all of us, AutoSum can be used… Continue reading

Managing Bulleted Lists

Tuesday, December 6th, 2005

Use a lot of bulleted lists in MS PowerPoint? How about MS Word? Looking for quick ways to move items in your bulleted list without a cut / paste?

Or… maybe you’d like a way to promote and/or demote items in the list without all the extra work with the increase and decrease indent buttons.

Whatever your particular need, you’re sure to find something here that works for you!

First… Continue reading

AutoSum in Excel with just 2 keys

Tuesday, November 15th, 2005

Sum It Up In Excel With Just 2 Keys?

Many of us are familiar with the AutoSum button in MS Excel.

It’s a handy little guy who will, with a single click, insert the formula for the sum of a column of data located just above whatever cell you currently have selected.

Those of you who prefer to use the keyboard for everything may be wondering if there’s an… Continue reading

An Update On Updating

In the last issue of the MS Office Tips newsletter (Thursday, October 27, 2005), we discussed formulas and using them in MS Word. At the time, my common sense meter must have been a quart or two low, because I simply wasn’t coming up with any of the good ways to get your formulas to recalculate and reflect any changes you’ve made to values.… Continue reading

Recurring Appointments

Tuesday, November 15th, 2005

Over & Over Again

Do you use MS Outlook’s calendar feature? Do you have some appointments (such as weekly staff meetings or daily deadlines) that you repeatedly enter into your calendar?

Outlook can make the repetitive entries for you. To set an appointment as a recurring one, you should first open the appointment.

Now go to the Actions menu, Recurrence choice.

When the Appointment Recurrence window opens, you’ll have a… Continue reading

Data insertion and cell shifting in MS Excel

Thursday, November 10th, 2005

Insert Many Where There Was None

Do you do a lot of copy-paste or cut-paste moves in MS Excel? Tired of shifting cells around to make space for the stuff you need inserted into the middle of your current data set?

How would you like a way to get Excel to do the data shift for you? Excel can shift data at the same time it does the paste. Here’s… Continue reading

MSO Quick Mail option

Thursday, November 10th, 2005

Email It Quick

Do you use MS Outlook notes, tasks, calendar, etc? Ever find that you need to take a task or other item and create an email from it?

Here’s a quick way to take all this information from its original location into a new email without a single copy / paste or (banish the thought!) entering the information by hand twice.

Simply select the item that’s to create… Continue reading

Right-click to drag-drop

Thursday, November 10th, 2005

Drag And Drop With A Right Click?

Yep, that’s what I said! Right click!

We often find ourselves moving text in MS Word with a quick drag and drop, but did you know that if you use a right click instead of a left click, Word will offer you far more than the usual move text thing?

Next time you want to move or even copy text simply follow these… Continue reading

Add Watermarks in MS Word and Adjust Them

Thursday, November 3rd, 2005

Mark It Up

We all know about watermarks, those light pictures or text placed behind our text on printed documents. They can mark a document as a draft or as confidential, or they could be used to enhance the appearance of a document.

With older versions of MS Word you had to do quite a bit of work to get that watermark. You were forced to go through the header… Continue reading

Copy Column Widths in MS Excel

Thursday, November 3rd, 2005

Copy Only Column Width?

How much time have you wasted changing and re-changing column widths trying to match one column with another in MS Excel? You could use the Format menu, Column sub-menu, Width choice and enter the width you need. Of course, then you’d have to know exactly what width you need and keep it all straight… not worth the time.

Do you have to go back to highlighting… Continue reading

Chapter and Page numbers

Thursday, November 3rd, 2005

Chapter Numbers Wanted

Do you frequently use MS Word to produce documents that contain chapters? Looking to use a more meaningful way to number your pages? Might I suggest that you use a page number / chapter number combination? Today, let’s consider the possibility.

First you’ll need a Word document that was created with chapters using the bullets and numbering feature. Wait! Hold on, there’s more. You can’t use just… Continue reading

F7 Spell check word documents and email

Wednesday, October 12th, 2005

Finished writing a word document? Hit F7 to spell check before saving it! It works in composing email in Outlook Express, too. It’s fast, it’s simple, and it can make your communications look more professional.

~ Chris Fisher… Continue reading

Don’t have a web page editing program? Don’t know HTML? No sweat. Anyone can write an email—so why not use Outlook Express to design your web page.

Huh?

That’s right. If you can make a rich text email you can save it as a web page. It won’t be the fanciest site on the net, but at least you’ll have something up.

*Before we get started, you… Continue reading

Calendar Wizard

Wednesday, March 9th, 2005

It’s A Date! Or maybe a week of dates? Better yet, make it a whole month!

Ever find yourself working on a project, proposal or some other item and you really need a calendar to write it all out?

Wait! Idea!

What about a calendar where you could type in your deadlines and other important info so it’s neat, clean and easily revised?

Sound good?

Yeah, I agree. It just… Continue reading

Get rid of the Office task pane

Wednesday, March 9th, 2005

Finding The Task Pane To Be A Pain?

If you’ve got a newer version of MS Office and find yourself disliking the Task Pane that automatically appears on the right side of your screen every time you open a program then I’ve got just what you’re looking for.

One way to disable the Task Pane is to uncheck the “Show at startup” option at the bottom.

Another way is… Continue reading

Perfect Shapes

Wednesday, March 9th, 2005

Have you ever found yourself trying to make a perfect square or circle using the drawing tools for a rectangle or oval? Or maybe you’re trying to draw a perfectly horizontal or vertical line?

Did you find yourself eyeballing the measurements and angles hoping you were getting close?

Did you know that it’s possible for you to use the drawing tools to make these perfect shapes without all the guesswork?… Continue reading

Here’s another quick key combination to use in MS Excel.

This one allows you to highlight an entire row or column with just two keys and no mouse!

  • Ctrl + Spacebar will highlight the column of the cell currently selected.
  • Shift + Spacebar will highlight the row of the cell currently selected.

You can then combine this information with the Shift + Arrow keys to… Continue reading

Format Painter Button

Wednesday, March 9th, 2005

Paint the file red…

…or blue, or whatever formatting you need.

Have you ever found yourself constantly applying the same formatting options over and over again in a file? Maybe you’re changing a font size, bolding and underlining line after line after line.

Getting tired of all the highlighting of text, change font size, click bold button and then click underline button over and over again?

Want a one button… Continue reading

View a whole menu Quickly

Wednesday, March 9th, 2005

In the newer versions of MS Office, you may have noticed that the menus are set to only show the most recently used choices. I really like the feature most of the time but there are times when I just need to see the whole menu, especially when I’m searching for something.

By now most people have figured out that to see the whole menu you have to click on… Continue reading

Driving Directions

Wednesday, March 9th, 2005

Have a contact in MS Outlook that you need to visit in person?

Looking for driving directions?

Yeah, you could go online and enter all the address information into a website and be on your way. But, you’ve already got the address typed into Outlook, why would you want to enter it all again.

Idea!

You could try to copy / paste the information to the web. But, then again… Continue reading

First – Last – First – Last

Wednesday, March 9th, 2005

There are many ways to navigate through an MS PowerPoint presentation but here’s a few quick key strokes that can save you some wasted mouse-to-keyboard time.

In the Normal View…

  • To move up one slide use the Page Up key.
  • To move down one slide try the Page Down key.
  • To move to the first slide in the presentation use the Home key. (If you’re

How Many More Work Days?

Wednesday, March 9th, 2005

Ever need to calculate the number of workdays left until a deadline?

Did you pull out your ever-present calendar and begin counting?

Oops, lost count! Start over.

Or not.

What about letting MS Excel do the counting for you?

If you

Every time you’ve ever tried to edit a document in MS Word while a window (such as the font formatting window) is open you get nowhere. That window just sits there, open and waiting. You certainly aren’t going to make any changes to the document until you’ve made your choices and either clicked OK or Cancel.

Hard to believe that the Find window behaves differently?

Yeah, I thought so too… Continue reading

End The Button Confusion

Tuesday, November 23rd, 2004

End The Button Confusion

Have you ever noticed that many of the custom toolbar buttons you’ve added have the exact same image?

I have—I added a button that takes me to the New window you see when you use the File menu, New choice in MS Word.

Unfortunately, it’s identical to the New button that opens a blank document from the Normal template.

So, what can you do?

Change the… Continue reading

Now Where Did That Zero Go?

Tuesday, November 23rd, 2004

Now Where Did That Zero Go?

Here’s a good tip sent in by a reader regarding numbers with leading zeros.

If you’ve ever entered a number with a zero in the first place(s) you probably became very frustrated when you realized that Excel takes those zeros off the number.

For example, if you type in 01234 then, left to its own devices, Excel will put 1234 into the cell.

That’s… Continue reading

See Online Help Better

Tuesday, November 23rd, 2004

See Online Help Better

Have you ever found yourself squinting to read the topics in the MS Office Suite online help?

I don’t mean the Office Assistant list of ideas, but the actual help windows with all the information. (The one that comes up once you’ve selected a topic.)

If the answer is yes, then my next question is: would you like a way to alleviate the squinting problems?

Yeah—I… Continue reading

Formatting That Demands Their Attention

Tuesday, November 23rd, 2004

Formatting That Demands Their Attention

Do you ever find yourself looking for a way to make something really stand out in a Word document?

I don’t mean just a bigger or different font—I mean a way to put something on the page that can’t be ignored.

There are lots of things you can do (bolding, Italics, AutoShapes, etc…) but maybe turning this

into this

is… 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: