Stop Auto Formatting of Numbers into Date in Microsoft Excel

Whenever you eneter numbers separated by a hyphen in Microsoft Excel, it automatically converts that data into date format. Suppose you type "2-2" in Excel it becomes "02-Feb" automatically, so to prevent this automatic formatting of numbers into date in Excel follow simple steps below. Method-1 Step-1 Select entire cells of a Workbook in Excel [...]

How to Set Password on Word Document

Microsoft Office applications Word, Excel and PowerPoint help users to prevent the files from unauthorized access by providing the feature of “Encrypt with Password”, which allows users to make their files password protected. Here you can see how to set and remove password: Word 2010 document Word 2007 document Set a Password to document in [...]


How to Change Office 2010/2007 Color Scheme

If you are bored with the default blue color scheme of Office applications then here is a way out to change that. As Office 2010 and 2007 allows users to chose different color schemes like silver, black or blue. So lets see how to change Office 2007 or 2010 color scheme. Change color scheme Office [...]