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



Resetting the Default View in Excel

Tuesday, January 18th, 2011

MS Excel 2007 & 2010: How Do You Like to View It?

We all have one… you
know, that preferred view of our MS Excel worksheets.

Some people like to see
everything in the Normal view.

Others prefer the Page
Layout view, where Excel shows the physical breaks between each page, as well
as the… Continue reading

Shrink to Fit in Excel

Friday, January 14th, 2011

MS Excel: Data Too Long
for the Cell? Use Shrink to Fit & Let Excel Fix the Problem for You!

Ever have data in MS Excel that’s just a bit too long for the cell?

What happened?

Did the column widen to accommodate? Or, maybe you got the infamous

Using the Clipboard in MS Office

Tuesday, January 11th, 2011

MS Office 2007 & 2010: I Thought That the Clipboard Could Hold More Than One Item?

You’re right – it can…
you were used to accessing something like this via the Edit menu in older
versions of MS Office:

A clipboard pane where all
the items that have been copied or cut, are stacked in a list… Continue reading

Add Information to Excel Formulas

Friday, January 7th, 2011

MS Excel: A Little Something
More to Say

Ever find yourself working
on an Excel formula and wondering how in the world the person you’re handing
this off to will ever understand some of the more complex calculations?

Short of writing lengthy
documentation, or spending a whole lot of time walking them through things piece
by piece, there… Continue reading

Disable the Zoom Slider in MS Office

Thursday, January 6th, 2011

So, here’s the scenario… you’re happily working in one of the newest versions of an MS Office program and things are progressing nicely.

Then suddenly it happens – the program window goes “wacky” and you find yourself looking at the file after a zoom in or zoom out.

What happened there?

To be quite

Let MS Office Find Templates for You

Thursday, December 30th, 2010

MS Office 2007 & 2010: Let the Program Bring the Templates to You

At one time or another, we’ve all found ourselves searching online for just the right template to do the job we need.

Even using the Microsoft templates site, which is quite organized and easy to use, can be tedious and frustrating, as you try search after search after search.… Continue reading

Finding Recent Files in MS Office 2010

Tuesday, December 28th, 2010

I can’t speak for everyone but I love to the recent files list… I mean what’s not to love?

You can bypass the whole Open dialog box and the sometimes complicated navigation, to actually pull up any recent file just by looking in one place.

If you’ve investigated in Office 2010 then, you know that the recent files list is found under… Continue reading

MS Office: Think Twice, Cut Once

Tuesday, December 21st, 2010

Undo – Redo – Undo – Redo… I don’t know about you, but I find that I tend to use that cycle of events a lot when I’m putting finishing touches on things… especially on one of my “picky” days when everything has to be perfect.

Anyway, it’s a great feature, and I’m sure that I’m not the only one using it.

However, did… Continue reading

How to Use the Ribbon in MS Office

Friday, December 17th, 2010

If you made the transition to the Ribbon User Interface when Office 2007 was released, the upgrade to Office 2010 really wasn’t a big deal for you.

There are changes, but not in a way that gives you that “I’m lost” feeling so many people felt with their beginning efforts in Office 2007.

But, if you’re one of the many who didn’t use Office… Continue reading

Selective Formatting in Excel

Thursday, December 16th, 2010

Ever find that you need the column width from one column transferred to others without all the data and other formatting?

Maybe the width you need is in a column formatted as bolded text and, while the width needs to be transferred, the rest doesn’t. In a case such as this the old Format Painter won’t help as much as we’d like it to, since it transfers… Continue reading

OK, so all of the MS Office 2007 & 2010 users have come to deal with the fact that the menu & toolbar system is gone and in its place we have the Ribbon.

It’s a rather large “gadget” and takes quite a bit of screen space.

Many have learned to live with it “as is” but others have learned to minimize it.… Continue reading

Tweaking Templates in MS Office

Friday, December 3rd, 2010

Many of us have a template or two that we use all the time.

Of course, the first thing we do upon opening the template is to make a few changes to the layout or text.

We make those changes again, and again, and again, and again…

Well, you get the idea…

With the endless work of changing… Continue reading

MS Office: AutoRecover Unsaved Documents

Wednesday, November 24th, 2010

The other day, we discussed the AutoRecover feature of the 2007 & 2010 Office Suite of programs and the advantages of a backup system for unexpected and unstoppable closures of a program.

Well, for those of you with Word, Excel or PowerPoint 2010 I’d like to extend that discussion to a feature that I consider to be a bonus of AutoRecover… … Continue reading

AutoRecover in MS Office

Tuesday, November 23rd, 2010

The power goes out…

The program stops responding…

You entire system crashes…

Whatever the cause, you just had the program close unexpectedly and your work is gone… gone… gone…

Or maybe not.

If you’ve got the AutoRecover feature active, then you might be in for a pleasant surprise!

With the AutoRecover feature… Continue reading

Finding Merged Cells in Excel

Tuesday, November 16th, 2010

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

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

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

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

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: