Excel insert file with and without VBA

This Excel tutorial explains how to insert file (insert object) in Excel using VBA and without using VBA. Excel insert file object (non-VBA) In Excel, insert file is known as insert object, there are two kinds of insert: Embedded Object - insert the source file into Excel Linked Object - insert the link of file into Excel, not the actual source file In terms of display of the inserted file, there are also two kinds: Display file with an icon, double click on the icon to open th...
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 show all comments in worksheet

This Excel tutorial explains how to show all comments and hide all comments in workbook. You may also want to read: Excel consolidate all Comments in the workbook Excel show comments in worksheet Comment is a yellow dialog box that you can write comment regarding specific Cell. To insert a Comment, right click on a Cell and then select Insert Comment When we insert a Comment into a Cell, there would be a red triangle on the top right of the Cell. Comment is hidden by default...
More

Excel difference between Form Controls vs ActiveX Controls

This Excel tutorial explains difference between Form Controls vs ActiveX Controls for Excel worksheet. Excel difference between Form Controls vs ActiveX Controls There are two different kinds of Controls in Excel spreadsheet, both are very similar but we need to know the difference between them. UserForm also has its Control but it is not discussed in this topic. In Excel 2013, to insert a Control in Excel spreadsheet, navigate to Developer > Insert , there are two groups of Controls ava...
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 Custom Format in Format Cells

This Excel tutorial explains how to use Excel Custom Format in Format Cells to format date, time, number, text, conditional formatting, leading zero, etc. You may also want to read: Excel Extract Time from Date Time Excel Display Time from Date Time What is Excel Custom Format? Excel guesses the most appropriate format for the cells when you type something in a Cell. For example, if you type 31/1/2014, Excel guesses it would be a Date, Format is dd/m/yyyy, but it would not guess it is...
More

Excel time difference in hours minutes seconds

Excel time difference in hours minutes seconds Excel has a special way to treat Date Time value but most people are not aware of that. You need to understand the meaning of the numeric values that represent Excel Date Time in order that you can freely perform Excel date time conversion to hours, minutes, days,  etc. After you understand the meaning of the numerical values, you can easily calculate Excel time difference. I have written a post that explains conversion between time and numeric ...
More

Excel Date Time Conversion

Excel Date Time Conversion Excel has a special way to treat Date Time value but most people are not aware of that. You need to understand the meaning of the numeric values that represent Excel Date Time in order that you can freely perform Excel date time conversion to hours, minutes, days,  etc. After you understand the meaning of the numerical values, you can easily calculate Excel Date Time Difference. Also read the below post about calculate time difference Excel time difference in ho...
More

Excel Shortcut key and function

Excel Shortcut key Below is a table that summarizes most Excel shortcut key. I referred to the Microsoft website for the Excel shortcut key, removed some unimportant Excel shortcut key, and then combined with some Windows short cut key that are also applicable in Excel and finally reordered and changed description of each shortcut key. Some keys do not work in older version of Excel, as each Excel version adds additional shortcut key, but the majority would work. Excel Short key Desc...
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