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



MS Word: Mix and Match Labels

Friday, November 12th, 2010

Do you use MS Word for labels?

Ever need to print different labels on the same sheet? (I know I do it all the time at work. I never seem to need 30 of the same thing and I rarely use them for addresses).

Have you figured out how to get Word to give you a blank sheet of labels to work with or are… Continue reading

Dimming Text in PowerPoint

Thursday, November 11th, 2010

If you’re a regular user of PowerPoint animations, then I’m sure that you’ve used some sort of effect when introducing a list of text.

You know what I mean… you’ve got a list of 5 things and each one will slide in on their own click.

This is great because your audience can’t spend their time ignoring you and reading ahead. (Well OK… the… Continue reading

Undo a Move in Outlook

Tuesday, November 9th, 2010

I don’t know about you, but I tend to go through my e-mail messages and then “sort” them. You know, delete it or move it to some folder or another.

When moving messages, I simply drag and drop them into their new location using the folder list.

The problem is that I inevitably drop some into the wrong location.

Usually I… Continue reading

When you use MS Word, do you find yourself updating the exact same information in many different files?

For example, maybe you have a weekly sales figure that is put into several different Word files each week.

Do you open all the files and change the information in each and every one? Even with a copy and paste process it still can take quite… Continue reading

Did you know that you can view multiple presentations at the same time in MS PowerPoint?

It’s not a bad thing to know when you’re trying to compare presentations, or moving items from one to another.

To accomplish this goal, we’re going to need to open all the presentations… obviously, the more you open, the smaller they’ll appear on the screen, so be sure… Continue reading

Moving Through PowerPoint Presentations

Tuesday, November 2nd, 2010

Give a lot of MS PowerPoint presentations?

If you do, then I’m sure you know to click the left mouse button to advance your presentation, right?

You probably even know that you can spin the mouse wheel down to advance the show or up to retrace your steps.

But, did you know that there are a variety of keys that will advance… Continue reading

Send and Receive in MS Outlook 2010

Friday, October 29th, 2010

If you’re anything like me then, despite the fact that you’ve got Outlook set to automatically check for messages every 15 minutes or so, there are times when you want to check it

While I can’t speak for everyone, I’ve always kept a Send/Receive button on the far left side of my Standard Toolbar.

Even in Outlook… Continue reading

Analyzing Filtered Data in Excel

Thursday, October 28th, 2010

So, you like to use MS Excel’s AutoFilter to take a look at your data? (Click here to read about AutoFilters at WorldStart.com)

Ever find yourself thinking that it would be nice to see the filtered data as a graphic?

Did you try it?

Yes, you can create a chart of the filtered data to truly “see” what the… Continue reading

Remove the Duplicates in Excel

Tuesday, October 26th, 2010

Ever find yourself looking at a long list of data containing duplicates and it’s your job to remove the extras?

Sometimes there’s duplicate data for a darn good reason and sometimes it for not only a bad reason, but it’s unacceptable to boot!

If you’re in the latter situation and need to get rid of the duplicates, then you’ve got to be looking for… Continue reading

Repeating Text Entries in Excel

Friday, October 22nd, 2010

So, you’ve found yourself once again entering a bunch of text into an Excel worksheet… and once again, the text is getting repetitive.

Let’s say that you’ve got a list of employees and need to enter the department they work in for each one. This means that you’re in column B typing the same things over and over again – after all, there are a finite number… Continue reading

Using Themes in MS Office

Thursday, October 21st, 2010

Well here we are, several years into learning to work with the Themes that were introduced with Office 2007.

Personally, I really like them, but then again I tend to do a lot with shapes and SmartArt type diagrams with my students, to help them see the connections that they need to make.

At any rate, I use Themes or at least parts of… Continue reading

Using the Equal Sign in Excel

Tuesday, October 19th, 2010

MS Excel: Excel Has Equal Sign Issues?

Well, sort of…

I’d say that Excel has an issue when you’re actually trying to type an equal sign into a cell without starting a formula – in other words you need to treat the equal sign like text instead of a formula starter.

(I found that my Excel 2007 would let me create… Continue reading

Paste Options in Excel

Friday, October 15th, 2010

If you tend to take information from Word, PowerPoint, the Web, or wherever to MS Excel, then I’m positive that you know about your formatting choices when you paste.

We’ve all seen the Paste Options button appear. This is where you can decide to have the information keep its original formatting, or have Excel reformat it to match the rest of the worksheet.… Continue reading

Using the Split Screen in MS Word

Thursday, October 14th, 2010

When working with a very long document, I often find myself scrolling back and forth between different locations of the document to reference, move or copy information from one place to another.

No doubt about it… it’s frustrating.

There’s nothing worse than going to page 25 to retrieve information, then scroll up to page 8 and forget what you just found, by the time… Continue reading

Gaining Screen Space in MS Excel

Tuesday, October 12th, 2010

Do you struggle in a constant battle with Excel and your computer monitor?

Do you always feel like you can’t see enough at one time… whether the problem is a small monitor or a very large worksheet?

Either way, you want to see more without shrinking everything – the eyesight is bad enough – we certainly don’t need

Quick… in MS Word, what’s the difference between Ctrl + U and Ctrl + Shift + W?

Tick-Tock, Tick-Tock…

Give up?

The answer is one little word: spaces.

Let me explain.

I’m sure you all know that Ctrl + U will underline text, spaces and all

Artistic Effects in MS Office

Thursday, October 7th, 2010

I can’t speak for everyone, but when I’m using pictures in my documents, e-mail messages, spreadsheets or presentations, I’m looking to make an impression.

While a picture in its own right can be a very powerful message, sometimes it would be nice to have that same picture presented in a different manner, maybe as a pencil sketch, a chalk sketch, an image seen through glass or even… Continue reading

Moving a Cover Page in MS Word

Tuesday, October 5th, 2010

Using the Cover Page feature of MS Word 2007 / 2010? (Insert tab of the Ribbon, Cover Page button.)

It’s pretty handy and sure makes life easy when you need one.

Have you ever tried to use a cover page in the middle of a document? Maybe you need one as a chapter or section title page?

When you tried to… Continue reading

MS Word Count

Friday, October 1st, 2010

We’ve all had our moments when we needed to know just how many words are in a document. Maybe it’s a paper, essay submission or whatever, but the why isn’t important… it’s the “how many” that counts.

If you find yourself in this particular situation, then here’s where you’ll find a lot of help – anything would beat trying to count by hand!

I… Continue reading

Return to Your Work in MS Word

Thursday, September 30th, 2010

Do you work with long documents in MS Word?

Ever find yourself editing a large document, jumping from location to location, only to realize that you should have done just one more thing at the last editing spot?

How annoying is that? To have to go back through the document and find that exact position again.

Well, wait! What if we… Continue reading

Stop an MS Office Program from Opening

Tuesday, September 28th, 2010

Now I know we’ve all thought that just at the moment of no return when we’ve clicked the wrong icon and instead of starting Word we’ve started Excel… or instead of PowerPoint you’ve started Publisher.

We’ve all done it and it can be a royal pain – especially if your computer doesn’t start programs instantaneously.

So now you wait while the wrong program loads… Continue reading

Naming and Saving Documents

Monday, September 27th, 2010

Anne asks:

This afternoon I finished typing a letter and went to save it and Word would not let me! I have tried and tried; I changed the name a bunch of times and it just kept giving me a bunch of gibberish! It said something about the location and format not being valid; what does that mean? I can’t get it to save and it is

MS Excel: Spreadsheet Solutions

Friday, September 24th, 2010

Microsoft Excel is the most popular spreadsheet program used worldwide but there are some features within Excel which tend to be overlooked even by “power-users”. People who swear by macros, pivot tables, V-Lookups and H-Lookups are unaware of the existence of Spreadsheet Solutions within Microsoft Excel and how to make use of it.

Microsoft Excel provides pre-defined solution templates for:
– Loan Amortization
– Personal… Continue reading

The Difference Between PDF and XPS

Friday, September 24th, 2010

Previously we’ve discussed the ability possessed by MS Office to save files in PDF format and at some time you probably also noticed that the file format XPS seems to be lumped with the PDF choice.

Most of us are very familiar with PDF since so much that we see online is in that format. Forms such as tax forms from the state… Continue reading

Change Default Save in MS Office

Thursday, September 23rd, 2010

If, for whatever reason, you’re using the MS Office 2007 or 2010 programs and always need to save files in a format different from the default then I’d bet that you’re tired of forgetting to make that change.

I don’t know about you, but I just enter a file name and hit the enter key… changing the file type is the last thing I think of.… Continue reading

A Quick Way to Find Information in MS Office

Tuesday, September 21st, 2010

When you’re going into the program options for the newest MS Office programs you might feel a bit overwhelmed.

There’s lots and lots going on in those dialog boxes… categories such as proofing, advanced, save, etc… and then within each of those there are sections of options such as editing, display, print… and if that were not enough there are options in there program specific.… Continue reading

Quick File Conversions in MS Office

Friday, September 17th, 2010

We all know that the newest version of Microsoft Office programs has a lot of really cool features.

We also know that many of these features just don’t work with older file formats.

I can’t speak for you, but I have a lot of files that were created with Office 2002 and I’m not about to start over just to access the new cool… 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: