How to calculate years between two dates in Excel

All aspects of life revolve around time. All daily activities we do in our life also depend and revolve on time. We all need to keep track of time because…

Comments Off on How to calculate years between two dates in Excel

How to remove 0 in front of a number in Excel

When we are counting integers and digits, we rely on the 0 value as our starting point. All numbers also happen to evolve on the 0 value. The 0 value…

Comments Off on How to remove 0 in front of a number in Excel

How to freeze two rows in Excel

Each time we use excel sheets to do a recording of our collected data, there is some crucial information that we intend to keep visible all through the excel sheets.…

Comments Off on How to freeze two rows in Excel

How to freeze two columns on Excel

In excel sheets we freeze columns, rows, or cells to make them visible all through the entire excel sheet even when we scroll from top to bottom. Excel sheets provide…

Comments Off on How to freeze two columns on Excel

How to write two lines in one cell in Excel

Writing content on text editors does not only involve writing to finish the task but also to check on some of the writing requirements that include, spacing, font, grammar, wording,…

Comments Off on How to write two lines in one cell in Excel

How to remove the first four characters on Excel

When writing content on various text editors, making and doing errors is usually inevitable. We happen to make errors in all aspects of life. Errors to some extend prove we…

Comments Off on How to remove the first four characters on Excel