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 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 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 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 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
How to go to a specific row in Excel 2010?
If you want to focus or go to a certain row in Excel, you can use the GoTo Dialog window to achieve it. How to go to a specific row in Excel 2010? 1. Press Ctrl + G. This will open a small Dialog Window. 2. Enter the row number [...]
Categories: Word Tags: excel 2010, Go to, specific row
How to create a blog post in Word 2010?
Do you want to create a blog post in Microsoft Word? If yes, then you are in the right place. Microsoft Word 2010 provides various blogging platforms like Blogger, Word Press etc. With the powerful editor like Word, things can be very easy to write and format a blog post [...]
How to change the page color in Word 2010 ?
If you want to change the background color or page color in Word 2010 , you can do it easily by changing the Page color option in the Page Layout tab . How to change the page color in Word 2010 ? 1. Navigate to the Page Background group in [...]
Categories: Word Tags: page color, Word 2010
Multi line text from Excel to Notepad
Here’s something that i noticed today when working with Excel and notepad . When a multi line text is created in a cell in Excel and then copied to a different text editor , you will find that the double quotes is added around the string . For example , [...]
Categories: Excel Tags: Excel, Multi line, Notepad++, text
Shortcut key to insert a date in Excel
Want a quick and easy way to insert the current date into a Excel sheet cell ? Below is a shortcut that lets you to insert the current date “Control Key” + “;” The Control Key and Semicolon key will insert the current date to the selected cell in a [...]
Compare Excel , Word and PDF documents with xdocdiff plugin for WinMerge
Just came across a plugin fot WinMerge called xdocdiff that lets you to compare Excel , Word and PDF documents . If you are new to WinMerge . Below is a short description about WinMerge from the product website What is WinMerge ? WinMerge is an Open Source differencing and [...]
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 do display distinct values of a column in Excel ?
If you want to find the distinct values in a column , you can find that using the Sort and Filter Section in Excel. How do display distinct values of a column in Excel ? To display distinct values of a column in Excel , follow the below steps 1. [...]