Excel Tips

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 few Tips and Tricks which makes our day-to-day life easy. So let’s start sharing them and make a HUGE repository of Tips and Tricks.

Things happening AUTOMATICALLY is WOW… but NOT ALWAYS

Tags: , , , |

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

Spreading an Array values across Columns in Excel – VBA

Tags: , , , , |

All my avid readers from Computer Programming background must be thinking is it a big deal? Like other programming languages use loop to traverse all [...]

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

Tags: , , , , |

Hello Friends,   This is a small excel tip to convert a .xla or .xlam file to .xls or .xlsm file. This is a simple [...]

How to Export an Excel Sheet as PDF file

Tags: , |

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

Allow Cell Drag and Drop Option in Excel 2003, 2007 and 2010

Tags: |

Hi Friends, Before I go and explain you how to enable or disable drag and drop option in Excel, let me explain you what is [...]

Excel Tips : Enter Current Date Without Typing in to the Cell

Tags: |

This is really a very small Tip but it is really interesting. If you want to enter current date in to a Cell then need [...]

Entering the Current Date into a Cell

Tags: |

Some times while dealing with Excel Workbook, you may need to fill a Cell with the Current Date. In such case you need to change [...]

How to Declare a Public Variable in VBA

While programming in VBA sometimes you need to declare a Public Variable which can store the value through out the program. Use of Public Variable [...]

How to Export Delimited Text File in Excel

Tags: , , , , |

In this article, I am going to show, how can we export Delimited Text Files in Excel. For Example, you have a file which is [...]

Shortcut Keys in Microsoft Excel

Tags: , |

Hello Friends, Here I am going to list down some useful Shortcut Keys. These keys are very useful in your day to day excel use. [...]