Many time we struggle for the line break in a multiple excel cells. This article have some useful tricks that will help you to achive this e...

There are number of way to calculate age in excel, below are the example to do calculation: A B C 1 8/18/1979 2 e...

10 Excel Skills that can help you analyze data like a pro: Sparkline Power Pivots Conditional Formatting Text Formulas Slicers Flash...

Private Sub Worksheet_Activate()     Dim getHeight As Single     Dim getWidth As Single         For i = 1 To 10         getHeight = Ra...

This is one of the easy way to get File Names from your Windows Folder via "Name Manager". At first, create a new Excel work...

To fix this Issue, just follow below steps: Close all you Microsoft Excel files Goto " %appdata%\Microsoft\Excel " in Windows...

I have a request from friend to create a dynamic drop down list in excel and I would like to share with my blog reader... Part  1:  - Op...

We work lot in excel and manage our work with functions and macros. I am here creating the process that will save your time and effort to ...

Many a time I have got question about how to create XML with excel, So I decided to add this into my blog. Hope this will help the readers....

Almost everyone uses Excel in some form or fashion in the modern workforce, but many of us may be wasting a little too much time trying to ...

I got a questing about how to set alternative color in excel sheet when not using table. Steps: 1) Select the rows you want alternate co...

Simple to calculate the number of spaces of text string in EXCEL with following formula: =LEN(A1) - LEN(Substiture(A1," ",&quo...

Keyboard shortcuts are the best way to navigate cells or enter formulas more quickly. Control-Down/Up Arrow = Moves to the top or bottom...

Many of my friends have query about how to add / Subtract month in excel, Simple way of doing as below =Date( Year ( Start_Date ) + add_...

The simple way to calculate the time is sum the two time inputs, shown in below example: Use Excel built-in function SUM to calculate. Us...

When you want to create a line break (line feed) in a cell, you press Alt + Enter, to start a new line. You can put one or more line breaks...

Sub ExtractData () Dim obj For Each obj In ActiveSheet . OLEObjects If obj . progID = "Forms.HTML:TextArea.1"...

How to do Copy/Move/Insert without Ctrl+C and Ctrl+V? Select the range of cells to be copied, or moved, or inserted.  Place the cursor o...

Returns an evenly distributed random real number greater than or equal to 0 and less than 1. A new random real number is returned every time...

This post is regarding the query, that how can user protect some of the cells in a worksheet for editing. Steps to do this as follow: D...