Learn Microsoft Excel Online Free
Sometimes we create a table with formula applied to specific column. And when we editing the table, for example inserting a new row with data into the table, we want the new data lists in the specific column is also applied with this formula as well. Normally we can drag down the upper cell applied… read more »
In previous article, I have shown you the method to split data from one long column to multiple columns by VBA and Index function. This time if we want to stack data from multiple columns to one column, how can we do? Actually, we can still use VBA script or formula of Index function to… read more »
Sometimes we need to split data from a long column into a table with several columns based on some criteria like X rows or X columns. If we split data by manual, it is very complex and troublesome. So, we need a simple way to split data into multiple columns. This article will introduce you… read more »
If there are multiple worksheets exist in excel, there will be a lot of worksheet tabs in tab bar. And it is difficult to find a worksheet we want. Though we can search worksheet by right click in worksheet bar to activate worksheet, a simple and convenient way will be better especially there are a… read more »
Sometimes we want to highlight some cells based on certain criteria, for example highlight all cells which the first letter is X, this requirement is quite commonly used in searching. Actually, to implement this function, you can highlight these cells by conditional format in excel. This function can help you quickly locate and highlight the… read more »
Normally there are some redundant rows in worksheet and we have to remove them manually, and if there is a simple way to delete them by one step will be much better. If you want to delete rows under certain row or selected active cell, you will not miss this article. This article aims at… read more »
If there are some hidden worksheets exist in excel and you want delete them as they are not useful, you can unhide all worksheets and remove them one by one. This way is quite annoying and complex. If we can remove all hidden worksheets by only one step or a simple way, it will be… read more »
Sometimes we want to copy cell format to others to make cells or tables in unique format. We can check the cell format and then set the same format for the cells you want to apply the formatting, but this way is very complex and boring. We need some way simple and convenient to apply…. read more »
Sometimes we create a Macro but we don’t want trigger it by Run Macro via Developer->Run Macro or other keyboard shortcuts. We may set the trigger by clicking a specific cell like click A1 or E1 for example. Once we clicking on the specific cell A1 or E1, the Macro will run properly, it looks… read more »
Usually we often define worksheet tab name depending on the contents of this worksheet like Summary, Product List etc. But in some cases, we want to define the worksheet name equals to the text in specified cell, for example we want to the contents in A1 cell is also displayed as the worksheet tab name,… read more »
