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
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 [...]
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 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 [...]
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 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 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 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 [...]
How to view hidden files in Windows 7 ?
The Windows 7 by default hides the important files that are related to the windows core files . Sometimes , it happens that you require to view the hidden files . You can enable the option to view the hidden files by following the below steps 1. Go to Control [...]
How to modify the default Sounds in Windows 7 ?
The Windows 7 comes with different themes like Architecture , Characters , Landscapes , Nature etc . Each of these theme has default sounds that grabs your attention when you perform some operation . You can modify them or turn the sound off by following the steps below . 1. [...]
Changing the Style of Underline in Word 2010
The Word 2010 has a number of styles which can be applied to the Underlines. It is also possible to define the color of the underline in Word 2010. To change the Style of the Underline follow the below steps 1. Select the text to be underlined and click the [...]
How to Start Windows 7 in Safe Mode?
Running Windows 7 in safe mode is useful and can help in cases where you want to troubleshoot problems with the programs and drivers and solve some serious problems which are not possible when Windows 7 is started normally. 1. To Start Windows 7 in safe mode, turn on your [...]
How to specify Page Size before printing in Word 2010 ?
In Word Document , you can specify or choose the page size according to your needs before you print the document . To specify or change the page size 1. Click File Menu – > Print and the click the Letter DropDown 2. This will show the list of available [...]
How do you want to end your Power Point presentaion in Office 2010 ?
While giving a presentation using PowerPoint , you would have noticed that a black screen is shown at the end of the presentation . It is now possible to disable showing the blank screen at the end of the slide using PowerPoint 2010 . To disable the black screen , 1. [...]
Categories: MS Office, Power Point, Tools Tags: Office 2010, Powerpoint, tips, tricks
Customizing the Power Button in Windows 7
Do you restart your System very often ? . Want the restart button instead on Shutdown power button ? . Here’s an option to do it in Windows 7 . Right click on the Start and select properties Choose the Power Button action that you want from the drop down [...]
Categories: Windows 7 Tags: tips, tricks, Windows Phone 7
How to reset Windows Phone 7 to factory default settings ?
Sometimes it may be necessary for you to rest your Windows Phone 7 to factory settings for different reasons which means that the personal data in thw phone like contacts , messages will be erased completely . To reset your Windows Phone 7 to factory settings follow the below steps [...]
Categories: How To's, Windows Phone 7 Tags: tips, tricks, Windows Phone 7
How to Prevent moving to the next Cell after pressing enter in Excel 2010 ?
When you type a value in a cell and press enter , you might see that you would have moved to the next cell by default . To prevent this in Excel 2010 , 1. Go to File – > Options 2. In the advanced tab of the Excel Options [...]
Automatically insert a decimal point in Excel 2010
Do you want to insert a decimal point in Excel 2010 by default when you enter a number in the cell ? You can do it easily in Excel 2010 . You can turn on this feature by checking the option “Automatically Insert a Decimal Point” in the Excel Options [...]