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 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 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 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 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
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 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. [...]
How to change default email client for Microsoft Excel ?
When you try to send the excel file via the File -> Send options in Excel , by default , you will be sending email via Outlook . If you are looking to change the default email client , follow the below steps in Windows 7. 1. Click Start button [...]
Categories: Excel Tags: default email client, Excel, Microsoft
How to Auto Increment dates in Excel ?
Here’s one of the trick that i learnt today in Excel that automatically increases dates in Excel . To Auto Increment dates in Excel , follow the below steps 1. Enter the starting date and the first increment date in 2 rows 2. Select the first 2 rows and mouse [...]
Categories: Excel Tags: Auto Increment, dates, Excel
How to repair Corrupted Excel File ?
Microsoft Excel is one of my most frequently used softwares . Today’s morning , i got an excel sheet file that was fine for some time until i received the File corrupted error . Below is a simple option in Microsoft Excel that helped me to replait the Corrupted file. [...]
How to format a cell with Indian Rupee Symbol in Excel ?
If you are using Excel and finding out how to format a cell with a Indian Rupee symbol in Excel , here’s a tip to do that . 1. Right click on the cell which you want to format . 2. Click the Currency item from the list ( Number [...]
Categories: Excel Tags: Excel, Indian Rupee, Symbol
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 Create Drop-Down List in Excel ?
Creating a lookup or dropdown list in Excel is very simple and easy too . The drop down list provides an option to lookup to an existing values and avoids the users from enter the values manually each and every time again and again . To do this , we [...]
Categories: Excel, MS Office Tags: add, combo box, create, dropdown list, Excel, look up, nativeblogger
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 show and hide comments and indicators in Excel 2010 ?
Usually , Excel displays the comments in the excel worksheet with the indicator . When the user hovers over the indicator , the comment is displayed . You can change this behaviour easily in Excel 2010 to either disable the indicator and comment or even show the comment by default [...]
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 [...]
How to disable autocomplete feature in Excel 2010 ?
By default , Excel 2010 uses the AUtocomplete feature which will suggest you the words based on the values that was recently entered in the cells of the Worksheet . You might sometimes want to disable this feature, which you can do it easily in Excel 2010 . 1. Go [...]
Uninstall Office 2003 , 2007 , 2010 using Fix it Tool
Do you have problems in uninstalling the Office 2003 / 2007 / 2010 from the control panel ? When installing Office 2010 , you might uninstall the older version of office but still some files might reside on your PC . Here’s a Fix it Tool that helps to uninstall [...]
Disable safe mode in Office 2010
By Default , the safe mode is turned on in the settings of Microsoft Office . You can disable the safe mode in Microsoft . In the below example , i take up Microsoft Excel to show how to disable the safe mode . 1. Open Microsoft Excel . 2. [...]
Run Office 2010 in Safe Mode
If the Office 2010 ( Excel , Word , Powerpoint etc. ) has some issues on the PC and becomes unresponsive , then running it in a safe mode is a better option . To run the Office 2010 softwares in a safe mode , follow the below steps . [...]
Categories: Excel, MS Office, Tools Tags: Excel, Microsoft, Office 2010, Powerpoint, safemode, Word
How To Disable Mini Toolbar in Microsoft Excel and Word 2010 ?
In Office 2010 ( Word / Excel ) , when a particular test is selected , a menu silimar to the pop up is automatically displayed and appears to be be a kind of transparent for some time . This feature is a useful one since it provides immediate and [...]
How to change the default view for new Excel worksheets in Office 2010 ?
When you open Excel , you can see the worksheets that are newly created will be displayed in NOrmal view mode . There are actually 3 different views for the new Excel sheet . Page Layout View Page Break Preview Normal View Changing the layout might be useful when you [...]
Categories: Excel, MS Office, Tools Tags: Default, Excel, Office 2010, Page Layout, Pagebreak, view
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