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



Preventing File Overwrite in MS Office

Thursday, February 24th, 2011

We’ve all done it at one time or another… you need to create a new file that’s pretty much identical to another one, so you open the file that you have, make the changes and then save it.

In that very, very short time while you watch the file being saved you are struck speechless with the horrible realization that you just made a

When setting up a worksheet where we need to separate one section of information from another, and present that separation clearly, we often use cell borders to accomplish the job.

Obviously that option is a great way to get the job done, but we tend to use those for everything… so making that visual break between data sections requires a bit of finesse with those borders.

Copy and Paste Only a Cell Comment in MS Excel

Thursday, February 17th, 2011

MS Excel: Copy / Paste Only a Cell Comment

When reviewing the contents of a worksheet, do you find that you’ve got the same comment to make over and over again? (The least of which being “Where the heck did that come from?”)

I know that when I go through and start getting into

How much time have you spent customizing the Quick Access Toolbar in your MS Office 2007 programs?

If you’re anything like me then it’s quite a lot…

When you move to a new computer – or maybe decide that you want the one at home to match the one at work – what do you do?

If you’ve recently given up your Microsoft Office 2003 for the “latest, greatest” version, Office 2010, you may be a bit disoriented.

You’ve heard the hype about the new Ribbon User Interface but now you’re faced with actually having to use it…

If it’s not something you’re taking to easily or just feel like you need more guidance, I have a suggestion or two

Creating Macros in MS Excel

Wednesday, February 9th, 2011

Microsoft Excel is the one of the most popular spreadsheet programs used worldwide. It has a variety of features such as data storage, creating reports and charts, using mathematical functions, performing statistical analysis, ability to connect to databases, making use of pivot tables, V-lookups etc. One such very useful feature within Microsoft Excel is the ability to make use of “macros”.

What is a Macro?

The other day we talked about a method to copy and paste the OFFICEUI files (which contain all the custom User Interface information for one of the Office 2010 programs). It’s a good method, but it requires you to know where to look for the files.

It’s a great way to save your customizations, in case something happens to your system

Deleting Multiple Comments in Excel

Thursday, February 3rd, 2011

MS Excel: Delete Multiple Comments at Once

If you’ve got an Excel worksheet that contains a lot of comments, it can be a bit of a pain to remove them all when you’re done.

Think about it. If the worksheet is a large one and you’ve managed to accumulate quite a few comments, it’s

Increase the Number of Undos in PowerPoint

Tuesday, February 1st, 2011

Do you “undo” a lot in MS PowerPoint?

Ever run out of undo steps and wish for more?

If your response was yes, here’s what you need to know about PowerPoint to get a few (or a lot) more undo steps added to your list.

Use

When you open a file in one of your MS Office programs, do you find that you’re always navigating away from “My Documents” to some other folder?

Ever wish that it would just open up to that location in the first place?

If so, here’s the good news… you can set each program to go directly to whatever location you desire, when you

Applying Options in MS Office

Thursday, January 20th, 2011

When you’re in the Options dialog box for one of these newest MS Office programs, have you ever noticed this part of a section header? (You’ll notice that not all section headers have one…)

Even if you did notice it…did you take the time to investigate?

For many people the answers are no…

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

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: