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(…)
Microsoft Office 2007
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(…)
How to Hide/UnHide Sheet in Excel 2007/2010
While Presenting Excel Sheet there is no need to Show all the Sheets to viewers so Excel 2007/2010 gives a way out of this With many Distinct features of Excel 2007/2010 it also has Features to Hide sheet in Excel 2007/2010 which will remain active and keep on Working in the hidden mode Right click(…)
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.
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(…)
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(…)
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(…)
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(…)
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(…)