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.
Drop-down lists are an eloquent way to showcase options. It allows users to select effectively from different options. Excel has several ways to create a ...
We often need a list in a column in an Excel sheet to arrange in a horizontal orientation. We will need a delimiter to separate the texts in that horizontal ...
Charts are an eloquent way to illustrate data. The colors of the charts make it easier to understand and interpret them. So, it is essential to color the ...
The analysis of the price and volume changes is a critical component in business. It allows businessmen to analyze the current year's sales based on the ...
Salary Breakup is a very powerful way to show the how the CTC (cost-to-company) on an employee is distributed in different fields. It breaks down the CTC into ...
The Probability Density Function is a well-known statistical parameter. It shows the probability of a continuous random variable having a value in a particular ...
The Rental Payment Spreadsheet is a very powerful tool to keep track of all the rents. It allows users to arrange and calculate their rents. It can be used for ...
Age distribution graphs are very powerful tools for visualizing the ages of different genders, ethnicities, and groups of different ages. It not only gives ...
The three-column cash book is a very powerful financial tool. It allows a company to keep track of its transaction for a certain period efficiently. It is a ...
The average share price is the weighted average of different shares. Excel does not have any default function to calculate the weighted average. So, in this ...
We typically utilize the cell address or cell reference to return a cell value when performing an Excel formula. However, if you're working with a large Excel ...
We often need to work with currency data in Excel. But sometimes some numerical data are formatted in text format. One can not perform numerical operations ...
India introduced the GST system to replace some of its messy indirect tax systems. This article will discuss the components of the GST system and provide a ...
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 ...
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)