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 Office Help’ Category

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

The Difference Between PDF and XPS

Friday, September 24th, 2010

Previously we’ve discussed the ability possessed by MS Office to save files in PDF format and at some time you probably also noticed that the file format XPS seems to be lumped with the PDF choice.

Most of us are very familiar with PDF since so much that we see online is in that format. Forms such as tax forms from the state… Continue reading

Change Default Save in MS Office

Thursday, September 23rd, 2010

If, for whatever reason, you’re using the MS Office 2007 or 2010 programs and always need to save files in a format different from the default then I’d bet that you’re tired of forgetting to make that change.

I don’t know about you, but I just enter a file name and hit the enter key… changing the file type is the last thing I think of.… Continue reading

A Quick Way to Find Information in MS Office

Tuesday, September 21st, 2010

When you’re going into the program options for the newest MS Office programs you might feel a bit overwhelmed.

There’s lots and lots going on in those dialog boxes… categories such as proofing, advanced, save, etc… and then within each of those there are sections of options such as editing, display, print… and if that were not enough there are options in there program specific.… Continue reading

Quick File Conversions in MS Office

Friday, September 17th, 2010

We all know that the newest version of Microsoft Office programs has a lot of really cool features.

We also know that many of these features just don’t work with older file formats.

I can’t speak for you, but I have a lot of files that were created with Office 2002 and I’m not about to start over just to access the new cool… Continue reading

Search Options in MS Outlook 2010

Thursday, September 16th, 2010

MS Outlook 2010: Where Did the Search Options Go?

So, if you’ve used the search box in Outlook 2007 to locate messages then you probably used the down chevron to open up a more detailed set of options for your search. Click here to view a tip on using the search feature from Outlook 2007.

If you’ve switched to Outlook… Continue reading

Using the Delete Key in OpenOffice Calc

Wednesday, September 15th, 2010

Have you tried the Delete key when using OpenOffice Calc?

What happened?

Well, that depends upon where you were…

As in, were you in a cell or the formula bar editing content or did you have an entire cell(s) selected?

If you’ve got your cursor in the cell data (or the formula bar) editing the information then the… Continue reading

Free PDF Document Conversion

Wednesday, September 15th, 2010

Did you know that you can convert .PDF documents to Word documents for free on the web?

If you have access to the Internet, rather than a program, I can recommend a website to you. This website is It’s entirely free and each time that you want to convert a PDF to Word, OpenOffice etc, you simply go on the site, upload the document, select… Continue reading

Viewing the Week Number in MS Outlook

Tuesday, September 14th, 2010

Sometimes it’s helpful, or even necessary, to know what number a particular week is in a year.

There are occasions where it’s helpful for reporting information, appointments, etc. Heck, I even find it helpful for keeping track of pay periods. Instead of counting Fridays on a calendar I simply need to know if I’m paid on odd or even week numbers (being paid bi-weekly). Trust me, the… Continue reading

Autoformatting with OpenOffice Calc

Monday, September 13th, 2010

Here at Worldstart, we’ve discussed autoformatting in MS Word, but did you know that it can also be done in OpenOffice Calc? Using the Autoformat feature, you can quickly enhance otherwise plain looking spreadsheets.

You start by selecting a group of cells.

Once you’ve selected the cells, go to the Format menu and choose Autoformat.

We’ve all seen and used the standard PowerPoint handouts.

Without a doubt they’re often helpful for the audience but let’s face it, there are times when you want to give your audience a bit more in a handout without actually adding that information to the slide.

Given that situation, you’ve got to wonder if there’s a… Continue reading

MS Excel: Coding Headers and Footers

Thursday, September 9th, 2010

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 –… Continue reading

We all know that you can change the font type and size if you don’t mind leaving the body of your document to go to a toolbar or menu… but you’ve got to wonder at times if there are other options.

And, while I’m sure there are many different ways to make these formatting changes today I’d like to talk about what you can do with a… Continue reading

MS Office 2010 Text Effects Transform Options

Tuesday, September 7th, 2010

On Monday we took a look at the new Text Effects button in Word 2010. It’s awesome and it definitely can make it easy to get that WordArt look with any text super quickly.

But what are we going to find when we actually do go to the Insert tab on the Ribbon and click the WordArt button?

It’s a good question so I… Continue reading

Text Wrapping In Open Office Calc

Friday, September 3rd, 2010

When we work in spreadsheets we end up using text as well as numbers. I know that we like spreadsheets for their easy organization and ability to do calculations but let’s face it… you’ve got to label the data. A spreadsheet filled with unlabeled numbers is pretty useless.

With that in mind, I’d like to talk about what we can do when our text is too long… Continue reading

MS Office 2010 Text Effects Button

Friday, September 3rd, 2010

I happened to be working in Word 2010 the other day and happened upon a new button in the Font group of the Home tab in the Ribbon.

It’s called the Text Effects button and when you use it you open a palette of choices like this:

If you take a look you should… Continue reading

AutoShape Rotation in MS Office

Thursday, September 2nd, 2010

Learn about how to manipulate MS Office AutoShapes using one simple control. Continue reading

Center Titles in Open Office Calc

Wednesday, September 1st, 2010

I see this all the time at school – students are forever giving me tables set up in spreadsheets where the table title is either left justified over the table columns or placed haphazardly “sort-of” in the center of the table. They just love to try to center titles by using a bunch of spaces or by putting the title in a cell that’s as close as they could get… Continue reading

If you’ve ever looked at a hard copy of a document and wondered “Now where did I save this?” then you want to know this one.

One of the most sure-fire ways to ensure that you know how you saved the file is to include the path (file location) and file name in the header or footer of the document.

Numbering Pages In Open Office

Monday, August 30th, 2010

Have you tried to put page numbers in your Writer documents yet?

Did you find it?

If not then I’d bet that you’d like to know where OpenOffice has placed them so let’s take a look at that today.

First, we usually want our page numbers in either a header or footer… so you can insert those through the Insert menu.

Now, with your cursor in the header or footer… Continue reading

Have you ever put together a PowerPoint presentation where it seems that the slides have way too much unused space on the left and right sides?
I know that when I put together presentations for teaching my students tax forms the slides begin to look like this:

In order to have the whole form from top to bottom… Continue reading

Microsoft Excel: To the Bottom Right Now!

Thursday, August 26th, 2010

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

Fontwork: Wordart for Open Office

Wednesday, August 25th, 2010

Those of you who have experience with Microsoft Office should recognize the term “WordArt”.

It was that handy little feature that allowed you to take any text and really turn it into a piece of art.

If you’re now switching to OpenOffice then you may have wondered a time or two if there is an equivalent feature available.

Of course there is… you just have to know what it’s called:… Continue reading

Office 2010 : Customizing The Ribbon

Tuesday, August 24th, 2010

Yep, you read that correctly… after all the pain of Office 2007 “Ribbon shock” and our inability to customize even the smallest amount of the Ribbon we’ve finally caught a break!

Microsoft has included in the 2010 Office Suite the ability to do some (and I emphasize “some”) customization of the Ribbon.

Now, I don’t even have to ask this time – I know… Continue reading

OpenOffice: It’s All About The Keys

Many people much prefer using key combinations over the mouse when completing their work.

Some just find that it takes way too much time to keep removing their hand from the keyboard to accomplish something with the mouse. Mostly I agree, it seems that 9 times out of 10

The other day we took a quick look at the difference between Office 2007 and Office 2010 when it comes to easily saving a file in PDF format.

Today I’d like to look at a way you may even like better – and this one works on both versions!

What we’re going to do is to look at

Save As PDF in MS Office 2010

Thursday, August 19th, 2010

Previously we’ve taken a look at how Office 2007 offers you the option of saving a file in PDF form. (Click here to view that article)

In that version of Office it was put right out there in front of your nose in the Save As choices for the Office Button.

But, if you’ve taken… 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