Adnan Masruf

About author

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.


Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.


B.Sc. in Naval Architecture & Marine Engineering, BUET.


C++, Python, Microsoft Suite, AutoCAD, Adobe Illustrator, ANSYS


  • Technical Content Writing
  • Undergraduate Projects
    • Design of a Stern Trawler for the Coastal Region of Bangladesh
    • A Comparative Linear Buckling Analysis of Different Isotropic Plates with and without Stiffeners for Different Boundary Conditions.


  • “The Science Behind Swing and Reverse swing” at annual magazine of ASME Student Regional Board, Asia Pacific Region

Latest Posts From Adnan Masruf

How to Insert a Page Break in Excel (4 Easy Ways)

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 ...

How to Make a Row Header in Excel (4 Easy Ways)

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. ...

How to Justify Text in Excel (3 Easy Ways)

Method 1 - Applying the Justify Command to Justify Text in Excel   1.1 Merge Multiple Cells into One Steps: Make sure that the cell into which you ...

Browsing All Comments By: Adnan Masruf
  1. 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.
    Team ExcelDemy

  2. 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”
    – 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.

  3. 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)

Advanced Excel Exercises with Solutions PDF