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



MS Word: Insert Text Boxes That Come With Their Own Pizzazz

I often find myself using text boxes in Word for a variety of reasons… often it’s something that needs to stand out from all the rest of the text, or needs to be very mobile… and let’s face it, moving plain text around is just a pain.

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

Here’s a tip that I recently found and put to immediate use… so I thought I’d share.

My sister had a birthday not too long ago, and a couple of friends and I decided to take her away for a few days on a getaway – no kids – no husband… only “the girls” were going on this one!

There are times when I’ve found myself working in MS Word, and I’ve needed a title or header for a page or section that was more of a title bar… something like this:

To create it, I could choose a text box and then format it appropriately but the reality is that  it’s not

It’s not uncommon for us to find ourselves dragging a picture or drawing object around a document to place it where we need it, and then to turn around, go back to the Ribbon to set the word wrapping.

Let’s face it, sometimes it feels like a good 10 minutes before we’re done tinkering with these basic things, after inserting a picture

Many of us use the Print Screen button to capture screenshots… basically it’s a copy of whatever was on the screen when you hit the button and then it’s available to paste into your programs.

You may also know about the advantage of combining the Alt key with the Print Screen – it captures only the active window or dialog box.

MS Word: Pick and Choose Which Non-Printing Characters to Display

If you’ve ever used Word’s ability to display the non-printing characters in a document, you know how helpful it can be to visually verify information such as the actual number of spaces, tabs or paragraph marks present.

However, when you use that feature you

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.

Numbering Tables in MS Word

Tuesday, March 15th, 2011

MS Word: Stop Numbering Table Rows Manually, Word Can Do That for You

It’s not that uncommon… you’ve got a table in MS Word where you need the rows numbered, so you find yourself manually keying them in.

…1 – down arrow – 2 – down arrow – 3 – down arrow – 4 

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”

Retain Text Formatting in MS Word

Tuesday, March 8th, 2011

MS Word: How To Ensure That Your Formatting Is Kept When You Copy And Paste Text

When you copy and paste text, do you ever find yourself wondering why sometimes certain formatting traits were pasted with the text and at others aren’t?

It can seem sort of random to most people… and random is

Create a Distribution List in Outlook

Tuesday, March 8th, 2011

Benson in Austin TX asks:

I am organizing a class reunion. In the next 3 months, I’ll accumulate at least 200 new email addresses that I’ll use only once or twice. I use Outlook and don’t want it to conflict with my regular personal/business address book? Is there a way to do this?

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

Using Character Spacing in PowerPoint

Tuesday, March 1st, 2011

Powerpoint: Making the Difficult Fonts More Readable

When putting together a document and using some more interesting fonts, I’m sure that you’ve run into the same thing that I have… the font is cool, what you want, but not very readable for some people.

The design of the font just makes it feel “squished” together.

For you and me, not

Adjusting Line Spacing in Word 2007

Tuesday, March 1st, 2011

Rose from Coon Rapids MN asks:

When I am typing a document in Word 2007, I get a wide space between the lines. How do you reduce that space?

Rose, thanks for the question. The search for your answer helped me find an answer to a question I was too lazy to

MS Word: Manually Move Table Rows or Columns Without Copy and Paste

Let’s face it, there are just times when the table you’ve set up now seems to be “out of order”. You find yourself wishing that the 3rd row was now the 5th row and that the 4th column should have actually have been the 2nd.

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.

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: