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

WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Archive for the ‘MS Excel’ Category

Read Only Done the Quick Way

Tuesday, March 31st, 2009

Remember all the hassle it was to make a file Read-only in MS Office Word, Excel and PowerPoint versions prior to 2007?

You had to save and close the file, locate it through Windows, right-click on it and then you could finally select the Read-only checkbox.

Whew! That’s a lot of steps and a bit of a pain.

Well, if you’re using a 2007 version then today you’re in luck.… Continue reading

Two in One

Tuesday, March 17th, 2009

Ever find yourself faced with multiple sets of data in MS Excel?

Did you decide that you wanted them charted together and yet with different types of data representation?

For example, maybe you’d like to see one set of data in a line graph and the other with bars?

If this is your preference then you might be happily surprised to find that you can accomplish this goal – to… Continue reading

Paste It Here and Here and Here?

Friday, February 27th, 2009

Paste It Here and Here and Here?

When you’re working in MS Excel, do you sometimes find yourself needing to paste the same information into many non-adjacent cells?

Now, I’m sure many of you know you can highlight multiple cells, enter something into one of them and then use Ctrl + Enter to put the same information simultaneously into all of the highlighted cells. Right?

That’s a great trick, but… Continue reading

Quick Data on the Selected Data Range

Monday, February 16th, 2009

Quick Data on the Selected Data Range

Do you ever find that you need a quick piece of information? You know, a sum, average or a minimum or maximum value on a range of MS Excel data.

What did you do?

Did you write a formula in a cell?

Well, if you want to keep the information in the worksheet, that’s an excellent plan. But what if all you need… Continue reading

Excel Cells to Word with Usable Results

Tuesday, February 10th, 2009

Excel Cells to Word with Usable Results

Have you ever tried to copy and paste cells from MS Excel to MS Word?

What happened?

I bet you went to Excel, highlighted the cells, copied the cells, went to Word, pasted the cells and poof, there they were!

Sounds great, doesn’t it?

Yes, and it can be, but if you’re using Word and Excel 97, there are some slight problems.

You… Continue reading

And the Total Is…

Tuesday, December 30th, 2008

And the Total Is…

Have a table in MS Excel 2007? Do you need to calculate information, such as an average or sum for each column in the table?

If so, what did you do?

Did you set up the row by hand and then create the needed formula? Then did you have to fill the formula in across your whole row?

What if you could get Excel to add… Continue reading

Sizing It Up

Tuesday, December 16th, 2008

Sizing It Up

Okay, so I have just one more tidbit to add to our ever growing knowledge about MS Excel 2007’s tables. (I really, really like them, can’t you tell?!)

Today, let’s talk about changing the size of an established table, without using the AutoExpansion feature.

Besides, what if you want your table to be smaller?

Expansion really wouldn’t work in those cases.

So, to resize your Excel 2007… Continue reading

Include This Too? Maybe Not!

Tuesday, December 16th, 2008

Include This Too? Maybe Not!

So, have you taken some time to work with the tables found in MS Excel 2007 after last week’s tips?

If so, I’m sure you’ve noticed how they seem to have a whole set of behaviors you may not have expected.

After all, we see the table as a set of formatted cells, not as an object that will behave differently than the regular cells… Continue reading

Table Formatting Without the Table Behavior

Thursday, December 11th, 2008

Table Formatting Without the Table Behavior

I bet a few of you who have been working with the MS Excel 2007 tables the last couple of days have found yourselves wishing you could easily get the right formatting, without all the table behaviors that come with it.

If you’ve been searching for a way to get the formatting without actually creating the table, here’s exactly what you need!

To begin… Continue reading

Oh, You Didn’t Want the Table Column Full of Formulas?

If you worked through yesterday’s tip about MS Excel 2007 tables, you know that entering a formula into a single cell will cause Excel to fill the table’s entire column with the formula.

It’s handy if that’s what you intended, but what if it’s not what you want?

Is there a way to undo Excel’s automatic column fill?

You bet!… Continue reading

One Formula for the Whole Table Column

Tuesday, December 9th, 2008

One Formula for the Whole Table Column

Do you use MS Excel 2007’s table formatting options?

You know, the great looking and convenient formats found on the Format as Table button under the Home tab on the ribbon.

Well, here’s a real time saver I just happened to stumble across as I was exploring Office 2007!

When I have a range

The Larger View

Monday, December 8th, 2008

The Larger View

Do you often work with MS Excel 2007?

Ever wish for a quick way to enlarge an area of your worksheet so that you can see the details a little closer?

While I know you’ve all found that Ctrl + scrolling the mouse wheel will do the trick quickly, you probably also found that you can easily go right by the zoom you needed.

I’m also sure… Continue reading

Copied From Above

Monday, November 17th, 2008

Copied From Above

Here’s a super quick copy trick for MS Excel!

Have you ever needed an exact copy of a cell’s contents?

And I do mean exact. Even cell references won’t be changed in your formulas.

Well, here’s the trick: simply select the cell directly below the item to be copied and use the Ctrl + ‘ (Ctrl + apostrophe) key combination.

Yep, that’s all there is to it!… Continue reading

Breaking Up Isn’t So Hard to Do

Wednesday, November 12th, 2008

Breaking Up Isn’t So Hard to Do

If you tried the tip from the other day, where you imported data from the Web into Excel 2007, you may have found that not all data appearing to be a table is actually a table. Am I right?

I found that many things I imported were actually just text, so it came into Excel in a single column.

So, now what?

I… Continue reading

Hassle Free Web Data in Excel 2007

Sunday, November 9th, 2008

Hassle Free Web Data in Excel 2007

So, you have data on a Web page and you need to move it into an MS Excel worksheet.

What are you planning to do?

Copy/paste each piece of data? Re-enter the data?

Well, I vote you import the data directly from the Web and avoid all the transfer time.

If you’re on board with that idea, let’s take a look!

The Long Formula

Thursday, October 30th, 2008

The Long Formula

Do you work in MS Excel a lot?

Ever have a really long formula that would expand the formula bar in the older versions of Excel? Did it become bothersome when it began to cover the cells in the first few rows?

Well, if that’s the case for you and you now use Excel 2007, you may be happy to know that you have some other options… Continue reading

Special Data Formatting: The Easy Way

Monday, October 20th, 2008

Special Data Formatting: The Easy Way

Do you enter a lot of special data into MS Excel, such as zip codes, phone numbers or social security numbers?

Ever find yourself wishing the parenthesis and/or dashes would just fill themselves into the correct locations? I mean, wouldn’t it be faster if you could just key 5551234567 in for a phone number and have (555) 123-4567 appear in the cell after you… Continue reading

Page Layout View for Excel?

Thursday, October 2nd, 2008

Page Layout View for Excel?

Yep, you read that right! If you’re using Excel 2007, you’ll find that it also has a page layout view.

Just like the view you’ve used in MS Word for years, you can now choose to view your worksheet in pages, complete with headers, page breaks, rulers and all.

Take a look:

As you can see

Get the Info Quick

Wednesday, October 1st, 2008

Get the Info Quick

Do you use the Research feature found under the Review tab on the ribbon in MS Word 2007? You know, the handy function that provides a definition, translation and thesaurus information all in one concise location.


How do you access it?

Do you go to the Review tab, click on the Research button and then enter a word or phrase into the Research pane?… Continue reading

The Case of the Missing Labels

Wednesday, September 17th, 2008

The Case of the Missing Labels

Have you used MS Excel 2007 to make a chart lately?

Did you feel like you missed a step or something?

I mean, you highlighted your data, used the Insert tab on the ribbon to select a chart type and poof! A chart appeared in your worksheet.

Sounds nice and fast, but wait just a minute. What about all the details the older versions… Continue reading

Painting by the Rows?

Tuesday, September 16th, 2008

Painting by the Rows?

Or, if you please, by the columns!

I don’t know about you, but I just love the MS Office Format Painter button.

That amazing little feature can quickly transfer formatting aspects to other locations in your file, without changing the actual text or data. Marvelous!

Much to my amazement, despite the frequency of which I use the

Page Setup in Excel 2007

Monday, August 25th, 2008

Page Setup in Excel 2007

Are you using Excel 2007?

Having trouble locating the Page Setup options you frequently use?

I’m sure by now you’ve found many things under the Page Layout tab on the ribbon.

You’ve probably noticed that a lot of the options are there as separate buttons, allowing you to quickly set one aspect, without the need for the old Page Setup dialogue window.

That can be… Continue reading

Excel Sorting: The Basics

Friday, August 8th, 2008

Excel Sorting: The Basics

In MS Excel, you often have a database of information that needs to be ordered in a certain way (whether it’s alphabetical, by date or whatever).

The first step to sorting data is to tell Excel what database it’s going to be sorting. To accomplish that, select a cell in the database.

If you’re sorting only one field, you can use the Sort Ascending and Sort

One More Filter Discussion: For Excel 2007

As you can see, I’m not quite done with the AutoFilter discussion for MS Excel 2007! For those of you who have been working with it, you have probably noticed that your filter down arrow gave you several more choices than the older versions ever showed.

So, as a result, I thought you might be up for a quick exploration of those extra… Continue reading

Print Some or Print All

Wednesday, July 30th, 2008

Print Some or Print All

Today’s tip comes from a reader who wanted to know how to print an entire MS Excel workbook all at once.

That’s a good question. After all, it’s a royal pain to print each worksheet individually.

So, how exactly can you print an entire workbook at one time?

The answer takes you back to the Print dialogue window (Ctrl + P).

Once again, you’re looking… Continue reading

I Need a Little Help Here!

Wednesday, July 23rd, 2008

I Need a Little Help Here!

I don’t know about you, but I sometimes find myself guessing what arguments are needed in an MS Excel function.

If it’s something I haven’t used in awhile, I may not be able to come up with the exact components that actually go into the parenthesis.

At that point, I stop everything and go in search of the Function Wizard. With that, I’m able… Continue reading

Temporarily Ignore the Print Area

Tuesday, July 22nd, 2008

Do you set print areas in MS Excel to quickly print the cells that are only needed time and time again?

Ever have times when you want to print a different range of cells, without resetting the print area?

Yes? Then you need to give this a try!

First, highlight the cells you want to print.… 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.


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive