Excel Tutorial
Excel Tips How To Easily Extract File Name In Folder
If you want to extract the file names of the files contained in a certain folder, put them in the worksheet for other uses, it is very troublesome to input them one by one or copy and paste them. In fact, we can use the two excel functions FILE and INDEX together to extract the file name in …
Excel Tips How To Easily Extract File Name In Folder Read More »
How To Import Filtered Excel Rows From One Excel File To Another Dynamically
This article will tell you how to import filtered excel rows from one excel file into a new excel workbook. And when the source excel rows data is changed, the data in new excel workbook will also be changed dynamically by refresh the connection. There are two method to achieve this, i will introduce them …
How To Import Filtered Excel Rows From One Excel File To Another Dynamically Read More »
How To Stop AutoCorrect In Excel
Excel auto-correct feature is very helpful when you input wrong text in an excel cell. It can help you to correct some typo mistakes. But for some time this feature is not needed so we should disable it. For example, if you want to type text ehr in an excel cell, then excel correct it …