How to merge columns without losing data

How to merge columns without losing data

One of the problems that occur when merging is loosing of data. Regardless of the excel version in use, when you merge columns of data in excel, only the left column data is kept and the data in the other columns will be deleted. The guide below is going to help you know how you

How to Delete Excel Add-Ins

How to Delete Excel Add-Ins

An Add-in is a file that contains macros. This means that it allows you to extend the functions of Excel applications across various platforms apart from Windows. That is Mac, iPad, and browser. Excel add-ins are mostly stored here C: /Users/[username]/AppData/Roaming/Microsoft/AddIns/. Once it is in Microsoft Excel, and Add-in automatically opens itself every time Excel

How to Get Loan Amortization Schedule in Excel

How to Get Loan Amortization Schedule in Excel

To start it all up, loan amortization is a fancy way to define a loan that is paid back in installments throughout the entire term of the loan. So, all loans are amortized in nature in one way or another. To elaborate all this in a simpler method let me give you an example; if

How to Disable Scroll Lock In Excel

How to Disable Scroll Lock in Excel

Scroll lock is a setting that helps to determine what happens when you use the Arrow keys on the keyboard in excel. The arrow keys allow you to navigate and select different cells in a worksheet when the scroll lock is disabled. There are a number of ways of disabling scroll lock depending on the