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



Most Excel users know that if you have data in a cell you can use the fill handle to increase the selected cell range down a column or across a row. Well, what if that range is more than one? April explores. Continue reading

With the release of Excel 2010 we have another quick, easy-to-use and powerful tool to take a graphic look at the trend found in a set of data… Sparklines. Continue reading

By now we’ve all found the Format as Table button on the Home tab of the Ribbon will take a range of selected cells in turn them into an easily and beautifully formatted table, but did you know there’s an easier way? Continue reading

MS Excel: Insert and Paste In One Step

Wednesday, May 25th, 2011

Here’s a super-helpful MS Excel tip that will teach you the painless way to insert and paste rows and columns. Continue reading

I’m sure you’ve noticed by now the Error button that pops up whenever Excel’s Error Checking feature thinks that there may be something wrong with a cell’s contents. Well, what if there are no errors? Continue reading

Unfortunately it happens way too often – we receive a worksheet containing numbers but the cells were formatted as text.
Too bad we need them as numbers! Thankfully, there’s a quick and easy solution! Continue reading

Ever found yourself staring at a column of data trying desperately to figure out how you’re going to peel out the portion of the data in each cell that you actually need? With the right formula anything is possible! Check it out! Continue reading

Be default, when we tell Excel to print we end up with whatever worksheet is currently selected spitting out of the printer.

Usually that’s great since it’s exactly what we want most of the time… but what about the other times?
You know, when you wanted the entire workbook or even multiple worksheets, but not all of them?

Learn how to remedy this problem by reading this tip! Continue reading

MS Excel: A Locked Cell is Not a Cell Protected From Changes

If you’ve ever found yourself nosing around the Protection tab in the Format Cells dialog box then you’ve probably found that the Locked check-box was selected and possibly thought that your worksheet was safe from changes made by others…

Some people have one central location where they open Office files from on a regular basis… but others have several locations, and it’s a bit of a pain to constantly navigate from one location to another.

The more files you open, the bigger that pain becomes until it’s an all out headache.

You’ve got to be

There are certain things that we’d all like to have when we begin a new Excel workbook… such as number of worksheets, font, font size, etc…

For many people, this seems like an elusive process, since there are so many places to investigate looking for the old Default button.

Fortunately for all of us, a few

Finding Tabs in Spreadsheets

Friday, March 18th, 2011

Richard from San Antonio asks:

I create a large number of tabs in Excel 2007 spreadsheets, each with a distinct title. Is there a way to search for a specific tab within the spreadsheet? Some of the spreadsheets might have 100 or more tabs.

Thanks for the question

MS Word: Using a Spreadsheet Within a Document

On more than one occasion, I’ve found that within a document I’ve needed to present data that really should be set up in Excel.

Don’t get me wrong, Word’s tables are great, but when it comes to calculations and numeric data displays, Excel wins hands down.

Paste with the Enter Key in Excel

Thursday, March 17th, 2011

If you’re anything like me, you believe that there’s only one option when using the keyboard to paste in MS Excel – Ctrl+V.

While that obviously will paste your copied or cut information as it always has, you do have another option if you’re only looking to paste in one location.

Do you work with a lot of Google Docs documents? Do you have spreadsheets, Word documents, PDF reports, PowerPoint presentations stored in your Google Docs account, and are looking for an easier way to create or manage these documents from Microsoft Office desktop UI?

There are tons of desktop apps available for managing Google Docs documents, but recently Google has released an official add-in which

MS Excel: Format Cells Dialog Box

Thursday, March 10th, 2011

MS Excel: Finding a Long Lost Friend… the Format Cells Dialog Box

Let’s be honest, there are times when faced with the Ribbon and all its tabs, groups and buttons, that we miss our old friend the Format Cells dialog box.

It was our “one-stop”

Pictures and Shapes in MS Office

Thursday, March 3rd, 2011

MS Office: A Picture of a Different Shape

Today I want to point out a very simple and quick way to change the way pictures and graphics are displayed in your documents, presentations, worksheets, etc…

We’re going to take a look at how the fill of a shape can really make a difference in

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.

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

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: