Excel insert file with and without VBA

Posted on December 6, 2015December 21, 2016 by Wyman W

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

Excel show all comments in worksheet

Posted on June 23, 2015February 5, 2017 by Wyman W

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 delete all comments in 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 ...

Excel difference between Form Controls vs ActiveX Controls

Posted on April 25, 2015 by Wyman W

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

Excel Custom Format in Format Cells

Posted on February 24, 2015May 13, 2015 by Wyman W

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

Excel time difference in hours minutes seconds

Posted on January 24, 2015February 9, 2015 by Wyman W

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

Excel Date Time Conversion

Posted on January 23, 2015February 27, 2015 by Wyman W

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

Import Chinese CSV to Excel

Posted on January 21, 2015September 16, 2017 by Wyman W

This Excel tutorial explains how to import Chinese CSV to Excel with correct encoding. (解決CSV轉EXCEL亂碼) You may also want to read: Export Chinese Excel to CSV Import Chinese CSV to Excel When you import Chinese CSV to Excel, some Chinese characters will become a question mark "?" or convert to unexpected Chinese characters, same will happen for symbols and other languages such as Japanese, why is that? To understand what is happening, we need to know what is encoding. Computer stores a...

Export Chinese Excel to CSV

Posted on January 21, 2015September 16, 2017 by Wyman W

This Excel tutorial explains how to export Chinese Excel to CSV, the method is also applicable to other languages. (解決Excel轉CSV亂碼). You may also want to read: Import Chinese CSV to Excel Export Chinese Excel to CSV When you export Chinese Excel to CSV (Comma-separated values), some Chinese characters will become a question mark "?", same will happen for symbols and other languages such as Japanese, why is that? To understand what is happening, we need to know what is encoding. Compute...

Excel Shortcut key and function

Posted on January 19, 2015January 30, 2017 by Wyman W

This Excel tutorial summarizes a list of Excel shortcut key as well as Windows short cut key which are applicable to Excel. 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 ve...

Excel iterative calculation and circular reference

Posted on January 15, 2015January 15, 2015 by Wyman W

Excel iterative calculation and circular reference To understand what is Excel iterative calculation, you should first understand what is circular reference. Circular reference happens when you type a formula in one Cell which refers to another Cell, but that Cell also refers back to the Cell. For example, Cell A1: = 1+A2 Cell A2: = 1+A1 The above formula refer to each other, this is called circular reference (refer to each other forming a circle). The formula will fail and the be...