How to Remove the negative sign of a number within a cell in Excel 2007 ?
This article will demonstrate different ways to remove negative sign of a number within a cell in Microsoft Excel 2007 . How to Remove the negative sign of a number within a cell in Excel 2007 ? Below are some of the techniques which can be applied to remove the [...]
Categories: Excel Tags: Excel 2007, How to, tips
How to remove blank rows in Microsoft Excel 2007 ?
This article will explain quick steps on how to remove blank rows in Microsoft Excel 2007 . How to remove blank rows in Microsoft Excel 2007 ? The Microsoft Excel includes a feature called Go to Special command which lets the users to easily remove the blank rows in the [...]
Categories: Excel Tags: Excel 2007, How to, tips, tricks
5 Analytics API for Windows Phone Apps
5 Analytics API for Windows Phone Apps Do you want to keep track of the App statistics, analyze the most frequently used pages or features in your Windows Phone App ? If yes, below are 5 different Analytics API for Windows Phone Apps. 1. Microsoft Silverlight Analytics Framework Microsoft Silverlight [...]
Categories: WP News Tags: Analytics API, How to, tips, Windows Phone, Windows Phone 8
How to split cell contents in Excel 2010?
Here’s a simple tip that lets you to split the cell contents in Excel. How to split cell contents in Excel 2010? Assume, you have a column that has both the First Name <Space> Last Name and if you want to split this column values to 2 column with one [...]
Categories: Excel Tags: Excel, excel 2010, How to, split cell contents, tips, tricks
How to find the number of chararcters in a word document ?
In Word 2010 , you can find the number of characters in the word document by clicking on the Words : <Number> button that is visible in the bottom bar of the Word document . This will display the Word count window that shows you the characters counts including (With [...]
How to Add a new library in Windows 7 ?
Windows 7 has a cool feature called Windows 7 called Library that lets you to store data like documents , pictures , videos etc . You can easily add a new library in Windows 7 by following the below steps How to Add a new library in Windows 7 ? [...]
How To Enable Hyper-V Manager In Windows 8 ?
The Windows 8 includes a new feature called Microsoft Virtualization manager and hypervisor . What is Hyper-V ? Microsoft Hyper-V was earlier named as Viridian or Windows Server Virtualization is a hypervisor-based virtualization system for x86-64 systems. Its a Kind of Virtualization technique that runs multiple guest operating systems on [...]
How to minimize Ribbon in Windows 8 Explorer by Default ?
Do you like the Microsoft Office 2010 UI?? . If yes you might relate something from Office 2010 to Windows 8. Yes, it’s the Ribbon. The Ribbon includes some of the frequently used shortcuts which may be helpful for the users to identify the most commonly used commands easily. Well, [...]
Additional Memory Power Management Options In Windows 8
The Windows 8 includes some extra power management features being included to Windows Power Plan Advanced Settings . This can be accessed via the Power Options . Just Navigate to the Power Options in Control Panel and click the Edit Plan Settings . Now click Change Advanced advanced power settings [...]
How to Toggle Windows 8 Start Menu Without Rebooting Your Computer ?
There are already many tools or Apps that enables the user to switch between the WIndows 8 and Windows 7 style Start Menu . Here’ another WIndows 8 Gadget that lets the user to switch between the Windows 8 Metro Start Menu and the Windows 7 style UI without restarting [...]
How To Enable Delete Confirmation Message in Windows 8 ?
Have you tried to delete a file in Window 8 ? You might notice that you will not get the Confirmation Dialog by default when you delete a file or a folder . In this blog post , i will explain you how to enable the delete confirmation Message in [...]
When does Windows 8 Developer Preview Build Expires ?
Well , i have downloaded the Windows 8 Developer Preview and started using it and looks cool . When i installed the Windows 8 Developer Preview , i did not provide any license key as such to activate it . But i was wondering and was desperate to know how [...]
How to disable Metro UI and Get Windows 7 start menu in Windows 8 ?
If you are searching for this topic , then i assume that you are trying the Windows 8 Developer Preview at this point You might have seen the Windows 8 start menu . When you click it , it shows the tiles based start menu . What do you do [...]
How to Open a command Prompt in Windows 8 ?
Well , i got my Windows 8 Developer Preview installed on a VirtualBox and first thing i noticed was the cool Tiles based start screen . I was trying to configure something , so i wanted to open the command prompt . I expected that when i clicked the start [...]
How to disable “Paste Options” popup box in Word 2010 ?
Microsoft Office 2010 users might be familiar with the paste options dialog thats pops up when you paste a text in to your word document like the one shown below . This box contains informations like Paste with Original Formatting Merge Formatting Keep Text Only You can disable this option [...]
Categories: MS Office, Tools, Word Tags: Microsoft Office 2010, Paste Options, tips, tricks, Word 2010
Hidden Emotions and Smileys in Skype
Have you noticed in skype where you can use code to show hidden emotions ? . Below are ths list of hidden emotions that i came across recently and have been using frequently when chatting with friends . To use the hidden smileys and emotions , all that you have [...]
How to change the Layout of the Chart in Excel 2010 ?
Microsoft Excel 2010 provides different chart layouts which provides some interesting looks for the charts . The layouts for the charts provides lot of different style , different positions for the data labels and also the colors for the legends and the text . How to change the Layout of [...]
How to UnInstall fonts in windows 7 ?
By default , Windows 7 includes several fonts . Sometimes , you might wish to uninstall the fonts that you installed recently . You can delete or remove the fonts in Windows 7 by following the stepos below 1. Go to the Appearance and Personalization Dialog via Start -> Control [...]
How to save excel as xml file in Excel 2010 ?
XML is one of the most commonly used format along with Json in the internet nowadays . The Excel too supports the users to save the Excel wordsheet in the XML format . To save the Excel to XML or to convert Excel to XML , follow the below steps [...]
Categories: Excel, MS Office, Tools Tags: excel 2010, Office 2010, tips, tricks, XML
How to digitally sign a word document in Word 2010 ?
In this Blog post , i will explain what is digital signature and how one can use the digital signature in Microsoft Word 2010 . What is Digital Signature ? Digital signature is used to authenticate the information in the documents and emails which are in digital format . The digital [...]
Categories: MS Office, Tools, Word Tags: Digital signature, How to, Office 2010, tips, Word document
How to Auto Archive Email Messages in Outlook 2010 ?
The outlook might sometimes grow in size as and when you receive hundreds of emails everyday . The Auto Archive feature in outlook helps you maintain the Outlook pesonal file zine to be smaller by moving the old emails to a different file . To configure the Outlook 2010 for [...]
Categories: MS Office, Outlook, Tools Tags: Auto Archive, howto, Office 2010, Outlook 2010, tips
Adding Google Analytics code in DotnetNuke
Adding the Google Analytics code to your dotnetnuke website is easier as it is . The DotnetNuke 5 includes the Google Analytics module by default which is visible when you login as an Administrator or above . You will see the the google analytics page when you click on the [...]
Categories: DotnetnetNuke, Tools Tags: C#, dotnetnuke, google analytics, tips
How to sort numbers in Excel 2010?
This Blog post is a very simple one and is intended for beginners which will cover how to sort numbers in Excel 2010. You can sort the number based on Ascending or Descending order. To sort the numbers, select the cells that contains numbers and right click to select Sort [...]
Categories: Excel, MS Office, Tools Tags: excel 2010, Office 2010, tips, tricks
How to display start menu items in Expanded view in Windows 7 ?
You can set the expanded view for the start menu items in Windows 7 easily which helps you avoid going to other places to find the necessary files / programs . For Example , Imagine you need to uninstall a program . This might require that we click control panel [...]
How to enable or disable Shadows in Windows 7 ?
Windows 7 has some interesting visual effects in the UI that grabs your attention. One of them is the shadow effect which you can easily notice in the Aero Theme. With Shadow Without Shadow It is also easy to enable / disable this shadow effect. 1. Click start menu and [...]
Alternate Row Coloring in Excel 2010
You can easily color / highlight the alternate rows in Excel 2010 worksheet with the Format Painter. To apply coloring for alternate rows, first select the 1st and 2nd and select appropriate colors to it. With the 2 rows selected now click the format painter icon from the Home Tab. [...]
Categories: Excel, MS Office, Tools Tags: excel 2010, Office 2010, tips, tricks
How to protect or lock a cell in Excel 2010 for read only access?
Do you want to protect a cell in Excel 2010 by making it read only and not allowing the user to edit it? Here’s a simple tip that lets the do the task. By Default , all the cells in the worksheet is marked as “Locked” which means when you [...]
How to edit the received Email in Outlook 2010?
Outlook 2010 has an interested feature that lets you edit the email that you received. To edit the received message 1. Start Outlook 2010 2. Go to Inbox and double click the message that you wish to edit. 3. Select Edit Message from the Action dropdown in the Move Section [...]
Categories: MS Office, Outlook, Tools Tags: Office 2010, Outlook, received email, tips, tricks
How to add Links in Google + Profile?
Google Plus lets you add more custom links to your profile. This may be useful in case you want links such as as Twitter URL, Blog or website beings added as link in your Google plus Profile. You can also add a website that is exclusively about you by selecting [...]
Categories: Google Plus, Social Media, Tools Tags: Google Plus, howto, links, profile, Social Media, tips, tricks
How to color the complete line in Word 2010?
The Word 2010 allows you to apply a color for the complete line / region. This might be helpful in letting the readers know the importance of a sentence. Just place the cursor where the region / line should be colored and navigate to the Paragraph group in the Home [...]