Jan 29 2012
1. Open the excel sheet, 2. Right click to any of the cell and click to the hyperlink option, or simply do Ctrl +k Insert Hyperlink dialogue box will open. 3. Give any text to display. For e.g. Click here 4. Type the cell reference : I.e. if you want to hyperlink on the [...]
By Palavi Joshi • All blogs, Excel, Microsoft • 0 • Tags: Excel 2010, hyperlinks in excel
Jan 27 2012
Transpose :- A horizontal range of cells is returned if a vertical range is entered as a parameter. Or a vertical range of cells is returned if a horizontal range of cells is entered as a parameter. ex1 : Vertical to horizontal Copy the cells from B Go to different cell, right click and select [...]
By Abhishek Joshi • All blogs, Excel, Microsoft • 1 • Tags: Excel 2010, horizontal, transpose, vertical
Jan 27 2012
From last 5 years I’m getting help from VLOOKUP, though to share with you some examples with you Ex 1 :- Find employee from column A in Column D Write “=VLOOKUP()” in cell B1, it will open “function argument” window Select “Lookup_Value” as cell “A2”, “Table_Array” as Column D and as we have selected only [...]
By Abhishek Joshi • All blogs, Excel, Microsoft • 0 • Tags: examples of vlookup, Excel 2010, formula for vlookup, Lookup_Value, Table_Array, Vlookup
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Nov | ||||||
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 | 31 | ||
Recent Comments