Excel change default delimiter of CSV files

This Excel tutorial explains how to change default delimiter of CSV files from comma to other symbols. You may also want to read: Excel VBA convert CSV to Excel Excel change default delimiter of CSV files When you open a CSV file in Excel, you can see all columns are delimited by comma, you don't have to define which character you want to use to delimit the row. It is because the default delimiter of comma is configured at Windows level, all Windows applications (including Excel) will us...
More

Enable and Disable Protected View in Excel

This Excel tutorial explains how to enable and disable Protected View in Excel and other Office applications. Protected View in Excel Protected View feature is used to protect your computer from virus when you try to open Excel workbook from the Internet or other unsafe locations, or open attachment in Outlook email. The protection is achieved by disabling some features and making the Workbook read only. Protected View is a feature that you can enable or disable in Option. When the Protecte...
More

Excel set default font

This Excel tutorial demonstrates how to set default font type in Excel. Excel set default font This is a quick tutorial to show you where to set default font type in Excel. You probably need to know this after you upgrade to a new version of Excel. I will demonstrate how to do so in Excel 2013, click here for 2010 version. Click on FILE tab Click on Options on the left menu   Under the General page, you will find the default font and font size. Select the font you w...
More

Excel install Analysis Toolpak Add-Ins

This Excel tutorial demonstrates how to install Analysis Toolpak. What is Analysis Toolpak Add-Ins Excel Analysis Tookpak is an Add-Ins that adds additional analysis functions (such as statistics and engineering functions) to Excel. You have to install the Analysis Toolpak in order to use the functions. Note that if you use the Add-Ins function but the receiver of the file has not installed the Toolpak, the receiver will still be able to see the generated result but the function will fail w...
More

Excel Workbook Calculation Automatic and Manual

This tutorial explains Excel Application Calculation Automatic and Manual. You may also want to read: Excel VBA Application Volatile Method Excel Workbook Calculation In Excel worksheet, there are three options under Workbook Calculation. Explanation of Excel Workbook Calculation Options Excel Option Description Automatic Default option. Recalculation occurs when- Edit a Cell- Open workbook- Add / Delete / Hide / Unhide row - Rename worksheet - Reorder worksh...
More

Excel AutoCorrect Option

Excel AutoCorrect Excel AutoCorrect literally means to correct a misspell text to a correct text automatically, but you can also make use of this function to make a mapping list, to convert a text to another text automatically, so Excel AutoCorrect is more than just "Correction". Some people use it to convert abbreviation, convert language. For example, if your mapping list maps M as Mother, as you type "M" in a Cell, it will convert to "Mother". Other Office products also have the exact ...
More

Add Excel Developer Tab

This Excel tutorial explains the use of Excel Developer Tab and how to add Excel Developer Tab for Excel 2007, 2010 and 2013. What is Excel Developer Tab? Excel Developer tab is a category in menu bar which contains everything you need regarding Macro, such as recording Macro, inserting Controls (button,  text box, drop down list, etc), view the Property of Control. Below is a screenshot of Excel 2013 Developer Tab. In Excel 2003, you can find everything under "Tools" > "Customize", ...
More

Excel worksheet R1C1 reference style

This Excel tutorial explains how to use R1C1 reference style in Excel worksheet. Excel worksheet R1C1 reference style In R1C1, "R" refers to row, while "C" refers to column. Formula R1C1 allows you set formula for a cell, using relative row and column. For example, you want to set a formula in C2 to sum the two cells on the left, before that you should ask yourself a question: Do I want to sum the cell on left 1 and left 2 relative to C2, or Do I just want to sum A2 and B2, no matte...
More