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 the Worksheet Direction in Excel 2007 – 2010 ?
In Microsoft Excel , the default direction of the Worksheet is left to right . You could easily modify this behaviour in Excel 2007 or Excel 2010 by changing the settings in Excel . 1. In Excel 2010 , Navigate to File -> Options 2. Click the Advanced link in [...]
Categories: Excel Tags: Direction, Excel 2007, Worksheet
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 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
Microsoft’s List of Known Issues with Office for Mac 2011 on Mac OS X 10.7 Lion
Microsoft has listed out the known issues with Office for Mac 2011 on one of the Mac OS X 10.7 Lion , one of the latest version of Operating system from Apple . Microsoft has outlined the issues the users of the Microsoft’s Office for Mac 2011 might face when [...]
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 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 [...]
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 [...]
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 [...]
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
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 Disable ScreenTips in Excel 2010 ?
Screentips is a helpful feature in Office . When you hover a button , a popup box is displayed with some information . If you are an expert user and if you wish to disable the feature you can do it easily . 1. Start Excel , got to File [...]
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
POWER function in Excel 2007
The POWER function in Excel returns the value after the number is raised to the exponent . The syntax for this function is POWER ( Number , Exponent ) . Make sure that the = symbol is prefixed before the function when using it . For example =POWER(9,2) will result [...]
