Excel Compare Worksheets using Compare File

This Excel tutorial explains how to compare worksheets using Compare File function. You may also want to read: Excel VBA compare worksheets Excel Compare Worksheets using Compare File Compare worksheets is to compare worksheets of similar structures but different values. Excel has a built it function called Compare File in Office Professional Plus 2013 or Office 365 ProPlus (click here if you are using older version). After comparison is complete, two worksheets are compared side by si...
Read More

Excel protect workbook with password

This Excel tutorial explains how to protect workbook with password with VBA and without VBA. Different kinds of workbook protection There are several kinds of protection in Excel. Add password to workbook. Users are asked to open the Excel file with password. Protect workbook with password. Protect the structure of all worksheets (do not allow insert, delete, rename, move, copy, hide or unhide worksheets) Hide worksheet with password. Hide the worksheet and add a password to unhide...
Read More

Excel add password to workbook

This Excel tutorial explains how to add password to workbook with VBA and without VBA. You may also want to read Add password to all Excel workbook in folder Different kinds of workbook protection There are several kinds of protection in Excel. Add password to workbook. Users are asked to open the Excel file with password. Protect workbook with password. Protect the structure of all worksheets (do not allow insert, delete, rename, move, copy, hide or unhide worksheets) Hide w...
Read More

Excel add page number in footer

This Excel tutorial explains how to add page number in footer. E.g. add page number to all worksheets, add page numbers to specific worksheets. Excel add page number in footer to one worksheet Select the worksheet you want to add page number in footer Navigate to PAGE LAYOUT tab > Print Titles   Click on Header/Footer tab > select the desired Footer format > OK   To check the page number in print preview, Go to FILE > Print Make sure the Settings o...
Read More

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 the file ...
Read 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 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 ...
Read 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...
Read 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...
Read 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 ...
Read 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...
Read More