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 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 PDF files with Excel 2010 ?
Here’s a feature in Microsoft Excel 2010 that lets you to create Acrobat Reader PDF files . Infact , this feature was available in Microsoft Excel 2007 with the Microsoft Office Service Pack 2 installed . Enter some data in the Excel Worksheet and follow the below steps . 1. [...]
Categories: Excel Tags: create, excel 2010, PDF
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
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 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 [...]
7 Default Templates in Excel 2010
The Excel 2010 comes up with seven default templates when you install Office 2010 . These templates include Timecard Sales Report Expense Report Billing Statement Blood Pressure Tracker Loan Amortization Personal Monthly Budget To use the template , just click on the File Menu and then New . This [...]
Categories: Excel, MS Office, Tools Tags: excel 2010, Office 2010, templates
How to include more than 3 worksheets in Excel 2010 on its start ?
By Default , when you start Excel , you will see 3 worksheets created by default . You can change the setting in Excel to display more than 3 worksheets when it is started . To increase the number of worksheet on its start , 1. Start Excel . Click [...]
How to Change the color scheme of Excel 2010 ?
Here’s a simple tip on how to change the color scheme of the excel in Office 2010 . The Office 2010 comes with 3 different color schemes Blue , Silver , Black . The default color scheme is silver in Office 2010 . This can be changed in the Options [...]
Categories: Excel, MS Office, Tools Tags: color scheme, DropDown, Excel, excel 2010, Microsoft, Office, Themes
Qortex’s Power Pivot for Excel 2010
What is Power Pivot for Excel 2010 ? How do one implement it in their business ? Qortex is organising an webinar for the above topic on March 08, 2011, 12:00PM MST . This is a online virtual event and you require Live Meeting to watch it . You can [...]
Categories: Events Tags: excel 2010, Power Pivot, Qortex
How to add Drop Downlist in Excel 2010
Drop Downlist in Excel 2010 A drop down list allows you to enter data into an Excel from a list of data. This makes the data entry easier . When a drop down list is created , an arrow next to the cell is displayed .You can enter the Data [...]
Categories: Excel, MS Office Tags: excel 2010, Microsoft