Adnan Masruf, holding a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a pivotal role as an Excel & VBA Content Developer at ExcelDemy. His deep passion for research and innovation seamlessly aligns with his dedication to Excel. In this capacity, Masruf not only skillfully addresses challenging issues but also exhibits enthusiasm and expertise in gracefully navigating intricate situations, underscoring his steadfast commitment to consistently delivering exceptional content. His interests are Advanced Excel, Data Analysis, Charts & Dashboards, Power Query, and Excel VBA.
Users often need to find the last non-empty cell of a column. In a long dataset, it is quite time-consuming to find the last non-empty cell or the value of ...
How to Paste in Reverse Order in Excel - 7 Methods The following is the sample dataset. Method 1 - Using the Sort Command 1.1 Pasting in Reverse ...
Let's use the following sample dataset to illustrate the methods for checking missing values. Method 1 - Using Combination of IF and COUNTIF ...
A data model is an essential feature in data analysis. Using the data model, you can load data (such as tables) into Excel's memory. Then, you can tell Excel ...
In Excel, the term “hierarchy” has two distinct meanings. The first, and simpler definition refers to a particular kind of chart that aids in visualizing a ...
Excel users are sometimes faced with the problem of invisible Excel sheets. Despite their best efforts, they can not figure out this confounding problem. They ...
Let's use the following dataset to illustrate the methods of inserting a tab in a cell. Method 1 - Adding Spaces Manually Steps: Double-click ...
Users of Excel frequently need to calculate the sum of various scores. This allows them to compare the performances of the different individuals. In this ...
Zero values often create difficulties while visualizing data in a chart. They even lead to mistakes in data interpretation. Thus, hiding the zero values is ...
The dot plot is a very powerful data visualization tool. It gives a quick visual analysis of the central tendency, dispersion, and skewness of the data. ...
Excel files can often be very large. In that case, storing and sharing them becomes a problem for Excel users. They can quickly and easily share them by ...
Similar to HTML, XML is also a markup language. But unlike HTML, it is designed to store and transport data. Excel users often need to store their data in XML ...
Users frequently need to add text in Excel spreadsheet. In this way, they are able to communicate text data. They might need to add a prefix or suffix to a ...
If you use Microsoft Excel frequently, you may have run into the problem of a messy and cumbersome worksheet with a lot of empty cells that are useless. This ...
While working with a big data set, users may need to separate their data into different segments for the purpose of individual analysis as well as better ...
ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems.
Contact | Privacy Policy | TOS
Dear Nirmal,
Could you please provide me with your Excel file that you have mentioned or some screen shots from your dataset? That would help me to understand your dataset and answer your query accordingly.
Thanks for your query.
Regards,
Adnan
Team ExcelDemy
Dear Raman,
1. First, make sure you are using MS Office 365 as they are only available in that version.
2. Secondly, make sure you are logged into your MS Excel account.
3. Thirdly, make sure to have the English, French, German, Italian, Spanish, or Portuguese editing language added to Office Language Preferences.
If these do not work then,
-Go to File > Options > Trust Center > Trust center Settings > External Content > Security settings for “Linked data types” > Activate “Enable all Linked Data Types”
or
– Go to Options>Customize Ribbon> All Commands
– Then, choose the Datatype Command
-Add the command to a “New Group”
-Finally, restart your Excel Application.
*Also, make sure to keep your internet connection ON; as this data type is linked datatype.
*You should also see if this datatype is available in your geopolitical locaton.
Dear K,
Thanks for your query. If we add replies to the comments (Like the first picture), we can find the replies by simply looking at the initials without changing the macros (Like the second picture)