How to create drop down list in Microsoft Excel ?
This article will explain how to create drop down list in Microsoft Excel 2007 . Drop down list is one of the most commonly used ways in excel to allow users to select the items from the predefined list . The drop down list in Excel allows the users to [...]
Categories: Excel Tags: drop down list, How to, Microsoft Excel
How to Right Trim Characters in Microsoft Excel 2007 ?
This article will explain the RIGHT function in Microsoft Excel 2007 which is used to remove unwanted characters from the cell . There are few functions in Excel which can remove characters like LEFT , RIGHT etc and this can be chosen based on the requirement. How to Right Trim [...]
Categories: Excel Tags: characters, Microsoft Excel, Right Trim
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 print with gridlines in Microsoft Excel 2007 ?
This article will explain how to print with gridlines in Microsoft Excel 2007 . How to print with gridlines in Microsoft Excel 2007 ? When you print the excel sheet , it doesn’t print gridlines on worksheet. Follow the below steps to print the Microsoft excel worksheet along with the [...]
Categories: Excel Tags: Excel 2007, Microsoft Excel
How to Change the color of gridlines in a Microsoft Excel 2007 ?
In one of the previous article , we explained how to remove the gridlines in Microsoft Excel 2007 . This article will explain how to Change the color of gridlines in a Microsoft Excel 2007 ? The default color of the grid lines in excel is the “automatic” in the Excel options [...]
How to remove gridlines in Microsoft Excel 2007 ?
This article will explain how to remove or hide gridlines in Microsoft Excel 2007 worksheet. What are Gridlines in Excel ? Gridlines in Microsoft Excel are lines that appear around each cells which distinguishes one cell from another. How to remove gridlines in Microsoft Excel 2007 ? If are a [...]
Categories: Excel Tags: Excel 2007, Microsoft Excel
How to remove spaces in a cell in Microsoft Excel 2007 ?
This article will explain how to remove spaces in a cell in Microsoft Excel 2007. How to remove spaces in a cell in Microsoft Excel 2007 ? There are times when the text value entered in a cell contains leading or trailing space characters which may cause some unexpected behavior [...]
Categories: Excel Tags: cell, Excel, Excel 2007, How to, Microsoft Excel, remove spaces
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 remove duplicate rows in Excel 2007 ?
This article will explain how to remove duplicate rows in Excel 2007 in simple steps. What is a Duplicate row ? A duplicate row will have all the values (column data) in the row will have a matching data in another row. For example , a row with the name [...]
Categories: Excel Tags: Excel 2007
How to use Quick parts in Microsoft Word 2007 ?
Quick parts is one of the feature that was introduced in Microsoft Word 2007 which allows the users to add some of the preformatted stuffs which can later be reused again and again . One of the advantages of the Quick parts in Microsoft Word is that it saves you [...]
How to Repeat your Last Step in Microsoft Word?
There are times when you do a task in Microsoft Word that you tend to repeat again and again. How to Repeat your Last Step in Microsoft Word? For example 1. You could insert a row in a table and want to continue inserting more rows. 2. You did some [...]
Categories: Word Tags: How to, Microsoft, Repeat your Last Step, Word
How to delete Dictionary entries in Microsoft Word?
Here’s a simple option in Microsoft Word that lets you to delete the Dictionary entries. In this example, I am using Microsoft Word Consumer Preview 2013. How to delete Dictionary entries in Microsoft Word? To delete the Dictionary entries in Microsoft Word, follow the below steps 1. Launch Microsoft Word. [...]
How to Pin the Favourites Folder to Windows 8 Start Screen?
The Favourites folder in Windows allows the users to group frequently used folder paths so that the cessing becomes easier. You could also pin the favourites Folder to Windows 8 Start Screen which will help you to access the favourite’s folder from the Windows 8 Start Screen. How to Pin [...]
Categories: Windows 8 Tags: favourites, folder, Pin, start screen, Windows 8
How to open blank page on new Tab Open in Internet Explorer 10?
When you open a new tab in Internet Explorer, you will see the page that lists your most popular website. If you want to display only the empty page and wish not to display the page that displays the most popular sites , you can easily do that by configuring [...]
Categories: IE9 Tags: How to, Internet Explorer 10, Tab Open
How to remove Preinstalled games in Windows 7?
When you install Windows 7, there are few games that will be installed like Minesweeper, Solitaire etc. If you want to remove these games from your Windows 7, you can do that by following the below steps How to remove Preinstalled games in Windows 7? 1. Navigate to Control Panel [...]
How to Open Elevated Command Prompt in Windows 8 using Power User Tasks Menu?
You can easily open the Elevated Command Prompt in Windows 8 using the Power Users Tasks Menu. Follow the below steps to Open the Elevated Command Prompt in Windows 8 using Power User Tasks Menu. How to Open Elevated Command Prompt in Windows 8 using Power User Tasks Menu? 1. [...]
Categories: Windows 8 Tags: Command Prompt, Elevated, Windows 8
How to Disable start screen in Microsoft Word 2013?
There are lot of improvements in Microsoft Word 2013 and one of the feature that you will notice is the start screen. The start screen in Microsoft Word contains lot of new options where you can view the recently accessed documents or create or open the documents from the available [...]
Categories: Word Tags: Disable, Microsoft Word, start screen
How to Add Gmail to Mail App in Windows 8 Release Preview?
Here’s a simple tip that lets you to add your Gmail account to the Mail App in Windows 8 Release Preview. To add the Gmail to the default Mail App in Windows 8 Release Preview, follow the below steps How to Add Gmail to Mail App in Windows 8 Release [...]
Categories: Windows 8 Tags: App, Gmail, Release Preview, Windows 8
How to access the Internet Options in Windows 8 Style UI ?
The Windows 8 Release Preview comes with 2 versions of the Internet Explorer 10. 1. Windows 8 Style UI version 2. Normal Desktop Version. If you are in the Windows 8 Style UI mode (Metro) and if you want to access the Internet Options, you can do it by following [...]
Categories: Windows 8 Tags: Internet Options, Metro, Windows 8, Windows 8 Style UI
How to compare Excel Sheet side by side in Microsoft Excel 2013?
Microsoft Excel has the feature “side by side” view that lets you to quickly do a side by side comparison of 2 excel worksheets that are open. How to compare Excel Sheet side by side in Microsoft Excel 2013? Follow the below steps to view the multiple and compare excel [...]
Categories: Excel Tags: Excel, Excel Sheet, Microsoft Excel 2013, side by side
How to import Gmail Contacts to Outlook.com?
Last week, Microsoft had introduced Outlook.com, a completely new and refreshing UI for an email service. The users of different social networking sites like Twitter, Facebook, and LinkedIn can import their contacts to the Microsoft’s Outlook.com. If you are a Gmail user, you can easily import contacts from Gmail to [...]
Categories: Outlook Tags: Gmail Contacts, import, Outlook.com
How to remove duplicate rows in Microsoft Excel 2010?
In Excel, you can remove duplicate rows easily using the Data Tools available in Excel 2010. How to remove duplicate rows in Microsoft Excel 2010? Follow the below steps to Remove duplicate rows in Microsoft Excel 2010. 1. Select the list of rows that you want to find the duplicate [...]
Categories: Excel Tags: Excel, excel 2010, How to, Microsoft, remove duplicare rows
How to write in two lines in a cell in Excel?
Most of the users would be aware of the Word-wrap feature which is quite commonly used to arrange the data in excel to occupy the cell width so that the complete data in cell is visible. You can set the Word-wrap for a cell or column via the Format Cells [...]
Categories: Excel Tags: Excel, excel 2010, How to, multiple lines, two lines
How to put zero in the front of a number in Excel 2010?
Sometimes in Excel, you may want to format the columns / cell such that it prefixes 0 to the cell value. For example, assume the cell contains 98765, and you may want to put or prefix 0 in front of this value making 098765 and always show six digit numbers. [...]
How to Refresh Windows 8?
There might be a time when your Windows 8 system might show fatal exceptions and Windows 8 getting corrupted. In these scenarios, you might use the Windows 8 Refresh feature. This feature will enable the Windows 8 user to restore Windows 8 to original state without reinstalling. Note that this [...]
How to calculate Age in Excel 2010 based on Birthday?
In Excel 2010, you can calculate the Age of a person by applying the below formula. How to calculate Age in Excel 2010 based on Birthday? Assume that you will enter the date of birth in the cell C1, the formula to calculate age in Microsoft Excel will be =DATEDIF(C1,TODAY(),”Y”) [...]
Categories: Excel Tags: Birthday, calculate Age, excel 2010, How to
How to change the Windows user Password without knowing the old password?
If you are Windows 7 or Windows 8 user and wish to change the Windows user’s password for which you don’t know the password. Here’s a small tip to achieve it. How to change the Windows user Password without knowing the old password? Read more about How to change the [...]
How to freeze or lock columns and rows in Excel 2010?
In Excel 2010, you can freeze columns or rows with the following options Freeze Panes Freeze Top Row Freeze first column How to freeze or lock columns and rows in Excel 2010? 1. To freeze or lock rows, select the row. 2. In the View tab of Microsoft Excel, click [...]
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 retrieve the Day part from a Date in an Excel cell?
How to retrieve the Day part from a Date in an Excel cell? In Excel 2010, if you want to retrieve the Day part from a Date, you can use the function Day to get the day. For example, if the date is 5/26/2012, using the Day (5/26/2012) function will [...]
Categories: Excel Tags: cell, Day, Excel, retrievemDaye