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 Excel’ Category



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.

Yes?

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

Find It Where?

Wednesday, July 16th, 2008

Find It Where?

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 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 function as usual (Edit menu… Continue reading

Paste an Exact Match

Tuesday, July 1st, 2008

Paste an Exact Match

Do you often use the same formula in multiple places in your MS Excel worksheets? I’m talking about the exact same formula. You know, no cell reference changes on the paste.

If so, have you ever tried to copy that formula from one cell to another?

Yeah, I know, all the cell references change in the pasted version relative to its new location. Not what you… Continue reading

See Titles and Totals Simultaneously

Tuesday, June 24th, 2008

See Titles and Totals Simultaneously

If you frequently work with large amounts of data in MS Excel you may find yourself frustrated as you try to see both the column titles (at the top) and the column totals (at the bottom) at the same time.

You have probably tried to freeze the titles and then split the screen, thinking you could keep the totals in view in the bottom half… Continue reading

Keep Your Formatting

Friday, June 6th, 2008

Keep Your Formatting

Did you try yesterday’s Paste Special trick in MS Excel? If so, did you find that the formatting of the cells, where the paste occurred, was gone?

If you did, I’m sure you’d like a way to prevent that transformation while the Paste Special does its thing, right?

Assuming that’s the case, I’m here to show you a small change you can easily accomplish while making your… Continue reading

Multiply Many At Once

Thursday, June 5th, 2008

Multiply Many At Once

When you’re working in MS Excel, do you ever have the need to multiply, add, subtract or divide several cells by the same value?

If so, please tell me you didn’t go through and make all of those changes individually!

Well, I hope not, because that can be very time consuming and Excel offers a much more efficient method that is available right within the Paste… Continue reading

Same Information, Many Cells

Thursday, May 22nd, 2008

Same Information, Many Cells

Have you ever had the same information to enter in multiple cells in MS Excel?

What did you do?

Did you type the data into one cell and then copy and paste it everywhere else in the worksheet?

That was a bit of a pain, wasn’t it?

How would you like a way to get the data into all of those cells simultaneously? You know, a… Continue reading

Just the Comment and Nothing But the Comment

Have a lot of comments in your MS Excel files?

Ever find yourself entering duplicate comments as you work your way through a file?

Tired of all the repetitive typing?

If so, how would you like a way to copy and paste just the comment?

No problem!

The next time you need a comment from a cell, and nothing else, just follow… Continue reading

Tell Excel to Leave You Alone!

Thursday, April 10th, 2008

Tell Excel to Leave You Alone!

Yesterday’s topic of formulas linked one workbook to another and as you may recall, in the end, MS Excel kept asking if you wanted to update the information. That’s not necessarily a bad thing, but if you control both workbooks and you know there’s no security problem, it can get somewhat annoying.

So, you must be asking, “Can I get Excel to stop asking… Continue reading

When a Name Box Isn’t a Name Box

Tuesday, April 1st, 2008

When a Name Box Isn’t a Name Box

Did you know that MS Excel’s Name box isn’t always the Name box (the box to the left of the Formula bar?)

I know it sounds crazy, but it’s true!

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

Did you see what happened?

A Function box replaces the

Sum It Up With Two Keys

Thursday, March 20th, 2008

Sum It Up With Two Keys

I’m sure many of you are familiar with the AutoSum button in MS Excel, right?

It’s a handy little feature that, with a single click, inserts the formula for the sum of a column of data located just above whatever cell you currently have selected.

Now, those of you who prefer to use the keyboard for everything may be wondering if there’s an… 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: