Latest Posts From Adnan Masruf
0
Here, we have provided a sample dataset that we will use to make a header row in Excel. As you can see, it's not particularly distinct from the data. ...
Adnan Masruf
0
In this article, we will discuss 3 easy and effective ways to justify text in Excel. The first of the 3 ways to justify text in Excel is to use the Justify ...
- « Previous Page
- 1
- …
- 3
- 4
- 5
Browsing All Comments By: Adnan Masruf
ExcelDemy Consulting Services
See Our Review at
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)