Excel Tips & Tricks



Dear Friends,

Excel Tips and Tricks will probably not be able to make your work SUPER easy but it will definitely make you productive. In this Section, we will be sharing small-small Tips and Tricks which can be used in our day-to-day life. Tips and Tricks must not always be related to Excel, it could be anything.

I am sure that we all know a few Tips and Tricks which make our day-to-day life easy. So let’s start sharing them and make a HUGE repository of Tips and Tricks.

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

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

Things happening AUTOMATICALLY is WOW… but NOT ALWAYS

Well friends before I start my article or tell you what I am going to talk about in this article, How many of you agree with the below incident Once...

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 languages use loop to traverse...

Excel Tip : How to save an Excel Addin (.xla) to Excel Workbook(.xls)

Hello Friends, This is a small excel tip to convert a .xla or .xlam file to .xls or .xlsm file. This is a simple trick but really helpful one 🙂 A...

5 very useful and small macros

In the first part of this article, I am going to share very small but useful VBA codes which are most frequently used in day-to-day VBA programming....

How to assign a Shortcut key to a Procedure or Subroutine

Dear LEM (Learn Exel Macro) Readers, It's been long time I wrote any article or answered any of your queries. Apologies for the delay in response. I...

How to Export an Excel Sheet as PDF file

Dear Readers, In this article you are going to learn How to save an Excel Sheet as pdf file. Many a times we generate certain reports in an Excel...

How to insert Outlook Signature in Email by Excel VBA

In this Article you are going to learn how to insert Outlook Signature in outlook email while sending an email via Excel VBA. It means while sending...