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
Chapter 2 – Excel Basics
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