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

Pictures in Excel Chart Elements

Wednesday, August 5th, 2009

So, when you’re working with charts in MS Excel are you looking for a way to make your audience take notice?

I’d bet that by now you’ve tried just about every color combination you can think of to give your creation a look that grabs attention.

If this is you and you’re looking for yet another way to make those charts “pop” in the… Continue reading

Select Just Text in an Excel Worksheet

Tuesday, July 28th, 2009

Ever wish for an easy way to select just the text in your MS Excel worksheet?

Let’s say, maybe you need to change the formatting of all of it, but only the text and none of the data.

Or, maybe you are looking to select only the data, so you can delete it all at once.

Whatever your need, you are… Continue reading

Tweak Excel Templates

Thursday, July 23rd, 2009

The other day we looked at customizing and saving templates in MS Word. I’m sure that by now there’s a few of you out there who are wondering what can be done in Excel.

In fact, I’d even bet that some of you have gone looking through your Template window looking for the Create New Template option. Too bad it didn’t work out, huh?… Continue reading

Clear Recently Used Files in MS Office

Tuesday, July 21st, 2009

So, we all know about the recently used file list found on the File menu / Office Button in the MS Office Suite programs.

It’s automatically there and I know that I personally use it a lot. But what if someone else is going to use the computer and you don’t want them to see the list… for whatever reason you may have.

The… Continue reading

Find Merged Cells in Excel

Monday, July 13th, 2009

I don’t know about you but when I’m using MS Excel I’m always merging cells to make everything look “just right”.

The problem is that once cells are formatted that way there are a lot of things you may try to do with your worksheet that will not work with cells merged.

So, now what?

Well, I usually find myself separating… Continue reading

Duplicates in Excel 2007

Tuesday, June 30th, 2009

Have a lot of Excel data with a possibility of unwanted duplicates?

Looking for a quick way to locate the duplicates? (Maybe a way that doesn’t involve sorting the data differently – after all sometimes we just need the information ordered the way it is. Or the worse yet, the scenario where you spend endless time searching through each one hoping to catch all of them.)

Are you using Excel… Continue reading

Analyzing Filtered Data With Charts

Tuesday, June 23rd, 2009

So, you like to use MS Excel’s AutoFilter to take a look at your data?

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 data has to show you.

But, did you know that the single chart you created can be used over… Continue reading

Recent Text in Excel

Monday, June 22nd, 2009

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 of departments and… Continue reading

Excel Has Equal Sign Issues?

Friday, June 19th, 2009

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 a cell with just an = with no problems but the moment I added any text… Continue reading

Subscripts in Excel

Thursday, June 18th, 2009

You bet!

As with everything else, it’s just a matter of knowing what you have and where to find it.

So, let’s assume that you’re trying to put something like this…

…into an Excel worksheet.

You click into a cell and type H2O… then it starts.

What “it” do I refer to?

Why the wasted time you spend searching for a way to make just the 2 a subscript… Continue reading

Formatting Choices When Moving to Excel

Tuesday, June 16th, 2009

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 to appear where you can decide to have the information keep its original formatting or have Excel reformat it to match the rest of the worksheet.

But, what if you don’t want to… Continue reading

Styles for Cells Part 2

Thursday, May 28th, 2009

So, yesterday we took a look at Cell Styles in Excel 2007. There’s a lot to choose from on the styles palette, but what if none of them suit your exact needs or just aren’t to your liking.

And… for those of you using older versions of Excel don’t go away. There’s something here for you too! There’s no palette of predefined cell formats in these older versions but you… Continue reading

Styles for Cells Part 1

Wednesday, May 27th, 2009

Today I’d like to take a moment to address a reader’s question.

In particular he’s recently upgraded to Excel 2007 and has noticed this on the Home tab of the Ribbon:

So the question is, what are they?

It’s a good question to ask so let’s take a moment to answer it.

First, if you click the down arrow next to the ones you see you’ll find that an… Continue reading

Coding Headers & Footers

Friday, May 22nd, 2009

Often in Excel we’re looking to create headers and footers with data information in them. Things like page numbers, file names, dates, times, etc…

Anyway, while we’re creating our headers and footers there’s always some place where we can choose to insert this stuff, but wouldn’t it be faster if we just knew a couple of characters to do the same job?

Yeah – I thought so too.

With that… Continue reading

Ctrl + End in Excel

Monday, May 18th, 2009

As I’m sure most of you know, when working in MS Excel, Ctrl + Home will take you to the upper left corner of your worksheet (cell A1).

Do you know where Ctrl + End will land you?

Let’s all hope it’s not in the bottom most corner of a worksheet! Have you ever scrolled out right or down to find out just how big Excel makes its worksheets?

Well… Continue reading

One Click Cell Addresses

Tuesday, May 12th, 2009

Did you know that there’s a faster way to enter cell references in Excel formulae? I’m talking about a way that doesn’t involve typing cell addresses. Did you know?!

Interested? (Yeah, I thought you might be!)

Here’s the scoop.

Next time you’re entering a formula and you get to a cell reference (like A5, for example), instead of typing A5, use your mouse and click on A5.

Some of you… Continue reading

From Excel to Text box or Autoshape

Friday, May 1st, 2009

Ever find yourself either retyping or copying and pasting information from an Excel worksheet into a text box or an AutoShape?

Maybe you need that data stated in a bold way, so it’s been put into a text box or an AutoShape to grab everyone’s attention.

Good idea.

Of course, I’ve got to ask. What happens when the data changes?

Do you then go back into the AutoShape or text… Continue reading

Cell Range Characters in Excel Explained

Thursday, April 23rd, 2009

Do you find that referring to cell ranges in Excel formulas is a difficult task? Confused by the use of the colons, commas and spaces?

These characters are definitely a part of formula writing and if they aren’t used correctly, you’ll probably run into some problems.

So, here’s the information that can make formula writing with ranges a much more manageable task.

  • A colon ( : ) names a

Formulas Instead of Values in Excel 2007

Monday, April 20th, 2009

I’m sure that many of my Excel users know how valuable it can be at times to see formulas in your worksheet instead of their calculated values.

I mean, sometimes you just need to verify that everything is calculated the way you need it and often the easiest way to accomplish the task is to double-check the formula.

So… it stands to reason that Excel would include a way to… Continue reading

Workbooks and Worksheets in Excel

Monday, April 20th, 2009

Frequently I get this question from readers who are pretty new to MS Excel, so I thought I would explain it to you all now.

Q: I hear the terms “workbook” and “worksheet” used frequently when people discuss MS Excel. What exactly is a workbook? A worksheet? Is there a difference?

A: Well, to begin with, there is definitely a difference.

– A workbook is the MS Excel file in… Continue reading

Save as File Type in Office 2007

Thursday, April 16th, 2009

Working with Office 2007?

Everyone you share files with need them saved for an older version?

Maybe you have 07 at work and some other version at home…

Whatever the situation how many times do you find yourself saving a new file in an Office 2007 program as an Office 2007 file when it should have been in the 97-2003 file format?

Now what?

Oh yeah, go back and save… Continue reading

Excel Comment Color Coding

Wednesday, April 15th, 2009

If you use comments in MS Excel then you might find yourself wishing that there was a way to color code them.

Maybe some comments are notes you’ve made to yourself about double checking a formula, maybe others pertain to something entirely different.

Whatever your needs it might interest you to know that you can change the color of your comments with just a couple a clicks.

Once you’ve located… Continue reading

Spell Check in Excel

Tuesday, April 14th, 2009

Yeah, I know. Excel is primarily for numeric data , but let’s face it, we tend to use a lot of words in our Excel worksheets. Given all those words, it’s only reasonable to find that typos and misspelled words are occurring in Excel too.

So, it makes sense to me to understand (not just assume) what cells the spell check feature is actually checking. Did you know that what… Continue reading

Going to the Edge

Monday, April 6th, 2009

Are you an Excel user who often works with huge ranges of data?

It’s sort of annoying when you’re trying to move from one end of the range to the other, isn’t it?

You can scroll for what feels like an eternity (and then probably pass the end of the data up anyway) or hit the Page Up / Down key about a million times. But no matter what, it’s… Continue reading

Autocorrect in MS Office

Monday, April 6th, 2009

Have you ever found yourself frustrated with the AutoCorrect feature found in the MS Office suite programs?

Yeah, I’m sure you have.

Most of the time, they’re helpful little changes in spelling or things like capitalization and we’re thankful to have the program looking out for us.

But, what about the times when AutoCorrect is making changes that we really don’t want or need?

Sometimes it’s enough to make a… Continue reading

Changing Shapes in MS Office

Thursday, April 2nd, 2009

Have you ever drawn a shape in an MS Office program only to find that you’ve changed you mind and want something different?

What did you do?

Most people I know would choose to start over… makes you want to just keep the original one, even if it’s not your first choice anymore, doesn’t it?

Well, today I’d like us to take a look how to change the shape without… Continue reading

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

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