$$Excel-Macros$$ Re: i Challenge that who ever does it, is genious in excel

2009-02-20 Thread VIRAL PANDYA
Dear All, Just FYI. this question is closed. How ever we shud start a tredition that as soon as some1's query resolved, he/she shud reply with a thanking note to the person who so ever have solved that query... Hope member will agree and start practice. Regards, Viral Pandya On Thu, Feb 19, 20

$$Excel-Macros$$ Re: i Challenge that who ever does it, is genious in excel

2009-02-20 Thread vinu
Hello Puneet, Try with ALT + Enter--> it will go to the next liine in the same cell. Regards, Vinod On Feb 18, 11:02 pm, Puneet Jain wrote: > Hi all > > How to increase the size of cell, without using function called format cell > or shrink/wrap, bcoz what happen if u have to rite a long

$$Excel-Macros$$ Re: i Challenge that who ever does it, is genious in excel

2009-02-20 Thread sarfaraz ahmed
which version of MS Excel you are using. Also, you can write formula with increasing the size of the cell and what exactly you mean by connecting to other cell. Regards, Sarfaraz Ahmed http://findsarfaraz.blogspot.com On Wed, Feb 18, 2009 at 11:32 PM, Puneet Jain wrote: > Hi all > > How to incre

$$Excel-Macros$$ Re: i Challenge that who ever does it, is genious in excel

2009-02-20 Thread Ajay Varshney
Hi Puneet, People are there in this group to help each other with their excel knowledge and not to take challenges. It would be better if you do not use such language. Hope, you understand what i mean. I hope, other members of this group would agree with me. If you have any problem and want tha

$$Excel-Macros$$ Re: i Challenge that who ever does it, is genious in excel

2009-02-20 Thread Pio
Merge the amount you'll need...? On Feb 18, 12:02 pm, Puneet Jain wrote: > Hi all > > How to increase the size of cell, without using function called format cell > or shrink/wrap, bcoz what happen if u have to rite a long formulae and u > have connect it with the cell next to it , it doesnt work

$$Excel-Macros$$ Re: i Challenge that who ever does it, is genious in excel

2009-02-20 Thread Dilip Pandey
Hi Puneet, Three ways:- 1. After typing the formula, you can reduce the size of the font to 6 or 5 as per your needs 2. You can increase the width of the column containing that cell. 3 You can consider the formula bar while applying the formula and not the cell itself, because any how the refe

$$Excel-Macros$$ Re: i Challenge that who ever does it, is genious in excel

2009-02-20 Thread Divyesh Joshi
it's simple man... just use this formula... depends on how much ur detail ur cell covers if it cover 3 cells say A1, B1 and C1 formula is =A1&""&B1&""&C1 Regards, Divyesh Joshi On 18/02/2009, Puneet Jain wrote: > > Hi all > > How to increase the size of cell, without using function called f