The World of Microsoft Office Tips and Tricks.

RSS Feed Homepage

Articles: 1, 2, 3, 4, 5, 6

And it?s 2008!! Happy New Year!!
2008-01-03 18:57:00
First let me start with wishing you and your family all the best and good health for the 2008! What a year it was pfff, a lot of things happened for me. The best thing that happened for me in 2007 was that my boss fired me. Yes that’s right my boss fired me. I ... SHARETHIS.addEntry( { title: "And it?s 2008!! Happy New Year !!", url: "http://www.theworldofoffice.com/news/and -its-2008-happy-new-year/" } );
More About: News , Happy New Year

Print the Entire Excel Workbook Instead of Only Printing Your Excel Spreads
2007-12-24 09:30:00
As talked about in last Friday’s Excel Tip and Trick about setting your print area we are now taking it a little bit further.     The next Excel Tips and Tricks article is for speeding things up a bit.   If you are working in Microsoft Excel and you press the print button or hit CTRL+P, the ... SHARETHIS.addEntry({ title: "Print the Entire Excel Workbook Instead of Only Printing Your Excel Spreads heet.", url: "http://www.theworldofoffice.com/excel-ti ps-tricks/print-the-entire-excel-workbook -instead-of-only-printing-your-excel-spre adsheet/" });

Which Rows and Columns are you Printing? Use the Print Area.
2007-12-21 09:30:00
Of course you can just press the print button or press CTRL+P but this isn’t always useful. If you only need a small part of your Excel Spreadsheet it’s better to use the “print area” option.   With the Print Area option you select a specific number of rows, columns or cells that you want to ... SHARETHIS.addEntry({ title: "Which Rows and Columns are you Printing ? Use the Print Area.", url: "http://www.theworldofoffice.com/excel-ti ps-tricks/which-rows-and-columns-are-you- printing-use-the-print-area/" });
More About: Tricks

Hiding the Grid Lines in Your Microsoft Excel Spreadsheet.
2007-12-20 12:21:00
The gridlines are probably one of the most useful tools in Microsoft Excel , especially when you’re designing an nice Excel worksheets.   On the other hand it can be very useful sometimes to have no grid lines at all in your Excel Workbook.   In this Excel Tip and Trick I’m showing you how to loose the lines in ... SHARETHIS.addEntry({ title: "Hiding the Grid Lines in Your Microsoft Excel Spreadsheet.", url: "http://www.theworldofoffice.com/excel-ti ps-tricks/hiding-the-grid-lines-in-your-m icrosoft-excel-spreadsheet/" });
More About: Tricks

Word 2007?s Building Blocks - The Quickest Way to Create Professional Docum
2007-12-19 11:33:00
The World of Office Tips and Tricks is all about getting the most out of your Windows Operating System and your Microsoft Office Suite. This Word Tip is a nice one that isn’t used by many people which is a shame since it’s one of those great Microsoft Word tools that you can really benefit ... SHARETHIS.addEntry({ title: "Word 2007?s Building Blocks - The Quickest Way to Create Professional Documents.", url: "http://www.theworldofoffice.com/word-tip s-tricks/word-2007s-building-blocks-the-q uickest-way-to-create-professional-docume nts/" });

Change the Function of the Vista Power Button to Sleep, Hibernate or Shut D
2007-12-18 09:30:00
If I may say so myself; so far we covered some great MS Vista Tips and Tricks . Some of the Vista Tips and Tricks I couldn’t live without are the Tutorial for disabling the Vista UAC - User Account Control, free partition software for Vista and the Tutorial for Loosing the Vista Login Screen. To ... SHARETHIS.addEntry({ title: "Change the Function of the Vista Power Button to Sleep, Hibernate or Shut Down.", url: "http://www.theworldofoffice.com/vista-ti ps-tricks/change-the-function-of-the-vist a-power-button-to-sleep-hibernate-or-shut -down/" });

Easier Way for Checking the Integrity of the Vista System Files.
2007-12-18 00:41:00
Windows Vista has a small build in little program/service that scans your Vista system for changed, broken, corrupt or missing system files. Normally you run this utility when you have Windows Vista running in repair mode but there is an easier way and that is via Command Prompt   To run this utility via Command Prompt you’ll ... SHARETHIS.addEntry({ title: "Easier Way for Checking the Integrity of the Vista System Files .", url: "http://www.theworldofoffice.com/vista-ti ps-tricks/easier-way-for-checking-the-int egrity-of-the-vista-system-files/" });
More About: Tricks

Making the MSN/Live Messenger Chat Window Ad Free.
2007-12-15 09:23:00
Today I wanted to show you another Tip and Trick that is possible with the Live Messenger Patch (111) that we used for the article about cleaning up the live messenger window.   It is practically the same sort of trick/method but now instead of cleaning up the Live Messenger we are now cleaning up the chat ... SHARETHIS.addEntry({ title: "Making the MSN/Live Messenger Chat Window Ad Free .", url: "http://www.theworldofoffice.com/msn-live /making-the-msn-live-messenger-chat-windo w-ad-free/" });

Formula for Automatically Colouring your Rows in Excel.
2007-12-14 09:30:00
And we are closing this week with another Cool and Handy Excel Tip and Trick. Microsoft Excel shouldn’t be used only for “boring” formulas but your spreadsheet needs to look good too.   I presume that you all know that you can colour the cells of your spreadsheet so I’m not getting in to that. Now I ... SHARETHIS.addEntry({ title: "Formula for Automatically Colouring your Rows in Excel.", url: "http://www.theworldofoffice.com/excel-ti ps-tricks/formula-for-automatically-colou ring-your-rows-in-excel/" });
More About: Tricks

Automatically Check for Email with Outlook.
2007-12-13 09:20:00
We already covert the using Microsoft Outlook 2007 as an RSS reader and using MS Outlook for Receiving RSS, sending mail but with-out receiving mail.   But earlier this week I installed a pc for a friend of my and to my surprise Outlook 2003 doesn’t have any standard settings for automatically checking/receiving e-mails. Which I think ... SHARETHIS.addEntry({ title: "Automatically Check for Email with Outlook.", url: "http://www.theworldofoffice.com/outlook/ automatically-check-for-email-with-outloo k/" });

The COUNTIF Formula to Avoid Duplicate Content in Excel.
2007-12-12 09:30:00
The next article in the category Excel Tips and Tricks isn’t a real Excel Tip or Trick. I would say it’s more a Tutorial for the advanced Excel users among us. Although it is a pretty cool Trick to know and to use.     This next Excel Tip and Trick will prevent you to enter duplicate ... SHARETHIS.addEntry({ title: "The COUNTIF Formula to Avoid Duplicate Content in Excel.", url: "http://www.theworldofoffice.com/excel-ti ps-tricks/the-countif-formula-to-avoid-du plicate-content-in-excel/" });

Split the Data in a Column by Using the Left and Right Function.
2007-12-11 07:07:00
I’ve received an e-mail from Anne asking if I could help out with a problem that she has at work. She gets a list on her desk quite frequently with on column full of data with 10 numbers (9+1). She needs to strip this data so that she only has the last 7 digits left. ... SHARETHIS.addEntry({ title: "Split the Data in a Column by Using the Left and Right Function .", url: "http://www.theworldofoffice.com/excel-ti ps-tricks/split-the-data-in-a-column-by-u sing-the-left-and-right-function/" });
More About: Tricks

Create a Transparent Text Field for your Desktop Icons.
2007-12-10 09:30:00
Okay it’s time for the next XP Tip and Trick. In the article on how to Change the Windows Explorer start directory I’ve told you that The World of Office Tips and Tricks is here for two reasons. Which are we want you to work faster with our Office Tips and Tricks and we want ... SHARETHIS.addEntry({ title: "Create a Transparent Text Field for your Desktop Icons .", url: "http://www.theworldofoffice.com/xp-tips- tricks/create-a-transparent-text-field-fo r-your-desktop-icons/" });

3 Ways for Rounding the Dollar Values in Microsoft Excel.
2007-12-07 09:30:00
If you are working in Microsoft Excel with the Dollar function it might seem simple but there are a few things you might need to consider. I’m showing you in this Excel Tip and Trick article various ways to round up the Dollar value.   If you are working in an Excel Spreadsheet and you just ... SHARETHIS.addEntry({ title: "3 Ways for Rounding the Dollar Values in Microsoft Excel.", url: "http://www.theworldofoffice.com/excel-ti ps-tricks/3-ways-for-rounding-the-dollar- values-in-microsoft-excel/" });
More About: Tricks

Handy Little Trick for Closing Multiple Word and Excel Documents at once.
2007-12-05 09:30:00
The next Office Tip and Trick is a handy one for Microsoft Word and Excel . I tried it on other Office programs like MS PowerPoint but all without any luck. And it only works in Word and Excel 2003 and previous versions. As we all know that there is more than one way to close ... SHARETHIS.addEntry({ title: "Handy Little Trick for Closing Multiple Word and Excel Documents at once.", url: "http://www.theworldofoffice.com/word-tip s-tricks/handy-little-trick-for-closing-m ultiple-word-and-excel-documents-at-once/ " });
More About: Tricks

Change the My Documents Location.
2007-12-04 09:30:00
Yesterday we created a shortcut for your Windows Explorer and talked about how we can change the Windows Explorer start directory. This next Office Tip and Trick is kind of in line with this article. You have the ability to open your my document folder directly via your Windows start menu but what if: if ... SHARETHIS.addEntry({ title: "Change the My Documents Location .", url: "http://www.theworldofoffice.com/windows- vista/change-the-my-documents-location/" });
More About: Windows X , Windows Vista

Change the Windows Explorer start directory.
2007-12-03 09:30:00
The World of Office Tips and Tricks is here for two reasons. The first is that we want you to get the most out of your Microsoft Office Suite or Microsoft Operating System and the second is that we want you to work faster with our Office Tips and Tricks. The next Office Tip and ... SHARETHIS.addEntry({ title: "Change the Windows Explorer start directory.", url: "http://www.theworldofoffice.com/windows- vista/change-the-windows-explorer-start-d irectory/" });
More About: Windows X , Windows Vista , Directory

How do you display your mail folders?
2007-11-30 16:24:00
The next Office Tip and Trick is for MS Outlook . It’s a small but handy tip for displaying your mailbox items in the way that you prefer. Microsoft Outlook has two options for displaying them. In blue "()" and in green "[]".   The Blue parenthesis "()" are for displaying the number of unread messages. And the green ... SHARETHIS.addEntry({ title: "How do you display your mail folders?", url: "http://www.theworldofoffice.com/outlook/ how-do-you-display-your-mail-folders/" });
More About: Mail , Display , Folders , Fold

Use a Drop Cap for a Professional Look.
2007-11-29 09:30:00
nd it’s time for another Word Tip and Trick and it’s a great one for making your document look as it is written by a professional.  This Word Tip and Trick is Word Tutorial for creating a Drop Cap in your word document.  A Drop Cap is the first letter of an article or chapter ... SHARETHIS.addEntry({ title: "Use a Drop Cap for a Professional Look.", url: "http://www.theworldofoffice.com/word-tip s-tricks/use-a-drop-cap-for-a-professiona l-look/" });
More About: Tricks , Fess

Make Windows XP much Faster by Disabling the Indexing Services.
2007-11-28 09:30:00
I wouldn’t use this next Windows XP Tip and Trick if you use the Windows Search a lot. Indexing Services is a tiny Windows program that uses a large amount of RAM . If you hear your system making a lot of noise and he’s terribly slow then your system is indexing his files. It ... SHARETHIS.addEntry({ title: "Make Windows X P much Faster by Disabling the Indexing Services.", url: "http://www.theworldofoffice.com/windows- xp/make-windows-xp-much-faster-by-disabli ng-the-indexing-services/" });
More About: Windows Xp

10 Great Microsoft Word Tips and Tricks you?ve never thought of.
2007-11-27 10:00:00
Select a Word – Double click on the word, the MS Word editor selects the space behind the word too. The punctuation behind the word is ignored. Select a sentence – Press CTRL and click on the sentence that you want to select. Select a paragraph – Triple click somewhere within the paragraph Paste plain text – ... SHARETHIS.addEntry({ title: "10 Great Microsoft Word Tips and Tricks you?ve never thought of.", url: "http://www.theworldofoffice.com/word-tip s-tricks/10-great-microsoft-word-tips-and -tricks-youve-never-thought-of/" });

Formula to Display the Dollar and Cents Symbols in Microsoft Excel.
2007-11-26 15:33:00
Most of us are only using the dollar symbols if we are working in an Excel Spreadsheet. This is mainly because Microsoft Excel doesn’t have an (standard) option to show cents. Since the dollar and cents symbols do look good in your spreadsheet I’ll show you in this next Excel Tip and Trick how to ... SHARETHIS.addEntry({ title: "Formula to Display the Dollar and Cents Symbols in Microsoft Excel.", url: "http://www.theworldofoffice.com/excel-ti ps-tricks/formula-to-display-the-dollar-a nd-cents-symbols-in-microsoft-excel/" });
More About: Tricks

Microsoft Excel?s 30 most used keyboard combinations/shortcuts and hotkeys.
2007-11-23 11:00:00
We posted earlier this week a list with the 30 most used keyboard combinations for Microsoft Word. Today we have a list ready for you to use with Microsoft Excel . Just as I mentioned in the above post; if you subscribe to our feed you’ll receive later this week with your feed the download location for ... SHARETHIS.addEntry({ title: "Microsoft Excel ?s 30 most used keyboard combinations/shortcuts and hotkeys.", url: "http://www.theworldofoffice.com/excel/mi crosoft-excel%e2%80%99s-30-most-used-keyb oard-combinationsshortcuts-and-hotkeys/" });
More About: Shortcuts , Keyboard

Microsoft Excel?s 30 most used keyboard combinations/shortcuts and hotkeys.
2007-11-23 11:00:00
We posted earlier this week a list with the 30 most used keyboard combinations for Microsoft Word. Today we have a list ready for you to use with Microsoft Excel . Just as I mentioned in the above post; if you subscribe to our feed you’ll receive later this week with your feed the download location for ... SHARETHIS.addEntry({ title: "Microsoft Excel?s 30 most used keyboard combinations/shortcuts and hotkeys.", url: "http://www.theworldofoffice.com/excel-ti ps-tricks/microsoft-excels-30-most-used-k eyboard-combinations-shortcuts-and-hotkey s/" });
More About: Tricks , Shortcuts , Keyboard

Microsoft Excel?s 30 most used keyboard combinations/shortcuts and hotkeys.
2007-11-23 11:00:00
We posted earlier this week a list with the 30 most used keyboard combinations for Microsoft Word. Today we have a list ready for you to use with Microsoft Excel . Just as I mentioned in the above post; if you subscribe to our feed you’ll receive later this week with your feed the download location for ... SHARETHIS.addEntry({ title: "Microsoft Excel ?s 30 most used keyboard combinations/shortcuts and hotkeys.", url: "http://www.theworldofoffice.com/excel/mi crosoft-excels-30-most-used-keyboard-comb inations-shortcuts-and-hotkeys/" });
More About: Shortcuts , Keyboard

A Quick Tip for Changing the Language in Microsoft Word.
2007-11-22 11:00:00
Let’s say you are already working in a document and you want to change the language English US to English UK. Simple selecting another language isn’t always enough for stopping Microsoft Word to jump back to English US. The problem is that Word thinks in language per template and not per sentence or word.   The Microsoft ... SHARETHIS.addEntry({ title: "A Quick Tip for Changing the Language in Microsoft Word.", url: "http://www.theworldofoffice.com/word/a-q uick-tip-for-changing-the-language-in-mic rosoft-word/" });

A Quick Tip for Changing the Language in Microsoft Word.
2007-11-22 11:00:00
Let’s say you are already working in a document and you want to change the language English US to English UK. Simple selecting another language isn’t always enough for stopping Microsoft Word to jump back to English US. The problem is that MS Word thinks in language per template and not per sentence or word.   The ... SHARETHIS.addEntry({ title: "A Quick Tip for Changing the Language in Microsoft Word.", url: "http://www.theworldofoffice.com/word-tip s-tricks/a-quick-tip-for-changing-the-lan guage-in-microsoft-word/" });
More About: Tricks

Create a Desktop Icon that Writes an Entire E-mail Message with one Click.
2007-11-21 11:00:00
In part one of this miniseries I showed you how to create a shortcut for your e-mail and how you set a fixed receiver and e-mail subject.   Now that you know how to create this shortcut you might also want to have a pre-written e-mail body or a fixed CC e-mail address.   Please do note that this ... SHARETHIS.addEntry({ title: "Create a Desktop Icon that Writes an Entire E-mail Message with one Click. Part 2", url: "http://www.theworldofoffice.com/outlook/ create-a-desktop-icon-that-writes-an-enti re-e-mail-message-with-one-click-part-2/" });
More About: Mail , Windows X , Windows Vista

A Tutorial for Hiding your Recent Items in Vista.
2007-11-20 11:00:00
This next Microsoft Office Trick and Tip is especially handy when you work at a “public” computer at the office. This probably isn’t necessary at home unless you’re working with multiple users at one computer. The problem is that when you leave your computer for one minute, willing people might check what your doing and ... SHARETHIS.addEntry({ title: "A Tutorial for Hiding your Recent Items in Vista .", url: "http://www.theworldofoffice.com/windows- vista/a-tutorial-for-hiding-your-recent-i tems-in-vista/" });
More About: Windows Vista

Microsoft Word?s 30 most used keyboard combinations/shortcuts and hotkeys.
2007-11-19 17:06:00
Microsoft Word and Excel are Microsoft’s most used applications. We often use it at home and in the office. Microsoft Word and Excel have many build in tools for the users to get the most out of the applications. Probably the most common are the Office (keyboard) Shortcuts . Most of us know “CTRL+B/I and U” ... SHARETHIS.addEntry({ title: "Microsoft Word’s 30 most used keyboard combinations/shortcuts and hotkeys.", url: "http://www.theworldofoffice.com/word-tip s-tricks/microsoft-words-30-most-used-key board-combinationsshortcuts-and-hotkeys/" });
More About: Microsoft , Tricks , Keyboard