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...

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...

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...

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...

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...