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



Two Days In Two Columns

Friday, April 7th, 2006

Two Days In Two Columns

Do you use MS Outlook’s calendar feature?

When using the month calendar, have you ever noticed that Saturday and Sunday are compressed into a single column? This little space saving technique gives you half the space for weekend appointments. Sometimes it’s an okay thing and sometimes it’s a bad thing.

Does it annoy you? Would it suit your needs more to have those days… Continue reading

MS Excel AutoFilter Part 2 – Top 10 and Custom Filters

As promised on Tuesday, we will finish our discussion of Excel’s AutoFilter function. Specifically, we need to cover two items in the AutoFilter pull down lists: “Top 10″ and “Custom.”

So, let’s get right to it.

To begin, I think we should discuss Top 10.

This is pretty much what the name implies. It’s a listing of the top… Continue reading

I Thought Filters Were For Things Like Fish Tanks and Coffee Makers…

Have you ever found yourself lost while working with a huge list or set of data in MS Excel?

Did you find that you were continually scrolling through data looking for a particular value?

I bet more than once you caught yourself wishing for a way to just see what you want and get rid of the rest.… Continue reading

Changing the View, Not the Selection

Friday, April 7th, 2006

Changing the View, Not the Selection

I’m sure just about everyone has used the arrow keys in MS Excel to move through their worksheet.

But, sometimes you want to quickly zip out to another part of the worksheet to see something without moving the cell selection and losing your current place. What do you do then?

I’m betting that many of you take your hands off the keyboard, use the… Continue reading

Organize It Your Way

Friday, March 31st, 2006

Organize It Your Way

If you’re like me, you find yourself saving lots of Outlook e-mails and always sorting them out into different folders for easy access later.

Does it irritate you that every time you create a new folder, Outlook asks you if it should go onto the Outlook bar, then it promptly buries it in the My Shortcuts section of the bar.

I don’t know about you, but… Continue reading

Format Painter Made More Useful

Friday, March 31st, 2006

Format Painter Made More Useful

Do you use the Format Painter in MS Excel to transfer cell formatting from one cell to another?

It’s a good use of the Format Painter function. It’s certainly much easier than starting from scratch with all of the formatting each time. I mean, if you already have cells established with the necessary formatting, why do the work twice?

So, I propose to you one… Continue reading

Linked vs. Embedded Sound

Friday, March 31st, 2006

Linked vs. Embedded Sound

Do you use a lot of music in your PowerPoint presentations? Do you then use these presentations on a different computer?

Ever had a problem with the music? Maybe the music you’ve used isn’t on the new computer and you didn’t know that you had to copy that file too. Oh no, what do you do now?

Well, you could always train yourself to copy sound… Continue reading

Quick and Spiffy Tables in MS Excel

Friday, March 31st, 2006

Quick and Spiffy Tables in MS Excel

Do you usually use MS Excel for table work? Looking for something to help give you a quick and easy visual “edge” when it comes to the presentation of your tables?

If any of that sounds like a good idea, you might be happy to know that Excel has an AutoFormat function just for such a purpose.

In other words, you can quickly… Continue reading

MS Excel Default Font Fun

Friday, March 31st, 2006

MS Excel Default Font Fun

Do you constantly find yourself changing the font size or type in Excel worksheets?

Is it getting annoying to repeat yourself time after time after time?

I bet a few of you even tried looking in the Format menu for something equivalent to the Font choice found in MS Word.

Didn’t find it, did you?

Nope, that’s because it’s not there.

You can find font… Continue reading

Worksheet or Workbook?

Friday, March 24th, 2006

Worksheet Or Workbook?

Did you know that when you do a Find / Replace in MS Excel, you can control how much of the file is searched?

Yep, that’s right. You can choose to work on a single worksheet or on the entire workbook. It’s all up to you. You just have to know where to look for the setting.

To begin, you need to run the Find / Replace… Continue reading

Drag to a New Workbook

Friday, March 24th, 2006

Drag to a New Workbook

Do you find that you’re frequently copying worksheets from an established workbook into a brand new one?

All the copying and pasting can be quite tiresome, so how about a way to drag and drop those worksheets into a workbook of their own?

I just knew that you’d like that idea, so let’s move right to the “how to.”

First, to create a new workbook… Continue reading

Only See the Document

Friday, March 24th, 2006

Only See the Document

Do you find that you are more annoyed than helped by the menus and toolbars at the top of your Word program window?

If you’re answering yes to that question, then I’d bet that you work with keyboard shortcuts a tremendous amount of the time.

Wish there was an easy way to work without looking at all the clutter?

Well, if a minimalist view in MS… Continue reading

Formatting the Numbers

Friday, March 24th, 2006

Formatting the Numbers

Do you use Word’s automatic numbering feature?

Did you ever want to change the style, starting point or formatting of the numbering?

If having control over the way Word numbers your lists interests you, then read on. To take control of your numbered lists, you’re looking to go to the Format menu, Bullets and Numbering choice.

When the Bullets and Numbering window opens, you may have to… Continue reading

Duplicating With Spacing

Friday, March 24th, 2006

Duplicating With Spacing

Do you use drawing objects frequently?

Do you use the same object multiple times and evenly spaced to create interesting effects, dividers or custom borders? Maybe something like this?

Or this?

Whatever you choose to make, how did you make all of those objects?

Did you draw each one separately? Let’s hope not, because I don’t even want to imagine how long it took to… Continue reading

No More Splitting

Friday, March 17th, 2006

No More Splitting

Here’s the scenario: you’re working on a table in MS Word and suddenly a row splits in two. That is, part on one page and part on the next page.

You’re looking this new development over, all the while thinking to yourself, “This just won’t do. The topic in each row really can’t be split apart.”

At this point you’re trying to come up with a solution… Continue reading

Table Toppers

Friday, March 17th, 2006

Table Toppers

Did you know that with just a couple of clicks you could have MS Word automatically repeat your table headings at the top of each page containing the table?

If you answered “No,” then you’ll want to take a quick moment to read this tip, because here’s the trick to beautiful table headings.

First thing you’ll need to do is select the row or rows you want repeated… Continue reading

Customizing My Places

Friday, March 17th, 2006

Customizing “My Places”

When you go to save or open files in a program from Microsoft’s Office Suite, have you noticed the icons on the left side of the window? You know, the column labeled “Look in.”

Ever wish that you could alter that list to make it more useful?

If you like that idea and have a newer version of Microsoft’s Office Suite, then you’re in luck, because… Continue reading

Controls For MS Word Page Breaks

Friday, March 17th, 2006

Controls For MS Word Page Breaks

Along with the ability to manually insert page breaks, MS Word gives you a few ways to control the soft (or automatic) page breaks inserted by the program.

Page break controls can be reached via the Format menu, Paragraph choice.

You’re looking to navigate to the Line and Page Break tab.

Your choices are found in the Pagination section at the top.

At… Continue reading

Page Break Basics

Friday, March 17th, 2006

Page Break Basics

Page break? What’s that?

Are these questions you privately ask yourself when someone is busy talking in “computer jargon”?

Can you practically see the words flying right by you?

Well, reach out your hand and catch these two, because today we’re going to delve into the world of the mysterious page break.

To begin understanding, a page break is the point at which one page ends and… Continue reading

Custom Template Tabs

Thursday, March 9th, 2006

Custom Template Tabs

Do you use a lot of templates?

Are you annoyed by the sheer number of them on the General tab in the Templates window?

Wish there was a way to sort them out and make them easier to locate quickly?

If you find yourself answering “Yes, yes, yes!” then you’re in the right place, because this tip is all about making custom tabs for those templates.

Let’s… Continue reading

Single Worksheet Templates

Thursday, March 9th, 2006

Single Worksheet Templates

I’m sure you’ve used templates in MS Excel that were entire workbooks, but have you ever wanted just a single sheet for a template?

You know, instead of opening a workbook template, just insert a sheet into another workbook?

Sounds like a good idea to me! After all, I’m willing to bet that someone out there uses a template to copy and paste a single sheet into… Continue reading

File Open With Startup

Thursday, March 9th, 2006

File Open With Startup

Do you have a workbook that must be opened first thing everyday when you start up MS Excel?

Wouldn’t it be nice if Excel would simply open that file for you when you first start the program?

If you’re thinking that this would save you time each day, then maybe this is the tip you’ve been waiting for.

There’s no special setting in Excel and nothing… Continue reading

Printing the Grid

Thursday, March 9th, 2006

Printing the Grid

While going along the same lines as yesterday’s MS Office tip pertaining to displaying gridlines, I think it might be a good idea to discuss printing gridlines.

I mean, it seems inevitable. Whatever your system is trying to print (gridlines or no gridlines), you’ll want to do the exact opposite.

The question is where are the controls to these things? You just have to know that cell… Continue reading

The Clean Sheet

Thursday, March 9th, 2006

The Clean Sheet

Are there times when you find MS Excel’s gridlines more distracting than helpful?

Wish there was a way to get rid of them and to view a clean worksheet?

If you answered yes, then I’ve got the information you’re looking for.

Gridlines in MS Excel are controlled through the Options window (Tools menu, Options choice).

Once in the Options window, you’re looking for the View tab.

Taking Control of Cursor Movement in Word

While we’re still with yesterday’s thoughts of moving through files using the keyboard with some control and speed, I’d like to switch gears a bit and move over to MS Word. It’s in Word that we find today’s key combinations for cursor movements within a file.

Besides the usual arrow keys to move one space / line in the appropriate direction and the… Continue reading

One Screen at a Time

Friday, March 3rd, 2006

One Screen at a Time

Tired of scroll bars and scroll wheels? Looking for a quick way to move through an MS Excel worksheet without the mouse? Maybe something a little quicker than the “one row or column at a time” method the arrow keys have to offer?

Well then, we’re all in luck, because that’s just what I have to offer today.

Many of you know that the Page

Open to Delete?

Friday, March 3rd, 2006

Open to Delete?

What?

I don’t get it. Open to delete?

Yeah, sounds crazy, but it’s true.

If you’re in an MS Office Suite program and want to delete a file, you could go out of the program, navigate the hard drive and delete the file.

Or, you could do it right from within the program you were working in to begin with.

Now, assuming you’re on board with the… 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: