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...
Results for "excel"
Excel Macro : Excel VBA code to Print the Sheet
Hello Friends, Hope you are doing well !! Thought of sharing a small VBA code to help you writing a code to print the Workbook, Worksheet, Cell Range, Chart etc. .PrintOut () Method is used to print any Excel Object. Syntax of .PrintOut Method YourObj.PrintOut(From,...
Spreading data across Columns in Excel Without VBA Code
In my previous article as you learnt how to split data using VBA SPLIT() function. In this Article I am going to explain you how to separate the data across columns of a cell without excel VBA. Microsoft Excel has a built-in function called Text-to-Columns under Data...
Read and Write Document Properties of an excel Document – VBA
In this Article we will learn how to get document property of an excel workbook using Excel VBA. Before I jump in to the VBA code let's have a look Where to see document properties in Excel Document? How to see document property of an Excel document Follow the below...
Excel OFFSET Function – Excel Tutorial
Dear Friends, What is OFFSET () Function? OFFSET() is a built-in function in excel which returns a range reference which is offset a number of Rows and Columns from a specific Cell or range. Most importantly this is a function which returns Range Address and not the...
Excel Trick – Sheet Protection – Protect it and Stay Free
Dear Readers, I am back with another Excel Trick which is very much common while managing your sheet with certain security (protection). To protect the whole Worksheet can be easily done by using the Protect Sheet option available in Microsoft Excel. But in this...
Excel Trick – SMART Method to make White Background
Dear Readers, If you are a Microsoft Excel user then you must have come to a situation where you want to show you data in a particular area and rest all the area you want to make it plane white (without lines or grid). Something like depicted in below image:...
Custom Formula to Reverse a String in Excel
Dear Friends, This is a very small but useful Custom Function which can be used to reverse a string in excel. In VBA (Excel Macro) there is an Inbuilt function to reverse a string but in Excel Formula there is no formula as such to reverse a string. Using that...
Create UDF in Excel in 4 Steps – Your Own Excel Formula
ser Defined functions (UDF) is also known as Custom Functions (formulas) in Excel. So far, I have created many different User Defined Functions for different purposes but never told you about How to create Custom Functions in Excel in a systematic...
Excel VBA Tip – Expand / Collapse all the Groups in Excel
Dear Readers, This is a small VBA tip to automate to expand or collapse groups created in Excel. Before I jump to VBA code about Expanding or collapsing the groups in excel, I would like to brief you about Grouping or Outlining Functionality in Excel. It is always...
Buy a coffee for the author
Download FREE Tools and Templates
There are many cool and useful excel tools and templates available to download for free. For most of the tools, you get the entire VBA code base too which you can look into it, play around it, and customize according to your need.
What is Excel Formula?
Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. There are so many useful built-in formulas available in Excel, which makes our work easier in Excel. For all the automated work, Excel Macro is not required. There are so many automated things can be done by using simple formulas in Excel. Formulas are simple text (With a Syntax) which is entered in to the Excel Worksheet Cells. So how computer will recognize whether it is a formula or simple text? Answer is simple.. every formula in Excel starts with Equal Sign (=).
FREE Download : Send Multiple Email Tool – Ver 3.0
First of all, I would like to thank you all for appreciating and giving the feedback about Send Multiple Email - VBA...
Spreading an Array values across Rows in Excel – VBA
This is an extension to my previous Article. Where we learned the best way to spread array values across columns in...
Spreading an Array values across Columns in Excel – VBA
All my avid readers from Computer Programming backgrounds must be thinking is it a big deal? Like other programming...