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

Resetting Bold for Unread Email in Outlook

Wednesday, February 23rd, 2011

Henry from Denton, MD asks:

Windows 7 Office 2007, Outlook 2007. Incoming new e-mails do not show up in bold before they are read. How can I reinstate the Bold?

Henry, by default, Outlook displays unread messages with a bold font. However, it appears that your default has changed. No problem. We’ll

Using the F2 Key in PowerPoint

Tuesday, February 22nd, 2011

MS PowerPoint: Who Knew That the F2 Key Has a Use Here Too?

As I’m sure you already know, the F2 key when used in MS Excel will put you into the editing mode for the contents of a selected cell.

It’s a really handy little tool, since you can navigate through the sheet

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?

Drop Caps in MS Word

Friday, February 11th, 2011

It’s called a Drop Cap and, while this may not be something that we would use every day, it is a quick and very easy way to add a little something extra to your documents, making it something that would be a good addition to our “Hey, I know how to do that” list.

Superscript and Subscript

Thursday, February 10th, 2011

Franklyn asks:

When writing email, there are times I would like to use a superscript (degree F) and subscript (H2O). Is there a way to have them available?

Franklyn, if you’re using Microsoft Word or Outlook 2007 or 2010, you can easily add either superscript…

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

If you’re a person who likes to use transition effects when moving your presentation from one slide to the next and favor consistency in your choice of transition, then you’ve probably found yourself looking at something like this, while you select a slide, apply the transition effect, move to the next slide, apply effect, move to the next slide… Continue reading

How to Stop Screen Shake

Friday, February 4th, 2011

Richard from Hudson, Florida asks:

I am using Microsoft Outlook 2003. Sometimes in checking my mail, a red flag would come up on the right side of a message and the page would shake. I tried to shut down Outlook and restart it, no help. I would even reboot and the red flags are still there. I

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

Text Rotation in MS Word

Tuesday, January 25th, 2011

MS Word: Moving In a New Direction



Ever find yourself looking to rotate text in MS Word?

Maybe you’re trying to make a flyer with phone number tabs across the bottom? Or, maybe you need to run some text down the side of a document and you don’t want

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…

Unclogging the Outlook Outbox

Wednesday, January 19th, 2011

Dale from OR asks:

I can receive email messages with no problem in Outlook, but all my outgoing email stays in my Outbox and won’t send. Can you help?

Despite possibly being the world’s most ubiquitous e-mail program, Microsoft’s Outlook e-mail client is not without its flaws. Now in its 14th iteration

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

Viewing Reminders in MS Outlook

Thursday, January 13th, 2011

If you use Outlook for appointments or reminders, I’m sure you’ve seen the Reminders Window on more than one occasion.

(Yes – mine is empty. Must mean that I’m all caught up, right? Yeah, right – I wish…)

Anyway, I know that I’m not the only one who has accidentally closed that thing before I meant to

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

Using Windows Snipping Tool with Word

Monday, January 10th, 2011

In Windows 7, when using the Snipping tool, (one of the greatest features of Win 7), I can copy the snippet OK and place it in MS Word, but I cannot place the object right or center nor can I text wrap around the object. Any ideas?



Back in the days before the introduction of Windows 7 and Vista, if you wanted to take a picture… 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

Creating an Email Desktop Shortcut

Friday, January 7th, 2011

Roger writes:
I have someone I e-mail a lot, and I get tired of opening and closing Outlook. Is there any way to e-mail someone without having to do that?
Hi, Roger!
If you want to e-mail a certain person quickly without opening and closing your e-mail client (such as Gmail or Outlook), there is one way you can do it, and that is by creating an e-mail shortcut for the person on your desktop. It’s easy; here’s how: Continue reading

Reducing the Size of Word Documents

Friday, January 7th, 2011

Thom, from Dallas asks:

Why do Word and Excel files get so large when the content is so small? As I make numerous changes and saves to a Word file, the file becomes bloated over time. If I open the large Word file and copy (Ctrl-C) and paste the content to a newly created word document, the file

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: