Excel Simplified

Rajan verma - Apr'12 Rajan Verma has been selected as 'Most Helpful Member' for the month of April'2012He has posted 185 posts in April 2012 and helped many people through his expertise ...
Posted May 25, 2012, 6:33 AM by Ayush Jain

Showing posts 1 - 1 of 16. View more »

Cell formula to display content, position and formatting of cell Sometimes we have many questions in mind like :How to know the cell protection status - Locked or Unlocked ?How to know the width of the cell ?How to know alignment ...
Posted Jun 11, 2011, 10:51 AM by Ayush Jain
Extract email address from sentence in cell Recently I wanted to extract email address from the sentence given in the cell. I got the below formula perfectly working to get this done.EXAMPLE :1) Hello, abc@abc ...
Posted Jun 11, 2011, 10:52 AM by Ayush Jain
Display Feet and Inches as 5' 8 1/2" When converting metric distances to English units of feet or inches, you'll end up with a decimal value. But, you may want to display the value as feet and ...
Posted Mar 26, 2011, 7:06 AM by Ayush Jain
Hidden text in Formula By using N() function you can enter hidden text in the formula. It is helpful when you want to display any information along with formula in single Cell.Example : =2018 ...
Posted Jan 30, 2011, 12:59 AM by Ayush Jain
Extract % from the Securities or any Text In finance & banking transactions, The interest rate is used in the name of many securities & transactions...If you have this data in excel sheet , then you can filter out the ...
Posted Jan 29, 2011, 11:00 PM by Ayush Jain

Showing posts 1 - 5 of 7. View more »

akoul.blogspot.com (By Ashish Koul) - May'11 This blog started in June, 2010 by Ashish Koul and today has 121+ articles on excel functions, tips and VBA Macros. The blog is regularly updated by Ashish Koul and ...
Posted Jun 12, 2011, 6:27 AM by Ayush Jain

Showing posts 1 - 1 of 3. View more »

Create an Instant Chart You can create a chart quickly in Microsoft Excel without having to use the chart button on the toolbar by using these two shortcuts whilst inside a range of data ...
Posted Apr 2, 2011, 8:43 AM by Ayush Jain
Find the currently active cell If you’ve been scrolling around your spreadsheet and you lose your place, you can jump back to the currently active cell by pressing the [Ctrl] + [Backspace] keys.
Posted Mar 24, 2011, 8:11 AM by Ayush Jain
How to hide formulas in MS Excel worksheets This trick will let you hide the formulas & keeping the worksheet usable, by performing the following steps:Select all cells (either press Ctrl+A or click on the small upper ...
Posted Feb 25, 2011, 11:24 PM by Ayush Jain
Hide the Ribbon in Office 2007 / 2010 Press Control + F1 and ribbon disappears and press again to reappear ribbon. You can also have it disappear so it will come back with a single click on any tab ...
Posted Jan 30, 2011, 7:28 AM by Ayush Jain
Inconsistent date entries You need to exercise caution when entering dates by using two digits for the year. When you do so, Excel has some rules that kick in to determine which century ...
Posted Jan 30, 2011, 7:26 AM by Ayush Jain

Showing posts 1 - 5 of 8. View more »

Store excel range in an array variable If you want to store excel range in string array variable , you can use this user define function. Public Function ReturnArraySel(xlRange As Range) As String() Dim strArray() As String ...
Posted Nov 10, 2011, 12:58 AM by Ayush Jain
Get Full Network Path of mapped drive To get the full network path of mapped drive in windows, you can use the below VBA function. The function returns the full path on input of drive name like ...
Posted Jun 26, 2011, 1:39 AM by Ayush Jain
Calculate how long macro runs If you want to know the duration of macro execution , You can use the below macro :Sub TimeTaken() Dim strTime1 As String, strTime2 As String strTime1 = Format(Now(), "mm-dd ...
Posted Jun 19, 2011, 9:12 AM by Ayush Jain
Column Number to Alphabetical reference The below function can be used to convert any Column Number into Alphabets. example :- If you pass 1 to the function, it will Return A. If you pass 26, It ...
Posted Mar 26, 2011, 7:37 AM by Ayush Jain
Add Timer to your code To create a macro to measure time before executing the next line of code use this simple code. Sub timer () Application.Wait Now + TimeValue("00:00:10") MsgBox ("10 sec ...
Posted Jan 30, 2011, 6:07 AM by ayushjain@live.com