Topic Title: Welcome

Welcome to all members, who wants learn excel. Please join this community to lear the excel fomulas & tips.

By Vikas

Mr. vikas

hello

yes i want to learn some tips & formula in excel

can u help?

By ca sanjay kumar

Hello,

Please give some Tips of Excel.....

By Anjali Arora

hello, sir

please give us excel tips to create expertise,,,,,,,i will be greatly thanksful to u,,,,

By VIC

Hello Friends, lets start ourself some Tips of Excel to share with other Members....

By Anjali Arora

Please give me some excel tips

By Rohit Gupta

Hey frnds Can you tell me about the Vlookupfunction

By cavineet sharma

can some body give the tips on excel....

By Anjali Arora

@vineet: vlookup function is difficult to explain over here...u can contact me at 9873446258. i l explain u its procedure and its usage....

By ankit singla

Oho !!!!! no tips till date ???????

By RK Birahi

Dear Mr. Vikas,

I wanted to know that when we use subtotal function in excel, we get three sheets viz:-grand total in sheet one with no details, subtotal details in sheet - 2, and all data with subtotal in sheet- 3.

Now, I want that how can I copy only sheet - 2 to any other sheets without copying any hidden rows / column.

Awaiting for your reply.

Regards,

Dhananjay

By Dhananjay Choudhary

Dear Mr. Vikas,

I wanted to know that when we use subtotal function in excel, we get three sheets viz:-grand total in sheet one with no details, subtotal details in sheet - 2, and all data with subtotal in sheet- 3.

Now, I want that how can I copy only sheet - 2 to any other sheets without copying any hidden rows / column.

Awaiting for your reply.

Regards,

Dhananjay

By Dhananjay Choudhary

till date, no tip has been updated

By Rohit Agarwal

TIPS -

1) If in Excel U have some datas in Row and u want to copy the same data and to paste in column wise it is possible in Excel

Here is the Steps,

1. Select the data which u want to paste in Column wise

2. Place the cusor where u want to paste

3. Left click the mouse in that select the PASTE SPECIAL

4. In that put tick mark in TRANSPOSE

5. Click ok

The same steps for doing Viceversa

By Vikas

Thanks for sharing

By Kshitij Nijhawan