Find Duplicate And Filter Cell By Color in Excel 2007/2010

Removing or identifying duplicate values in a Excel sheet is very difficult task, most people do it by using the formula of “countif”, but Excel 2007 / 2010 has introduced a new function of “conditional formatting”

Conditional formatting is tool which format cell or cells on conditioned specified, Excel 2007 / 2010 has provided new function of highlighting duplicated cells, this function highlight all duplicate value in selected cells to use this function, go to “Home” Tab select all cells in which you want to find duplicate, then click on Conditional formation > highlighting cell rules > Duplicate values

Read moreFind Duplicate And Filter Cell By Color in Excel 2007/2010

How to Troubleshoot Microsoft Word 2007?

Microsoft Word 2007 is enriched with many outstanding and useful features that leads to efficient management of your documents. With the help of Word 2007, you can download template documents by connecting to the Internet, latest clip arts, online dictionary and images directly from the Microsoft Office official website. Already built templates are quite handy in saving a lot of useful time needed to create them. Apart from these and other various remarkable features, Word 2007 also provide built in support to fix various bugs that you may encounter while using Word 2007. Word 2007 is bundled with Microsoft Office Diagnostic Tool. Word 2007 troubleshooting tool is very easy to use and i have illustrated these easy steps in the lines below which will help you to troubleshoot Microsoft Word 2007 using Microsoft Diagnostic Tool.

How To Hide/Unhide Columns/Rows/Cells In Microsoft Excel 2007

Excel spreadsheets are very often being shared so you don’t want complete data in the sheet to be shared/printed. For this purpose, there is hide/unhide utility in Excel 2007.

Hide the Column/Row

1- Select the column/row with left click and then right click will give you the option to hide the column.

Read moreHow To Hide/Unhide Columns/Rows/Cells In Microsoft Excel 2007

5 Ways To Save An Excel 2007 Workbook

I was searching for how many ways we can save an excel workbook. It’s always interesting to know more ways to save as we can use any one of them whenever we feel easy. Let’s discuss the ways I have discovered.

1- Save

To save a document, just click on the Office Orb button on the top left of Microsoft Excel and select Save from the menu. This will save the document. If the document has already been saved, Excel will not ask for file path to save. Rather it will save it automatically replacing the existing file.

Read more5 Ways To Save An Excel 2007 Workbook

Blogging with Microsoft Word 2007

Microsoft Office suit is a collection of several noteworthy and remarkable tools including Microsoft Word, Microsoft PowerPoint, and Microsoft Excel. Microsoft Office tools are used for compilation of documents, presentations, spreadsheet, database management, drawing, designing and much more. Today I am writing about a new feature in Microsoft Word which is best known for creating documents. Microsoft Office 2007 provides a new and unique feature of blogging, i.e., you can use Microsoft Word as a tool for blogging. Thus, If you are looking to post a article to your blog website, you can easily do so through Microsoft Word 2007 as an alternative to Word press or blogger. Moreover with the help of blogging feature, you can even add categories to your posts.

How To Fix Images Not Displaying In Microsoft Word 2007

Recently one of my colleagues came to me complaining about malfunctioning Microsoft Word document. He was saying that his Microsoft Word 2007 was not showing any images. He downloaded the document multiple times but to no avail. He also tested the document on another machine but the document was opening fine on the other machine and was showing images properly.

Read moreHow To Fix Images Not Displaying In Microsoft Word 2007

Get Connected with Hotmail Using Microsoft Outlook

Outlook Hotmail Connector lets you to access,manage your Windows Live, Hotmail,Office live accounts with Microsoft Office 2003,2007 and 2010.

Outlook connector enables you to read,send emails,manage contacts,options for blocking junk mails,manage and synchronize calenders with your Live Hotmail/Office Live Mails accounts

If you use the Microsoft Outlook 2010 you will have additional benefits like synchronization of safe sender list/blocked sender list/ safe recipient lists with Outlook and Hotmail.

Read moreGet Connected with Hotmail Using Microsoft Outlook

How To Enable Insert Key In Microsoft Word 2007, Word 2010

Microsoft Word versions previous to Word 2010 and Word 2010 and even Windows WordPad had an option to overwrite the text if we press the Insert key before typing anything. Things have changed in Microsoft Word 2007 and onwards. Now there is an Insert Mode which works in the same way as pressing insert key in the previous versions. But the problem is that it must be enabled before it can be used in Microsoft Word 2007 or Word 2010. Otherwise Insert will have no function by default.

microsoft word 2010 starting

Read moreHow To Enable Insert Key In Microsoft Word 2007, Word 2010