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.
While plotting graphs, users often need to find out or predict an unknown value relative to the present values. This allows them to forecast a result based on ...
Excel users often need to plot their data against multiple Y axes. This allows them to visualize data properly. In this article, we will show you how to plot a ...
Users often need to merge data from two columns in Excel. Often they merge data without space. That creates obscurity in the presentation of the data. So, in ...
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 ...
Microsoft Excel does not have a default function to reverse the order of the dataset. But we often need to reverse the order of our data for various data ...
The default column name in Excel, denoted by the alphabet, does not represent the actual data that the column contains. So we need to change the column name ...
In Excel, we often need to look for the presence of a value in a particular dataset so that we can know if a particular value is missing and re-enter it into ...
In analyzing datasets in Excel, we often need to find the square roots of the numerical data. The square root of any number is nothing but the application of ...
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 ...
We often need a distinct name to save our Excel files. This allows us to find our desired file among many other files. What could be more distinct than a ...
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 ...
We often need to randomly select data from our Excel sheet, especially text data. Microsoft Excel does not offer any dedicated function to select random data. ...
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 ...
Inserting tabs is simple in word processing programs like Microsoft Word. Typically, five spaces equal one tab. The goal of tabs is to make a document easier ...
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 ...
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)