Learn Microsoft Excel Online Free
Suppose we have a list of student names, and we want to lock this list if they fail the exam, and unlock them if they pass the exam, Fail or Pass will be saved in one cell for example A1, so if A1 is Fail, all cells with names will be locked, otherwise if A1… read more »
Suppose we have a long list in worksheet (1000 rows or more), and we do filter to show only some cells of the list by some criteria. If we want to keep the visible cells and remove the hidden rows to reduce redundant data and the size of file, how can we do? On the… read more »
When we launching excel workbook with external links exist in opened worksheet, update link message will pop up and ask us to update links, and we can click on ‘Update’, ‘Don’t Update’ or ‘Help’ to do more operations, or we can click close button to close it directly. Anyway, we have to close this message… read more »
Suppose we have a list of some objects in one column, and some of them are duplicate, they also can be replaced by typing different object name, here’s the question, how can we dynamically extract unique values from this list in time if they are changed frequently? This article will show you two methods to… read more »
When we launching Excel and create a new workbook, we can find that some worksheets are already created and the default sheet name is sheet1 for example. Actually, we have to rename worksheet name in most situations depends our requirement. And in our daily life we often rename worksheet name by right click or double… read more »
This post will guide you how to force test strings to uppercase or lowercase or Proper cases through an Excel formula or data validation in your Excel 2013/2016. How to convert text to upper, lower, or proper case in Excel. Assuming that you want to force text strings to Upper case when you type words… read more »
After editing current worksheet (workbook) we often want to send this workbook to others to share information or assign task directly by email. Though we can launch our Outlook mailbox, add it as attachment and then send it. Actually, we have other ways to send it through Outlook in excel directly. This article will introduce… read more »
Normally we enter a data only contains number in cell, it will be recognized as ‘Number’ in excel by default. For example, we enter ‘001’ into one cell, ‘00’ part will be dropped automatically after entering, and only ‘1’ is displayed. But if we add an apostrophe in front of number, it will be converted… read more »
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 »
