{"id":4027,"date":"2014-06-19T13:27:47","date_gmt":"2014-06-19T13:27:47","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/wp\/?p=4027"},"modified":"2017-07-20T15:03:57","modified_gmt":"2017-07-20T15:03:57","slug":"excel-cell-masking-for-password","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/","title":{"rendered":"Excel Tip : How to Make an Excel Cell secured for Password"},"content":{"rendered":"

One of my friend wanted me to write an article on How can a person achieve making an Excel Cell behave like a password text box which is masked and secured. I have tried to achieve that up to some extent but not 100%. Go through with this article and provide your feedback or suggestion regarding this topic !!. You will find an Excel Workbook with the example to play around with it.<\/p>\n

\"Download<\/a><\/p>\n

With the help of this Tutorial I am going to explain you – How can you make your excel cell behave like a Password TextBox where your password is masked and no one can see or copy your entered password<\/strong>. At the end of this article you will be able to achieve following things:<\/p>\n

1. Your Password will not be visible to any one (It will be masked like ************ this ). Note that no one can see the password even in the formula bar<\/p>\n

2. Copying the password will not be possible too.<\/p>\n

3. Once you have typed your password and someone tries to click on the cell to edit it then cell will be cleared and you need to enter your whole password again.<\/p>\n

Note:<\/h3>\n

The only problem with this masking is that typing of the Password can not be masked.<\/i> It means while typing you will be able to see what are you typing in the cell. You password will be masked and hidden as soon as you come out of that cell.<\/p><\/blockquote>\n

Before I jump to explain the step-by-step tutorial to make your password cell masked, I would like to tell you that this method is not using any VBA or Excel macro. It is purely done by Excel WorkSheet built-in functions.<\/p>\n

Follow the below steps to make your excel cell work as a masked password text box.<\/p>\n

Step 1: Set your Cell or Cell Range as Hidden but NOT Locked<\/h1>\n

First of all you need to decide which range or cells you want to allow users to edit. Why is this required here at first step?? — because this masking is going to be achieved by Protecting the sheet hence you should know those cells which are needs to be made a editable even after protecting the sheet. Refer this article to know how to protect the sheet except few cells or range.<\/a><\/i><\/p>\n

i)<\/strong> Select all your cells or range which has to be made editable (including the Password cell as well)<\/p>\n

ii)<\/strong> Right Click and go to Format Cells -> Protection Tab as shown in below picture:<\/p>\n

 <\/p>\n

<\/p>\n

iii)<\/strong> Now Select your Password<\/i> cell which you want to make it as masked.<\/p>\n

iv)<\/strong> Right click and again go to Format Cells –> Protection Tab (as shown in above picture)<\/i><\/p>\n

v)<\/strong> Now Check the Hidden<\/strong> check-box for your Password Cell as shown in the below picture:<\/p>\n

\"Make-Cell-Hidden\"<\/p>\n

Step 2: Custom Masking (Custom Formatting) of Password Cell<\/h1>\n

Now you need to Custom Format your password cell so that after typing your password it shows ********<\/strong> a masked password. To do so follow below steps:<\/p>\n

i)<\/strong> select the password cell<\/p>\n

ii)<\/strong> Right Click –> Format Cells –> Number Tab<\/p>\n

iii)<\/strong> Select category as Custom<\/strong><\/p>\n

iv<\/strong> Enter type as ;;;**<\/strong> and Click OK as shown in below picture:<\/p>\n

>\"Custom-Formatting<\/p>\n

— This formatting will show Star(*)<\/i> in full cell. It means no matter how many letters you have typed in your cell but once you come out of the cell, your cell will be shown as full of Stars *.<\/p>\n

Now you are done with all the necessary formatting which is required before you Protect your Sheet<\/h2>\n

Step 3: Protect your WorkSheet<\/h1>\n

Protect your WorkSheet with all default options selected. To know more about protecting a WorkSheet..read this article<\/a>. It is recommended that you pass a valid password to protect your sheet if you really want to make your password protected \ud83d\ude42<\/p>\n

Yes now you are done with your Password Cell masking without using a Text Box. Let’s see few examples<\/h2>\n

Example:<\/h1>\n

I have created one Excel WorkSheet by following the above steps for Simple Login page to login in to HP Quality Center.<\/p>\n

Those who are from Testing or Development team, may be knowing about HP Quality Center :). For those who does not know – HP QC is Test Management Tool used for complete test management like, requirement management, test case management, defect management etc. That application can be accessed through VBA to fetch different kind of data and reports. To know more about the HP QC related VBA codes go through the HP QC VBA tutorial page.<\/a><\/p><\/blockquote>\n

In this example I have created a Protected Sheet (password: Vishwa123<\/i>) with a password field which is masked. Refer the below picture on how masking is happening in the sheet as soon as you come out of the cell after typing your password. (Note: You can not copy or edit an already typed password<\/i>)
\n\"Masked<\/p>\n

Important Point to Note:<\/h1>\n

Password masking was done with above method easily. But what is the impact on a VBA code which is going to read this particular cell value. Cell G11 is the password cell in the above example. There to read this value in VBA you can write a simple statement like:<\/p>\n

varPWD = Range(“G11”).value<\/i><\/strong><\/p>\n

But the question is: Will the above statement return the hidden and masked password?? And the ANSWER is a BIG NO. Above statement will always return an empty password. Then what is the solution read the hidden password in my VBA code. If this is not possible then there is no use of above masking \ud83d\ude42<\/p>\n

Solution<\/h1>\n

To read the above masked and hidden password you need to put a VBA statement to UnProtect the Sheet and then read the password and then again protect the sheet back with the same password. Hence the above simple statement will be replaced by the below statements:<\/p>\n

\r\n'First Disable the  Screen updating so that \r\n'user does not see any password while VBA \r\n'Unprotecting\/protecting the Sheet\r\nApplication.ScreenUpdating = False\r\n'Now UnProtect the Sheet\r\nWorkSheets("Sheet3").Unprotect Password:="Vishwa123"\r\n'Read the password field Value now\r\nqcPassword = Range("G11").Value\r\n'Again protect the sheet back with the same password\r\nWorkSheets("Sheet3").Protect Password:="Vishwa123"\r\n'Now enable the screen update back\r\nApplication.ScreenUpdating = True\r\n<\/code><\/pre>\n
VBA Code to Connect to Quality Center with a Masked and Hidden Password Cell<\/h1>\n
\r\nFunction Connect_To_QC\r\nDim qcURL As String\r\nDim qcID As String\r\nDim qcPassword As String\r\nDim qcDomain As String\r\nDim qcProject As String\r\nDim tdConnection As Object\r\n\r\n'To read all visible values from the cells\r\nqcURL = Range("qcURL").Value\r\nqcID = Range("qcID").Value\r\nqcDomain = Range("qcDomain").Value\r\nqcProject = Range("qcProject").Value\r\n\r\n'To read the hidden password\r\nApplication.ScreenUpdating = False\r\nWorksheets("Sheet3").Unprotect Password:="Vishwa123"\r\nqcPassword = Range("qcPassword").Value\r\nWorksheets("Sheet3").Protect Password:="Vishwa123"\r\nApplication.ScreenUpdating = True\r\n\r\nOn Error GoTo err\r\n'Display a message in Status bar\r\n   Application.StatusBar = "Connecting to Quality Center.. Wait..."\r\n' Create a Connection object to connect to Quality Center\r\n   Set tdConnection = CreateObject("TDApiOle80.TDConnection")\r\n'Initialise the Quality center connection\r\n   tdConnection.InitConnectionEx qcURL\r\n'Authenticating with username and password\r\n   tdConnection.Login qcID, qcPWD\r\n'connecting to the domain and project\r\n   tdConnection.Connect qcDomain, qcProject\r\n'On successfull login display message in Status bar\r\n   Application.StatusBar = "........QC Connection is done Successfully"\r\n   Exit Sub\r\nerr:\r\n'Display the error message in Status bar\r\nApplication.StatusBar = err.Description\r\nEnd Function\r\n<\/code><\/pre>\n
Download your FREE WorkBook<\/h1>\n
Get your free workbook to download and play around:) Enjoy !<\/p>\n

<\/p>\n<\/span>","protected":false},"excerpt":{"rendered":"
One of my friend wanted me to write an article on How can a person achieve making an Excel Cell behave like a password text box which is masked and secured. I have tried to achieve that up to some extent but not 100%. Go through with this article and provide your feedback or suggestion […]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1673,1246,1675,1678,1682],"tags":[],"class_list":["post-4027","post","type-post","status-publish","format-standard","hentry","category-excel-functions","category-macro","category-excel-macro-for-beginners","category-interesting-vba-functions","category-popular-articles"],"yoast_head":"\nExcel Tip : How to Make an Excel Cell secured for Password - Let's excel in Excel<\/title>\n<meta name=\"description\" content=\"An Easy way to make your excel cell behave like a Password TextBox where your password is masked and no one can see or copy your entered password. You can also download a free workbook to play around with\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Tip : How to Make an Excel Cell secured for Password\" \/>\n<meta property=\"og:description\" content=\"An Easy way to make your excel cell behave like a Password TextBox where your password is masked and no one can see or copy your entered password. You can also download a free workbook to play around with\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/\" \/>\n<meta property=\"og:site_name\" content=\"Let's excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2014-06-19T13:27:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-07-20T15:03:57+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/learnexcelmacro.com\/wp\/wp-content\/uploads\/sites\/11\/2012\/06\/download_page_button.jpg\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Excel Tip : How to Make an Excel Cell secured for Password\",\"datePublished\":\"2014-06-19T13:27:47+00:00\",\"dateModified\":\"2017-07-20T15:03:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/\"},\"wordCount\":1065,\"commentCount\":8,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/download_page_button.jpg\",\"articleSection\":[\"Excel Functions\",\"Excel Macro\",\"Excel Macro Tutorial\",\"Interesting VBA Functions\",\"Popular Articles\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/\",\"name\":\"Excel Tip : How to Make an Excel Cell secured for Password - Let's excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/download_page_button.jpg\",\"datePublished\":\"2014-06-19T13:27:47+00:00\",\"dateModified\":\"2017-07-20T15:03:57+00:00\",\"description\":\"An Easy way to make your excel cell behave like a Password TextBox where your password is masked and no one can see or copy your entered password. You can also download a free workbook to play around with\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/download_page_button.jpg\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/download_page_button.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Functions\",\"item\":\"https:\/\/vmlogger.com\/excel\/excel-functions\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel Tip : How to Make an Excel Cell secured for Password\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let's share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Excel Tip : How to Make an Excel Cell secured for Password - Let's excel in Excel","description":"An Easy way to make your excel cell behave like a Password TextBox where your password is masked and no one can see or copy your entered password. You can also download a free workbook to play around with","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/","og_locale":"en_US","og_type":"article","og_title":"Excel Tip : How to Make an Excel Cell secured for Password","og_description":"An Easy way to make your excel cell behave like a Password TextBox where your password is masked and no one can see or copy your entered password. You can also download a free workbook to play around with","og_url":"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2014-06-19T13:27:47+00:00","article_modified_time":"2017-07-20T15:03:57+00:00","og_image":[{"url":"http:\/\/learnexcelmacro.com\/wp\/wp-content\/uploads\/sites\/11\/2012\/06\/download_page_button.jpg"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Excel Tip : How to Make an Excel Cell secured for Password","datePublished":"2014-06-19T13:27:47+00:00","dateModified":"2017-07-20T15:03:57+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/"},"wordCount":1065,"commentCount":8,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/download_page_button.jpg","articleSection":["Excel Functions","Excel Macro","Excel Macro Tutorial","Interesting VBA Functions","Popular Articles"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/","url":"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/","name":"Excel Tip : How to Make an Excel Cell secured for Password - Let's excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/download_page_button.jpg","datePublished":"2014-06-19T13:27:47+00:00","dateModified":"2017-07-20T15:03:57+00:00","description":"An Easy way to make your excel cell behave like a Password TextBox where your password is masked and no one can see or copy your entered password. You can also download a free workbook to play around with","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/download_page_button.jpg","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/download_page_button.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Functions","item":"https:\/\/vmlogger.com\/excel\/excel-functions\/"},{"@type":"ListItem","position":3,"name":"Excel Tip : How to Make an Excel Cell secured for Password"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let's share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/4027"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=4027"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/4027\/revisions"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=4027"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=4027"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=4027"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}